Database Administrator || onsite in Denver, CO || 12 to 16 years

Role : Database Administrator

Location : Denver, CO

Exp. : 12 to 16 years.

JD Details: 10 to 15 years of DBA experience supporting enterprise-scale databases.

Strong expertise in:

1. Oracle Database Administration

2. MongoDB Administration

3. Amazon DynamoDB

4. 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

Deliverables:

Ø Process Flows

Ø Mentor and Knowledge transfer to client project team members

Ø Participate as primary, co and/or contributing author on any and all project deliverables associated with their assigned areas of responsibility

Ø Participate in data conversion and data maintenance

Ø Provide best practice and industry specific solutions

Ø Advise on and provide alternative (out of the box) solutions

Ø Provide thought leadership as well as hands on technical configuration/development as needed.

Ø Participate as a team member of the functional team

Ø Perform other duties as assigned.