Description

Skills:

• Database design and data modeling
• Database migrations and modernization
• Performance tuning and troubleshooting
• Backup, recovery, replication, and HA configurations
• Hands-on experience with AWS cloud platform.
• Knowledge of indexing, partitioning, clustering, and sharding concepts.
• Experience with monitoring tools and database health checks.
• Scripting/automation experience using Python, Shell, or PowerShell.
• MUST HAVE Oracle Database Administration
• MUST HAVE MongoDB Administration
• Strong problem-solving and analytical skills.
• Excellent communication and stakeholder management skills.

Experience:

• 10 to 15 years of DBA experience supporting enterprise-scale databases.

Strong Expertise In:

• Oracle Database Administration
• MongoDB Administration
• Amazon DynamoDB
• Strong SQL, PL/SQL, and query optimization skills.

Experience With:

• Database design and data modeling
• Database migrations and modernization
• Performance tuning and troubleshooting
• Backup, recovery, replication, and HA configurations
• Hands-on experience with AWS cloud platform.

Responsibilities:

Database Administration & Support:

• Administer, maintain, monitor, and support Oracle, MongoDB, and DynamoDB environments.
• Manage database installations, upgrades, patches, backups, recovery, and replication strategies.
• Ensure database availability, reliability, and security across production and non-production environments.
• Implement database standards, policies, and best practices.

Database Design & Architecture:

• Design scalable and high-performing relational and NoSQL database architectures.
• Create logical and physical data models based on application requirements.
• Optimize schema design, indexing strategies, partitioning, and storage configurations.
• Support microservices and distributed data architectures.

Database Migration & Modernization:

• Lead database migration projects from legacy platforms to Oracle, MongoDB, or DynamoDB.
• Perform schema conversion, data migration, validation, and cutover planning.
• Support cloud migration initiatives and modernization efforts.
• Experience with migration tools and ETL/data integration processes.

Performance Tuning & Optimization:

• Analyze and resolve database performance bottlenecks.
• Tune SQL queries, stored procedures, indexes, and execution plans.
• Optimize MongoDB collections, aggregations, sharding, and replication.
• Improve DynamoDB throughput, partition key design, auto scaling, and cost optimization.
• Monitor database health using performance monitoring tools.

High Availability & Disaster Recovery:

• Configure and maintain HA/DR solutions including Oracle RAC/Data Guard, MongoDB replica sets/sharding, and DynamoDB global tables.
• Develop and test backup and recovery procedures.
• Ensure business continuity and disaster recovery readiness.

Cloud & Automation:

• Work with AWS cloud services related to databases and infrastructure.
• Automate database administration tasks using scripting tools such as Shell, Python, or PowerShell.
• Support Infrastructure as Code (IaC) and CI/CD integration where applicable.

Collaboration & Governance:

• Work closely with application developers, architects, DevOps, and security teams.
• Participate in code reviews and database design discussions

Key Skills

Education

Any Graduate