Job Duties:
• Review database designs, changes, and implementations to make sure they align with business requirements and technical design documents. Work closely with both onshore and offshore teams to identify gaps, resolve issues, and keep projects on track.
• Manage Oracle databases and Oracle GoldenGate replication in cloud environments, including installing and configuring Oracle 11g, 12c, and 19c on Linux, UNIX, and Windows platforms. Ensure database activities follow security, compliance, and Technology Risk Office (TRO) standards.
• Handle database code migrations, data changes, releases, and replication across development, testing, and production environments. Create scripts and automation to simplify database administration, deployments, and recurring processes.
• Manage Oracle database upgrades, enhancements, and related tools based on client technology and currency requirements. Review system requirements, understand the scope, and recommend practical and effective technical solutions.
• Regularly review database and application performance across production and non-production environments. Lead health checks, performance tuning, SQL optimization, storage planning, indexing, and troubleshooting to improve system stability and availability.
• Develop database and data warehouse standards and procedures for cloud environments. Contribute to cloud strategy, architecture discussions, technical questionnaires, project proposals, and decisions related to implementing effective cloud solutions.
• Plan and perform application and database migrations to cloud platforms using appropriate infrastructure and migration approaches. Support modernization efforts and migrations across different cloud providers while applying current RDBMS best practices.
• Design, test, implement, and document disaster recovery solutions for both on-premises and cloud environments. Prepare documentation for recovery exercises and ensure solutions support application resiliency and business continuity requirements.
• Work closely with business users, developers, architects, systems analysts, SMEs, and project teams throughout Agile planning, database architecture, testing, business acceptance testing, deployment, and production checkout. Participate in planning and design sessions with both onsite and offshore teams.
• Support healthcare customers and SMEs by helping design secure, highly available, and reliable database solutions. Provide advanced troubleshooting and recommendations, optimize database storage and indexes, support critical multitier applications, and contribute to cloud infrastructure and tool deployments based on client-specific business needs.
Minimum Education Requirement: This position requires minimum of bachelor’s degree in computer science, computer information systems, information technology, or a combination of education and experience equating to the U.S. equivalent of a bachelor’s degree in one of the aforementioned subjects.