PostgresSQL Server Engineering Lead

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

Required Qualifications:

• 8+ years of experience as a

  Postgres SQL Server

  Data Engineer with experience in design, implementation, and management
• 5+ years of strong experience with tools like Terraform, Kubernetes, Docker, Packer,
• 5+ Years of hands on experience with CI/CD tools ( Github action, Jenkins etc )
• 4+ years proven experience managing Databases on cloud platforms
• 3+ years of experience PII Personally Identifiable Information or PHI Personal Health Information
• 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

Preferred Qualifications:

• Bachelors 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.