Senior Software Engineering Lead - Postgres SQL Server

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together.

Primary Responsibilities:

• Collaborate with cross-functional teams to understand business requirements and provide database solutions that support company objectives
• Work with software design and development teams in designing database architectures and data modelling, building database schemas, tables, procedures, and views
• Work with the system administrators for hardware and software installations and configurations
• Administer, monitor, and maintain Postgres SQL databases, ensuring their integrity, security, and high performance
• Design, implement, and maintain the database architecture, including high-availability and disaster recovery solutions
• Manage database environments within the cloud platforms
• Participate in database testing and quality assurance processes to validate database changes and updates
• Analyze and tune Postgres SQL database for optimal efficiency by Identifying and addressing performance bottlenecks, implementing query optimization, and fine-tuning database configurations to achieve optimal performance
• Analyze and sustain capacity and performance requirements, including effective use of indexes, enabling parallel query execution, and other DBMS features, such as query store
• Create and manage efficient database indexes to enhance query performance and reduce database access times
• Maintain thorough documentation of database configurations, procedures, and best practices
• Add and remove users, administer roles and permissions, audit, and check for security problems
• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so

• 8+ years of experience as a Postgres SQL Server Data Engineer with experience in design, implementation, and management
• 5+ years of solid experience with tools like Terraform, Kubernetes, Docker, Packer
• 5+ years of hands-on experience with CI/CD tools ( Github action, Jenkins etc.)
• 5+ years of experience with change management systems, such as ServiceNow and Jira
• 5+ years of experience with SQL waits, locking, blocking and resource contention
• 4+ years proven experience managing Databases on cloud platforms
• 3+ years of experience PII Personally Identifiable Information or PHI Personal Health Information

• Bachelor's degree in Computer Science or related field
• Cloud Platforms:Familiarity with AWS, Azure, or GCP services
• Monitoring & Logging: Knowledge of monitoring tools (e.g., Prometheus, Grafana, Datadog) and logging tools (e.g., ELK Stack)
• Version Control: Experience with Git and branching strategies
• Infrastructure as Code: Proficiency in tools like Terraform and Ansible
• System Implementation & Integration: Proven experience in system implementation and integration projects
• Consulting Skills: Ability to consult with clients and stakeholders to understand their needs and provide expert advice