Database Administrator

Title: Database Administrator
Location: Denver, CO (On-site)
Duration: 6 months (possibility of extension)
Implementation Partner: Infosys
End Client: To be disclosed
JD:


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.


Knowledge of indexing, partitioning, clustering, and sharding concepts.


Experience with monitoring tools and database health checks.


Scripting/automation experience using Python, Shell, or PowerShell.


Strong problem-solving and analytical skills.


Excellent communication and stakeholder management skills.

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.
• Ensure compliance with data governance, security, and regulatory requirements.