Mactores logo
Mactores

Mactores is a trusted leader among businesses in providing modern data platform solutions.

Senior Database Administrator – Freelancer

Database AdministratorDatabase AdministratorFull TimeRemoteSeniorTeam 51-200Since 2008H1B No SponsorCompany SiteLinkedIn

Location

India

Posted

144 days ago

Salary

0

Seniority

Senior

Job Description

Senior Database Administrator – Freelancer

Mactores

• Design, set up, configure, and manage Amazon Aurora PostgreSQL clusters. • Configure parameters, maintenance windows, monitoring, and scaling strategies. • Ensure high availability, fault tolerance, and operational readiness. • Perform user, role, and privilege mapping from Oracle to PostgreSQL. • Implement least-privilege access, role hierarchies, and security best practices. • Support audit and compliance requirements. • Configure, run, monitor, and optimize AWS DMS tasks (Full Load and CDC). • Troubleshoot DMS latency, data mismatches, and performance issues. • Tune DMS settings for large-volume and high-throughput workloads. • Perform server and database performance tuning (CPU, memory, I/O, connections). • Tune PostgreSQL parameters, autovacuum, indexing, and query behavior. • Proactively identify and resolve performance bottlenecks. • Design and implement backup and restore strategies. • Define and test disaster recovery (DR) and failover procedures. • Support cross-region replication and recovery drills. • Lead post–go-live stabilization activities. • Monitor production workloads and resolve incidents. • Act as L3 escalation point for database-related production issues. • Provide operational documentation and handover support.

Job Requirements

  • 5+ years of experience administering Amazon Aurora PostgreSQL
  • Proven expertise in Oracle to PostgreSQL migration support
  • Hands-on experience with AWS DMS
  • Advanced PostgreSQL performance tuning and troubleshooting skills
  • Strong knowledge of backup, restore, and DR planning in AWS
  • Experience with AWS monitoring tools (CloudWatch, Performance Insights)
  • Strong problem-solving and root-cause analysis abilities
  • Experience working in production and post–go-live environments
  • Ability to work independently as an L3 escalation engineer
  • Clear communication and documentation skills|

Related Categories

Related Job Pages

More Database Administrator Jobs

BHG Financial logo

Senior Database Administrator

BHG Financial

BHG is the original disruptor in business working capital and unsecured consumer loans.

OtherRemoteTeam 1,001-5,000Since 2001H1B No Sponsor

•Design, implement, and administer Microsoft SQL Server environments (on-premises and/or cloud) •Experience with On Prem SQL, Azure SQL and Managed Instance. •Strong experience work with large Terabyte databases. •Develop, optimize, and maintain complex T-SQL code including stored procedures, functions, views, triggers, and indexes •Perform advanced query tuning and execution plan analysis to improve performance •Monitor database health, capacity, and performance using native and third-party tools •Implement and manage High Availability and Disaster Recovery (HA/DR) solutions (Always On) •Expert level setup and administration of SQL clusters and always on Availability Groups. •Manage and implement Change Data Capture •Manage backup, restore, and recovery strategies; perform regular DR testing •Ensure database security through role-based access, encryption, auditing, and compliance controls •Troubleshoot and resolve production issues, root-cause analysis, and performance bottlenecks •Automate administrative tasks using T-SQL, SQL Agent jobs, and PowerShell •Collaborate with developers to enforce database design and coding best practices •Support application releases, schema changes, and data migrations with minimal downtime •Experience working with sensitive data and removing data from lower environments. •Strong experience working with Auditing solutions – SQL Audit, Extended Events or custom monitoring accounts and user access.

United States
Job Closed
Rentokil Initial logo

Global Database Administrator

Rentokil Initial

Global leaders in Pest Control, Hygiene, Plants & Scenting services

Full TimeRemoteTeam 10,001+Since 1925H1B No Sponsor

• SQL Database Administrator (DBA) is responsible for providing end-to-end database support for all our data systems. • This includes the design, implementation, maintenance, and security of SQL Server and other database platforms (MySQL, PostgreSQL and Cloud DBs) to ensure optimal performance, availability, and data integrity. • You will play a pivotal role in ensuring the stability, performance, and availability of our databases, driving continuous improvement, and fostering a culture of excellence within the team. • Provide 24/7 Database Administration support for our diverse and mission-critical database environments. • Install, configure, manage, and maintain Microsoft SQL Server environments. • Monitor database performance, diagnose issues, and implement performance tuning strategies for queries, indexes, and database configurations. • Implement and manage high availability solutions and disaster recovery plans. • Manage database security, including user permissions, roles, authentication, and encryption. • Upgrade MySQL databases (Community and/or Enterprise editions). • Manage multiple database environments, including production, development, QA, and staging. • Perform regular health checks, capacity planning, and proactive monitoring of databases. • Schedule and manage routine maintenance tasks, and develop scripts to automate administrative and monitoring processes. • Rapidly diagnose and resolve database-related issues and maintain comprehensive documentation for database configurations, procedures, and troubleshooting steps.

India
Rentokil Initial logo

Global Database Administrator

Rentokil Initial

Global leaders in Pest Control, Hygiene, Plants & Scenting services

Full TimeRemoteTeam 10,001+Since 1925H1B No Sponsor

