
Senior Software Engineering Lead - Postgres SQL Server
- Noida, Uttar Pradesh
- Permanent
- Full-time
- 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