Lead Database Administrator (PostgreSQL & MySql)
Tasks
- Analyze resolve performance replication and data integrity issues
- Collaborate with application developers to optimize queries and structures
- Configure tune and monitor autovacuum processes
- Design implement maintain highly available PostgreSQL clusters
- Develop maintain backup recovery and disaster recovery solutions
- Develop maintain documentation SOPs and runbooks
- Diagnose and resolve vacuuming and autovacuum log issues
- Implement security policies user access controls auditing and compliance
- Migrate databases and data from Oracle MySQL Vertica to PostgreSQL
- Monitor database health implement proactive alerts troubleshoot issues
- Participate in on call rotation and support critical incidents
- Perform performance tuning query optimization and capacity planning
- Perform schema design database upgrades patch management and migrations
- Provide subject matter expert support for PostgreSQL and secondary support for MySQL or Oracle
- Stay current on PostgreSQL features and recommend improvements
Perks/Benefits
Skills/Tech-stack
AWS | Access Control | Autovacuum | Capacity Planning | Data Integrity | Database Auditing | Database Backup | Database Migration | Database Upgrades | Database monitoring | Database security | Disaster Recovery | Index Tuning | Linux | MS SQL | MS SQL Server | MySQL | Oracle | PLSQL | Percona | Performance Tuning | PgAdmin | PostgreSQL | Query Optimization | Replication | SQL | SQL Server | Shell Scripting | Stored Procedures | Table management | Triggers | Unix | Vertica
Education
Related jobs
-
Coupa System Administrator INR 1000K-1680KCatalogue Management | Coupa | Data Integrity | ERP interfaces | KPI ReportingHome-based | Permanent employmentMid-level Full TimePune4h ago
-
Senior IT Administrator INR 2125K-3440KActive Directory | Amazon Web Services | Antivirus | Backup and Recovery | BashSenior-level Full TimeBangalore, India22h ago
-
Sr SAP Basis Administrator INR 2520K-3600KBackup and Restore | Database Administration | Database security | Disaster Recovery | High AvailabilityAnnual budget for workspace customization | Charity volunteering time | Equipment provided | Paid sick days | Paid vacationSenior-level Full TimeIndia R1d ago
-
Senior-level Full TimeNoida, Uttar Pradesh1d ago
-
System Administrator / SysOps Engineer (India) INR 2500K-3380KAWS | Active Directory | Ansible | Chef | CitrixEnglish classes | On-call rotation | Referral program | Training reimbursement | Work from homeSenior-level Full TimeNew Delhi1d ago
-
Senior Specialist - SAP- INR 2400K-3500KABAP | Application Server | Application Server Administration | Change Management | Database AdministrationSenior-level Full TimeBangalore, Karnataka, India1d ago
-
Senior E1-CNC Administrator INR 2000K-2500KAIS | AWS | AWS Auto Scaling | AWS Clustering | AWS Elastic Load BalancingOn call coverage 24x7 | Second shift afternoonsSenior-level Full TimeIndia - Bangalore - 5th floor, …1d ago
-
Salesforce Administrator INR 2092K-3487KAWS | AWS Lambda | Amazon IAM | Amazon S3 | Audit trailsHybrid workSenior-level Full TimeBengaluru, Karnataka, India1d ago
-
Lead Information Security Engineer INR 1567K-4200KAccess Management | Active Directory | Authentication | Automation | AvailabilitySenior-level Full Time111443-IND-HYDERABAD-INTL HYD WF CENTRE BLK B8 …1d ago
-
Lead Software Engineer - Automation Testing & Java Coding INR 1733K-2829KAgile | Confluence | IBM ILOG | Java | ODMSenior-level Full TimePune, India1d ago
-
Lead Software Engineer - Java Backend INR 2250K-2829KAWS | Agile | Apache Kafka | Automated testing | CI/CDSenior-level Full TimePune, India1d ago
-
Lead Site Reliability Engineer INR 1500K-2500KAKS | AWS | Active Directory | Autoscaling | AzureFollow-the-Sun support | Rotational on call shiftsSenior-level Full TimePune, India1d ago
-
Lead Information Security Engineer - Data Architecture, Quantum readiness, Cryptography INR 1500K-4000KAccess Management | Application Security | Authentication Services | Automation | Business ContinuitySenior-level Full Time110380-IND-BENGALURU-INTL BLR Twr-1&2 CARNATION, India1d ago
-
Mainframe MQ Administrator INR 2000K-3100KCICS | CICS Bridge | CICS integration | Disaster Recovery | IBM MQBe Well programs | Coaching | Continuous feedback | Hybrid work environmentMid-level Full TimeKIN51655 Gurugram (KIN51655), India1d ago
-
Mainframe DBA Administrator INR 2500K-4000KAccess Control | Authentication | Automation | Backup and Recovery | Compliance Monitoring24x7 on-call support | Be Well programs | Certification support | Coaching | Continuous feedbackSenior-level Full TimeKIN51655 Gurugram (KIN51655), India1d ago
-
Developer-App Platform-Infra INR 1400K-1400KAWS | AWS Lambda | Amazon Bedrock | Amazon DynamoDB | Amazon EKSEquity | Fertility support | Flexible annual leave | Life insurance | Medical insuranceEntry-level Full TimeOffice - IND - Karnataka, Bengaluru, …1d ago
-
Senior Database Administrator INR 1060K-1200KAuthentication | Authorization | Backup and Recovery | Capacity Planning | Database AdministrationMentoring | TrainingSenior-level Full TimePune, India1d ago
-
System Administrator – IT INR 550K-1050KActive Directory DS | Amazon Web Services | BMC Remedy | DHCP | DNSRotational shiftsMid-level Full TimeIN-TN-Chennai1d ago
-
Cloud Engineer I (Intune/End Point Management) INR 950K-1250KABM | APNs | Active Directory | Android | App ConfigurationMid-level Full TimeHyderabad, Telangana, India2d ago
-
Workday – Workday HCM (Talent Module , Performance Management , security architecture ) - 4- 6 yrs INR 1500K-2400KAcceptance Testing | Access Control | Advanced Reporting | Benefits | Business Process FrameworkSenior-level Full TimeGurgaon, HR, India2d ago
-
DE&A - Power BI & OBIEE/OAS Platform Administrator INR 2486K-4144KAWS | BI Gateway | BI Server | CI/CD | Capacity PlanningSenior-level Full TimePune, Maharashtra, India2d ago
-
PLM Analyst (Teamcenter Administration) INR 1500K-2633KAccount Management | CAD Integration | Change Management | Database Administration | Engineering ChangeMid-level Full TimeBangalore2d ago
-
Domain Architect INR 2050K-3500KArtificial Intelligence | Azure | CI/CD | Cloud Native | Cloud Native ArchitectureSenior-level Full TimeIndia2d ago
-
Access Control | Account administration | Compliance | Data Retention | Enterprise Grid24 7 steady state support | Flexible shift scheduleSenior-level Full TimeNoida, UP, IN2d ago
-
Senior-level Full TimePune, Maharashtra, India2d ago