Database SME MSSQL Oracle Mongo

Summary:The Database SME will be responsible for the overall management optimization and performance of enterpriselevel Oracle MSSQL and MongoDB databases. This role requires deep technical expertise across multiple database platforms with a focus on performance tuning high availability security and automation. The SME will play a key role in database migration projects capacity planning and implementing best practices to ensure database scalability and reliability. The ideal candidate will work closely with business development solution architects and technical teams to craft compelling database solutions and strategies for potential clients. This role requires a unique combination of technical expertise strong communication skills and experience in responding to RFPs and other clientfacing documentation.Key Skills and Experience Requirements:       10 years of handson experience as a Database design & planning.       Expertise in Oracle (11g/12c/19c) MSSQL Server (2012/2019/2022) and MongoDB Enterprise/Community Editions.       Strong experience in database performance tuning query optimization and index management.       Analyze RFP requirements to develop tailored database solutions for Oracle MS SQL and MongoDB.       Prepare technical content for RFPs including architecture diagrams implementation strategies and solution descriptions.       Collaborate with presales and proposal teams to create winning responses that meet client needs       Contribute to Statement of Work (SOW) and other contractual documents with accurate and precise databasespecific inputs.       Ensure all technical documentation aligns with compliance and regulatory standards.       Indepth knowledge of HA/DR solutions: Oracle RAC MSSQL Always On MongoDB replica sets/sharding.       Proficiency in migration tools (Oracle Data Pump SSMA MongoDB Compass/Mongo mirror).       Experience in backup & restore strategies using RMAN SQL Server native backups and MongoDB snapshots.       Handson experience with scripting languages like PowerShell Python or Shell for automation.       Strong understanding of cloud database solutions: Azure SQL AWS RDS MongoDB Atlas or GCP Cloud SQL.       Experience in migrating databases to cloud platforms.       Strong analytical and problemsolving abilities.       Ability to lead projects and mentor junior team members.Key Responsibilities:       Manage configure and optimize Oracle MSSQL and MongoDB database instances.       Perform routine health checks maintenance and upgrades to ensure database availability and reliability.       Conduct indepth performance analysis to identify and resolve slowrunning queries indexes and resource bottlenecks.       Optimize database configurations query execution plans and schema design for Oracle MSSQL and MongoDB.       Design and implement High Availability (HA) and Disaster Recovery (DR) strategies for Oracle RAC MSSQL Always On and MongoDB replica sets.       Ensure databases are resilient and recoverable with appropriate backup and recovery plans.       Lead database migration projects from onpremises to cloud (AWS Azure or GCP) and crossplatform migrations.       Upgrade databases to the latest versions ensuring minimal downtime and data integrity.       Automate routine database tasks using PowerShell or Python or Shell scripting.       Develop scripts to monitor database health automate backup/restore processes and perform housekeeping tasks.       Implement database security best practices including user access control encryption auditing and patch management.       Ensure compliance with industry standards and regulatory requirements.       Set up advanced monitoring tools for Oracle (OEM) MSSQL (Performance Monitor DMVs) and MongoDB (Ops Manager Atlas).       Troubleshoot issues related to database performance replication and connectivity.       Collaborate with crossfunctional teams (application infrastructure DevOps) to support database requirements.       Prepare and maintain technical documentation including database architecture diagrams SOPs and incident reports.Preferred certification (if Any):       Oracle Certified Professional (OCP)       Microsoft Certified: Azure Database Administrator Associate       MongoDB Certified DBAGood to have skills:       Experience with NoSQL databases beyond MongoDB (e.g. Cassandra Redis) & PostgreSQL database. 

Qualifications :

BE BTech BCA BSc (IT) MCA MBA (IT) and MSc(IT)

Additional Information :

10 years of experience

Remote Work :

No

Employment Type :

Fulltime