Role Description SQL Database Administrator (DBA) is responsible for providing end-to-end database support for all our data systems. This includes the design, implementation, maintenance, and security of SQL Server and other database platforms (MySQL, PostgreSQL and Cloud DBs) to ensure optimal performance, availability, and data integrity. The role is part of the team responsible for the day-to-day management of database services hosted within all regional data centers. You will play a pivotal role in ensuring the stability, performance, and availability of our databases, driving continuous improvement, and fostering a culture of excellence within the team. We are seeking an experienced and highly skilled DBA to join our dynamic Global IT Operations team. This critical role is responsible for providing 24/7 Database Administration support for our diverse and mission-critical database environments. Tasks and Responsibilities - Database Administration: Install, configure, manage, and maintain Microsoft SQL Server environments. - Performance Tuning: Monitor database performance, diagnose issues, and implement performance tuning strategies for queries, indexes, and database configurations. - High Availability and Disaster Recovery (HADR): Implement and manage high availability solutions (e.g., Always On, clustering, replication) and disaster recovery plans (backups, recovery models). - Security: Manage database security, including user permissions, roles, authentication, and encryption, ensuring compliance with internal and external standards. - Install, configure, and upgrade MySQL databases (Community and/or Enterprise editions). - Manage multiple database environments, including production, development, QA, and staging. - Perform regular health checks, capacity planning, and proactive monitoring of MSSQL, MySQL and other DB instances. - Maintenance and Automation: Schedule and manage routine maintenance tasks, and develop scripts (e.g., PowerShell, T-SQL) to automate administrative and monitoring processes. - Troubleshooting: Rapidly diagnose and resolve database-related issues, including connectivity, performance degradation, and corruption. - Documentation: Maintain comprehensive documentation for database configurations, procedures, and troubleshooting steps. Qualifications - 5+ years of hands-on, progressive Microsoft SQL Server Administration experience. - Strong practical experience with database backup/restore, recovery models, and HADR technologies. - Proven expertise in database performance monitoring and tuning. - Familiarity with the administration of MySQL and/or PostgreSQL database systems. - Demonstrated experience managing or supporting databases on Cloud DB Platforms (e.g., GCP). - Solid understanding of operating systems (Windows Server, Linux/Unix) as they relate to database environments. - Strong experience in Incident/ Request/ Change/ Problem management. - Solid understanding of RDBMS concepts, ACID properties, transactions, and isolation levels. Knowledge & Skills - Microsoft SQL Server: Deep proficiency in the administration, configuration, and maintenance of all SQL Server versions. - Performance Tuning: Expert knowledge of SQL query optimization, indexing strategies, execution plan analysis, and database/server-level performance tuning. - High Availability & DR (HADR): Proven experience implementing and managing SQL Server HA/DR solutions (e.g., Always On Availability Groups, Clustering, Mirroring, Replication). - Backup & Recovery: Mastery of backup strategies, recovery models, and performing point-in-time and advanced database recovery operations. - Security: Strong skills in managing security models, authentication, user/role permissions, encryption, and audit policies. - Other RDBMS: Working knowledge and administration experience with MySQL and/or PostgreSQL. - Cloud DB Platforms: Practical experience managing or supporting databases deployed on major Cloud Database Services (e.g., Google Cloud SQL, AWS RDS, Azure SQL Database). - Progress Database: Familiarity with the administration and maintenance of Progress databases is a plus. - Operating Systems: Solid understanding of Windows Server and/or Linux operating system concepts related to database hosting and resource management. - T-SQL & Scripting: Strong proficiency in writing and troubleshooting complex T-SQL code, stored procedures, and functions. - Familiarity with the Microsoft Business Intelligence stack, specifically providing support and troubleshooting for SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS) environments. - Automation: Experience developing scripts (e.g., PowerShell, Python) to automate routine DBA tasks, monitoring, and reporting. - Solid understanding of ITIL principles and experience working within an IT service management framework (e.g., ServiceNow). - Excellent problem-solving, analytical, and troubleshooting skills with a meticulous attention to detail. - Good communication skills and ability to collaborate with cross-functional teams. - Ability to work effectively in a fast-paced, global environment and manage multiple priorities simultaneously. - Must be flexible and fully prepared to participate in a 24x5 shift rotation schedule to ensure continuous database operational support. Relevant Qualifications - ITIL ® Foundation in IT Service Management (Desirable). - Relevant industry certifications. - Microsoft Certification in SQL Server is a plus. - Cloud Certification (GCP) is a plus. - Degree/Master of computer science or related disciplines. Benefits - Attractive Base Salary. - Annual Performance Based Bonus. - Group Mediclaim Insurance Policy. - Travel Reimbursement. Company Description Rentokil PCI is the leading pest control service provider in India. A Rentokil Initial brand, Rentokil PCI was formed in 2017 through a joint venture (JV) between Pest Control India, the number one pest control company in India, and Rentokil, the world’s leading pest control brand. Rentokil PCI aims to set new standards for customer service with operations across 250 locations in India. The JV brand also focuses on developing industry-leading service operations through the sharing of best practices, new innovations and the use of digital technologies.

India
Job Closed
Voleon Group logo

Database Administrator, DBA

Voleon Group

The Voleon Group is a quantitative hedge fund that is committed to solving financial prediction problems using statistical machine learning. The company combine

• Administer, monitor, and maintain relational databases (PostgreSQL, MySQL, or Oracle) in production and development environments • Perform routine DB operations such as backup and recovery, schema changes, patching, upgrades, and security hardening • Support incident response, root cause analysis, and recovery for database-related issues • Automation, configuration management, modernization • Monitoring and analysis • Work collaboratively with systems and infrastructure teams to understand storage, OS, and networking components that influence database performance and reliability • Leverage basic Linux command-line and systems knowledge to troubleshoot and improve DB processes

United States
$155K - $195K / year
Job Closed