Job Summary

Job Summary

We are seeking an experienced Database Administrator (DBA) with 5–8 years of hands-on experience in database administration, cloud database management, and data migration initiatives. The ideal candidate should possess strong expertise in managing and optimizing enterprise databases across on-premises and cloud environments (Azure and AWS), along with working knowledge of ETL tools, data integration, and migration methodologies.

Key Responsibilities

Key Responsibilities

Database Administration

• Install, configure, upgrade, patch, and maintain database platforms including SQL Server, Oracle, PostgreSQL, and MySQL.
• Monitor database performance, troubleshoot issues, and implement performance tuning strategies.
• Manage backup, recovery, disaster recovery, replication, and high-availability solutions.
• Ensure database security, access controls, compliance, and data integrity.
• Perform capacity planning, database health checks, and proactive monitoring.

Cloud Database Management

• Administer and support cloud database services on Microsoft Azure and AWS.
• Manage Azure SQL Database, Azure Managed Instances, AWS RDS, Aurora, and cloud-native database services.
• Support cloud migrations, database upgrades, and platform modernization initiatives.
• Optimize cloud database performance, scalability, availability, and cost efficiency.

Data Migration & Modernization

• Participate in end-to-end database migration projects from on-premises to cloud and between database platforms.
• Design and execute migration strategies, including assessment, schema conversion, data validation, and reconciliation.
• Perform database backup/restore, lift-and-shift migrations, and modernization activities.
• Validate migrated data for completeness, consistency, and performance.

ETL & Data Integration

• Work with ETL tools and data integration platforms to support data movement and transformation activities.
• Collaborate with Data Engineering teams to design and troubleshoot ETL workflows.
• Support data warehouse and analytics platform integrations.
• Assist in performance optimization of ETL jobs and data pipelines.

Operational Excellence

• Create and maintain database administration documentation, SOPs, and runbooks.
• Participate in production support, root cause analysis, and incident management.
• Collaborate with application, infrastructure, DevOps, and cloud teams.
• Automate routine DBA activities using scripting and infrastructure automation tools.

Skill Requirements

Required Skills

• 5–8 years of experience in Database Administration.
• Strong administration experience with one or more databases:
• Microsoft SQL Server
• Oracle
• PostgreSQL
• MySQL
• Experience with:
• Backup & Recovery
• Performance Tuning
• High Availability & Disaster Recovery
• Database Security & Compliance
• Replication and Clustering Technologies
• Hands-on experience with:
• Microsoft Azure (Azure SQL Database, Azure SQL Managed Instance, Azure VM, Azure Storage)
• AWS (RDS, Aurora, EC2, S3, CloudWatch)
• Working knowledge of ETL/Data Integration tools such as:
• Azure Data Factory (ADF)
• SSIS
• Informatica
• Talend
• AWS Glue
• Databricks (preferred)
• Strong understanding of Data Migration concepts, methodologies, and best practices.
• Experience in migration, validation, reconciliation, and cutover planning.
• Proficiency in SQL scripting and database automation.
• Experience with PowerShell, Python, Bash, or Shell scripting.

Preferred Skills

• Experience with cloud migration and database modernization programs.
• Knowledge of Data Warehousing, Data Lakes, and Analytics platforms.
• Familiarity with CI/CD, DevOps, and Infrastructure as Code (Terraform, ARM, CloudFormation).
• Azure or AWS certifications preferred.
• Knowledge of monitoring tools and observability platforms.

Other Requirements

Education

• Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or related field.

Soft Skills

• Strong analytical and problem-solving abilities.
• Excellent communication and stakeholder management skills.
• Ability to work in a fast-paced, cross-functional environment.
• Strong documentation and customer-facing skills.

Nice-to-Have Certifications

• Microsoft Azure Database Administrator Associate (DP-300)
• Azure Administrator Associate (AZ-104)
• AWS Certified Database – Specialty
• AWS Solutions Architect Associate
• Oracle Database Administrator Certification

This JD is suitable for hiring a mid-level to senior DBA who can manage production databases while supporting cloud migration and modernization programs.