Premium boutique software development company that helps brands with big ideas to make a difference in people’s lives.
Senior Database Administrator – Software
Location
Latin America
Posted
7 days ago
Salary
0
Seniority
Senior
Job Description
Senior Database Administrator – Software
Truelogic Software
• Data Pipeline Execution (ETL): Build, manage, and monitor efficient ETL/ELT pipelines to consolidate data from multiple production AWS PostgreSQL instances into Snowflake for analytics and reporting. • Advanced Query Auditing & Performance Tuning: Continuously audit SQL queries across our production systems. Diagnose complex bottlenecks, rewrite sub-optimal queries, optimize indexes, and tune database configurations to ensure peak platform speeds. • Database Operations & Maintenance: Oversee the day-to-day health, backup strategies, security compliance, and scaling of our PostgreSQL (AWS RDS/Aurora) and Snowflake environments. • Query Best Practices & Collaboration: Partner with Software Engineers to review database schemas and queries before they hit production, acting as a trusted advisor on SQL best practices. • Troubleshooting & Optimization: Serve as the senior escalation point for database performance issues, ensuring minimal downtime and high availability for our core SMS services.
Job Requirements
- 5+ years of experience in Database Administration, Database Engineering, or a heavily database-focused Data Engineering role.
- PostgreSQL Expertise: Deep hands-on experience managing and tuning PostgreSQL databases, specifically within the AWS ecosystem (RDS or Aurora).
- Snowflake Proficiency: Strong experience working with Snowflake, including data loading, performance tuning, and warehouse cost management.
- Advanced SQL Profiling: Exceptional skills in query profiling, execution plan analysis (EXPLAIN), partition strategies, and index optimization.
- Hands-on ETL/ELT: Proven experience building and maintaining data pipelines using tools like dbt, Airflow, AWS Glue, or custom Python scripting.
- Data Migration & Synchronization: Core experience using AWS Data Migration Service (DMS) to move and continuously synchronize data between relational databases and data warehouses.
- Version Control: Absolute proficiency with Git.
Benefits
- 100% Remote Work: Enjoy the freedom to work from the location that helps you thrive. All it takes is a laptop and a reliable internet connection.
- Highly Competitive USD Pay: Earn an excellent, market-leading compensation in USD, that goes beyond typical market offerings.
- Paid Time Off: We value your well-being. Our paid time off policies ensure you have the chance to unwind and recharge when needed.
- Work with Autonomy: Enjoy the freedom to manage your time as long as the work gets done. Focus on results, not the clock.
- Work with Top American Companies: Grow your expertise working on innovative, high-impact projects with Industry-Leading U.S. Companies.
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
Database Administrator
StratagenStratagen is a HUBZone Certified, General Services Administration (GSA) Schedule holder, small business located in West Virginia. As a U.S. Federal Government contractor, Stratagen provides Information Technology, Analytical, and Program Management Support. Stratagen Consulting specializes in custom IT solutions, IT Operations, System Engineering, Infrastructure Management, Program Budgeting, Master Scheduling, IT Security, System Integration, and Database Administration. Stratagen’s leadership team has over 60 years of combined experience and business knowledge in the Federal space. Using industry best practices and best value solutions, the company’s mission is to provide the U.S. Government with quality personnel and support to enhance the Nation’s efforts for national security and public safety. Location: Remote with occasional travel to government site in Clarksburg, West Virginia.
Role Description We are seeking a highly skilled and motivated Database Administrator with an active Secret security clearance to join our dynamic team. In this role, you will be responsible for managing, maintaining, and optimizing complex database systems to ensure high availability, security, and performance. Your expertise will support critical operations by implementing robust database solutions, performing performance tuning, and ensuring data integrity across multiple platforms. This position offers an exciting opportunity to work on mission-critical projects that require precision, innovation, and a proactive approach to database management. Qualifications - Active Secret Security Clearance - 4 Year Degree in Information Technology or related field or equivalent experience - Minimum 3 years experience Requirements - Database experience of working in different OS platforms like Linux, RHEL and Windows - Experience in Oracle/Postgres database administration, support, implementation, configuration and upgrade - Solid understanding of SQL (writing, optimizing queries, normalization and indexing) - Experience with backup & recovery (pg_dump, pg_basebackup, PITR) - Experience in Oracle/Postgres database performance tuning using explain plans and monitoring tools - Working experience of AWS Cloud Services (Cloud Watch, Cloud Trail, EC2) and Databases (Oracle, Aurora & Postgres RDS) - Strong understanding of postgres schema, user roles, access control and security model - Postgres script writing (PL/pgSQL) with loops, conditions and variables - Performance tuning, hardware replacement, firmware upgrades, and patching to all COTS software products, including operating systems - Experience in shell scripting to enhance and update daily monitoring tasks Benefits - 401(k) - 401(k) matching - Dental insurance - Flexible spending account - Health insurance - Life insurance - Paid time off - Professional development assistance - Retirement plan - Vision insurance Company Description Stratagen is a HUBZone Certified, General Services Administration (GSA) Schedule holder, small business located in West Virginia. As a U.S. Federal Government contractor, Stratagen provides Information Technology, Analytical, and Program Management Support. Stratagen Consulting specializes in custom IT solutions, IT Operations, System Engineering, Infrastructure Management, Program Budgeting, Master Scheduling, IT Security, System Integration, and Database Administration. Stratagen’s leadership team has over 60 years of combined experience and business knowledge in the Federal space. Using industry best practices and best value solutions, the company’s mission is to provide the U.S. Government with quality personnel and support to enhance the Nation’s efforts for national security and public safety. Location: Remote with occasional travel to government site in Clarksburg, West Virginia.
Senior Database Administrator
ICFFounded in 1969, ICF is a global advisory and technology services company headquartered in Reston, Virginia. It delivers data-driven solutions across energy, environment, infrastru
Title: Senior Database Administrator (Top Secret cleared) Location: Washington, DC Remote Full time Job Description: The Work: ICF is seeking an experienced and driven Database Administrator to lead and oversee mission-critical initiatives in support of the Defense Counterintelligence and Security Agency (DCSA). In this role, this individual will provide technical leadership and strategic oversight for enterprise database environments, ensuring high availability, performance, integrity, and security of mission data. They will guide database architecture decisions, oversee operational stability, and serve as a trusted advisor to government stakeholders on database strategy and risk management. Job Location: This position is remote but will need to live in the Washington DC metro area. If you accept this position, you should note that ICF does monitor employee work locations and blocks access from foreign locations/foreign IP addresses, and also prohibits personal VPN connections. You may be asked to travel once a quarter to an office or client site. Our core work hours are 8am - 5pm Eastern Time with the option to start earlier or work later depending on your time zone. What You Will Do: - Lead the design, implementation, and optimization of enterprise database architectures, including schema design, data modeling, and structural configurations. - Provide technical oversight for Oracle and/or Microsoft SQL Server environments, ensuring databases are highly available, resilient, and operating error-free. - Establish and enforce database security standards, ensuring compliance with federal and DoW security requirements, including access controls, auditing, encryption, and vulnerability remediation. - Oversee database patching, upgrades, and lifecycle management activities in accordance with change control and security policies. - Direct performance monitoring, capacity planning, and tuning efforts to ensure optimal database efficiency and scalability. - Lead troubleshooting and root cause analysis for complex database accessibility, performance, and data integrity issues. - Provide leadership and mentorship to database administrators and technical staff, and communicate database changes or impacts to stakeholders and end users. - Serve as the primary database technical point of contact for government leadership, supporting audits, reviews, and executive briefings. - Prepare and deliver executive-level briefings, status reports, and performance updates to government stakeholders and corporate leadership. - Maintain a positive, results-oriented work environment by building partnerships with internal and external partners. What You Will Bring With You: - 8-10 years of progressive experience administering and leading enterprise database environments, including architectural design and operational oversight. - Active Top Secret clearance. What We Would Like You To Bring With You: - Bachelor's degree in Cybersecurity, Computer Science, Information Technology, or related technical field. - 2 years' experience working with DCSA - 5 years' experience with working on/around cloud platforms in AWS. - Ability to self-organize, priorities and conduct research on multiple projects under tight deadlines in a fast-paced environment. - Deep expertise in Oracle and/or Microsoft SQL Server, including high-availability configurations (e.g., Data Guard, Always On), performance tuning, backup/recovery, and patch management. - Demonstrated experience supporting databases in secure, regulated federal or DoW environments. - Strong understanding of database security controls, STIG implementation, RMF alignment, and compliance frameworks. - Experience supporting cloud-hosted database environments (e.g., AWS GovCloud or similar secure cloud platforms). - Proven leadership experience overseeing technical teams and serving as a senior advisor to stakeholders. - Experience supporting systems within regulated or high-security environments. - An ability to communicate and write clearly in English. Professional Skills: - Highly effective analytical, problem-solving, and decision-making capabilities. - Excellent communication and interpersonal skills to interface effectively at all levels of the business. Working at ICF ICF is a global advisory and technology services provider, but we're not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future. We can only solve the world's toughest challenges by building a workplace that allows everyone to thrive. We are an equal opportunity employer. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. We will consider for employment qualified applicants with arrest and conviction records. Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, in all phases of the application and employment process. To request an accommodation, please email Candidateaccommodation@icf.com and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. Read more about workplace discrimination rights or our benefit offerings which are included in the Transparency in (Benefits) Coverage Act. Candidate AI Usage Policy At ICF, we are committed to ensuring a fair interview process for all candidates based on their own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) tools to generate or assist with responses during interviews (whether in-person or virtual) is not permitted. This policy is in place to maintain the integrity and authenticity of the interview process. However, we understand that some candidates may require accommodation that involves the use of AI. If such an accommodation is needed, candidates are instructed to contact us in advance at candidateaccommodation@icf.com. We are dedicated to providing the necessary support to ensure that all candidates have an equal opportunity to succeed. Pay Range - There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position. The pay range for this position based on full-time employment is: $130,687.00 - $222,169.00 DC Remote Office (DC99)
Database Administrator – Infrastructure
Mark43Cloud Native Computer-Aided Dispatch, Records Management, and Analytics
• Own and improve the reliability, performance, security, and scalability of production database systems. • Lead database monitoring, alerting, capacity planning, backup, recovery, replication, and disaster recovery practices. • Identify, diagnose, and resolve complex database performance and availability issues. • Partner with engineering teams on schema design, indexing strategies, query optimization, and safe database change management. • Lead technical planning for database migrations, upgrades, scaling strategies, and operational improvements. • Improve infrastructure-as-code, automation, observability, and repeatability across database operations. • Define and maintain database runbooks, operational standards, and production readiness criteria. • Participate in and, when appropriate, lead database-related incident response, post-incident reviews, and remediation planning. • Collaborate with security, compliance, and delivery teams to meet customer, regulatory, and vetting requirements. • Provide technical guidance and mentorship to engineers, DBAs, and operational teams. • Represent database reliability concerns in architecture reviews, roadmap planning, and customer-readiness discussions. • Help build the operational foundation required to support UK police customers and future UK public safety partners.
Database Architect, DBA
BlastPointA.I.-driven customer intelligence tools that give companies the power to discover & engage the humans in their data.
• Own database architecture, performance, reliability, security, and scalability for core platform systems. • Use AI tools responsibly to accelerate database analysis, documentation, query tuning, troubleshooting, and workflow improvement. • Design database approaches for both single-tenant and multi-tenant SaaS environments, including migration strategies between tenancy models. • Improve tenant isolation, customer-specific data separation, scalability, and compliance-ready data architecture. • Review and improve schemas, indexes, queries, migrations, and data access patterns. • Optimize SQL performance, indexing strategies, execution plans, and database bottlenecks. • Partner with Engineering and Data Engineering on schema design, data modeling, migrations, pipelines, and performance-sensitive application changes. • Help define database strategies across OLTP systems, OLAP workloads, reporting layers, and data pipelines. • Strengthen database security practices, including encryption at rest, field-level encryption, column-level encryption, key management, access controls, and auditability. • Establish practical standards for database migrations, rollback planning, production readiness, monitoring, backups, and disaster recovery. • Support load testing, capacity planning, and performance benchmarking for critical workflows. • Collaborate with DevOps on AWS-hosted database infrastructure, environment strategy, access controls, and cost optimization.



