Oracle DBA (Only USC or GC) (10+ Years exp)

Job Title: Oracle DBA

Location: Denver, CO – Onsite

Employment Type: Contract

Job Description:

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

📧 Email: preeti.verma@ampstek.com