Job Title: Data Platforms SQL Server Reliability Engineer with AWS Cloud Expertise, Senior Analyst
Job Overview:
The Bank is seeking an experienced Senior SQL Server Database Administrator with knowledge of AWS
Cloud technologies. The ideal candidate will have a deep understanding of SQL Server administration
coupled with expertise in AWS services, particularly AWS RDS SQL Server/Aurora and DMS. Individuals
with proficiency in infrastructure as code tools like Terraform, scripting languages such as Python, Java
script, Bash, PowerShell, and experience with serverless computing using AWS Lambda functions are
preferred. MS-SQL as primary - Database adminstration and Support ; Exposure to Cloud RDS, EMR
products and support.
Responsibilities include:
Design and Implementation:
1. Design, deploy, and manage SQL Server databases on premises and in AWS RDS, ensuring
optimal performance, availability, and scalability.
2. Collaborate with cross-functional teams to architect and implement hybrid cloud database
solutions aligned with business requirements.
3. Develop and maintain infrastructure as code using Python, Bash, Ansible, PowerShell and
Terraform to automate the provisioning and configuration of a hybrid cloud database
environment.
4. Migrate on premises databases to AWS using DMS, DMS CDC and development custom
CDC scripts.
5. Collaborate with data engineers, DevOps, and other stakeholders to define database
requirements and solutions.
Maintenance and Optimization:
1. Monitor and maintain the health, performance, and security of a hybrid cloud database
environment.
2. Support of Production environments with strong troubleshooting skills.
3. Implement cost optimization strategies and ensure efficient utilization of database resources.
4. Perform database migrations, upgrades, and patching activities with minimal downtime and
risk.
5. Implement and manage database backups, replication, and disaster recovery strategies to
ensure data integrity and availability.
6. Continuously improve database infrastructure and architecture to support evolving business
needs and best practices and optimal flexibility.
Automation and Scripting:
1. Utilize Python, Bash, Ansible, PowerShell and Terraforms scripting to automate database
administration tasks, streamline processes, and enhance operational efficiency.
2. Automate the configure and manage database security policies, access controls, and
encryption in compliance with industry standards and regulations.
3. Utilize Terraforms for managing cloud resources and deployments, ensuring consistency and
reliability in infrastructure management.
4. Collaborate with DevOps teams to integrate database deployments into CI/CD pipelines and
automate release processes.
5. Ensure all automation is robust, reusable, and adheres to industry standards.
Security and Compliance:
1. Implement and enforce security best practices for Data Platforms in a hybrid cloud environment.
2. Ensure compliance with relevant regulations and internal policies through proper configuration
and auditing.
Documentation and Support:
1. Document database configurations, procedures, and best practices for knowledge sharing and
team collaboration.
2. Provide support and troubleshooting assistance to other team members and
stakeholders to resolve database-related issues, performance bottlenecks, and scalability
challenges in Hybrid cloud environments.
Job Requirements:
1. Bachelor’s degree in computer science, Information Technology, or related field; or equivalent
work experience.
2. Proven working experience as a SQL Server/SQL Server Database Administrator, with at least 5
years of hands-on experience with SQL Server and SQL Server RAC. Candidates with
knowledge or experience with AWS Cloud environments are preferred.
3. Solid understanding of SQL Server performance tuning, query optimization, and troubleshooting
techniques.
4. Experience with database security principles and best practices, including encryption, access
controls, and compliance.
5. Excellent problem-solving skills and the ability to troubleshoot complex database issues in hybrid
cloud environments.
6. Experience with agile methodologies.
7. Strong communication and collaboration skills, with the ability to work effectively in a team-
oriented environment.
8. Knowledge of AWS services, particularly AWS RDS and related cloud technologies.
9. Knowledge of infrastructure as code tools such as Terraform for automating cloud infrastructure
provisioning and management.
10. Knowledge of Python, Bash, Ansible and PowerShell scripting for automation, orchestration, and
integration tasks.
11. Knowledge of DevOps practices and tools for continuous integration and deployment (CI/CD).
12. Relevant certifications such as AWS Certified Solutions Architect or AWS Certified Database -
Specialty are a plus.
Human
Business Acumen Data Skills Tech Skills Skills
Data Modeling,
Data
Warehousing, Core Strong
Financial Data Mesh and Competenc Inter-
Services Domain Data Lakes, y in DBA + personal
experience Data Governance see above skills
15% 25% 50% 10%
