Backups, restores and disaster recovery: Manage RDS automated backups and snapshots and native backups to S3, and test restores. Implement and maintain HA/DR solutions, including Always On, replication, clustering and log shipping, and the high-availability setup across the RDS estate. Maintain and test disaster-recovery plans.
Environment refreshes and data movement: Copy production databases to UAT/Dev for client and internal use (approx. 6 refreshes per month). Shrink databases before they move to lower environments (copy to a new instance, truncate tables agreed with EDM Product Support).
Upgrades, patching and maintenance: Plan RDS SQL Server engine upgrades, patching and OS maintenance, write the runbooks and support L1 during the upgrade. Check the pending-maintenance status across the RDS estate and run the index and statistics maintenance jobs.
Cost optimisation: Analyse RDS and SQL Server usage to find savings, such as right-sizing, newer instance generations, storage reclaim and removing unused databases. Validate the proposed savings and support implementation.
Security, compliance and access: Ensure database security, compliance, auditing and access controls. Manage logins, roles and permissions on least-privilege principles, support audits and fix database security findings.
PostgreSQL and Snowflake administration: Administer and support PostgreSQL and Snowflake environments (users, replication, warehouses, performance, cost).
Automation and knowledge: Develop automation for routine DBA work using PowerShell, Python and T-SQL, with Terraform and Git version control following DevOps practices. Write DBA runbooks so L1 can carry out routine database tasks.
Eligibility Requirements
8+ years of database administration experience; owns problems through to resolution; clear written and spoken English
Strong expertise in SQL Server (2016/2019/2022) administration and performance tuning
Hands-on PostgreSQL administration and replication experience
Snowflake administration and support experience
Strong AWS knowledge: RDS, EC2, S3, IAM, CloudWatch
HA/DR (Always On, replication, clustering, log shipping), backup and recovery, and disaster-recovery planning
Scripting and automation with PowerShell, Python and T-SQL, or Terraform
Experience with DevOps practices and version control (Git)
Nice to Have
Experience supporting financial services or other regulated clients
AWS Certified Database Specialty; AWS Solutions Architect; SnowPro Core Certification; Microsoft SQL Server certifications; PostgreSQL certifications
How to Apply
Click "Apply Now" to submit your resume through our career site
Be sure to include any relevant experience that aligns with the role.
Qualified candidates will be contacted by a member of our recruitment team for next steps
About eClerx
eClerx is a leading provider of productized services, bringing together people, technology and domain expertise to amplify business results.
The firm provides business process management, automation, and analytics services to a number of Fortune 2000 enterprises, including some of the world’s leading financial services, communications, retail, fashion, media & entertainment, manufacturing, travel & leisure, and technology companies. Incorporated in 2000, eClerx is traded on both the Bombay and National Stock Exchanges of India. The firm employs more than 19,000 people across Australia, Canada, France, Germany, Switzerland, Egypt. India, Italy, Netherlands, Peru, Philippines, Singapore, Thailand, the UK, and the USA.
For more information, visit www.eclerx.com
You can also find us on
https://www.linkedin.com/company/eclerx/
https://www.indeed.com/cmp/Eclerx/about
https://www.glassdoor.com/eClerx
eClerx is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law. We are also committed to protecting and safeguarding your personal data. Please find our policy here
