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
-
Senior-level Full Timebangalore, India10h ago
-
DE&A - Power BI & OBIEE/OAS Platform Administrator INR 2486K-4144KAWS | BI Gateway | BI Server | CI/CD | Capacity PlanningSenior-level Full TimePune, Maharashtra, India14h ago
-
Data Engineer /ETL Lead Sr Technical Lead-Data Engg INR 300K-370KAWS | Ab Initio | Agile | CI/CD | Cost OptimizationSenior-level Full TimeINDIA - PUNE - BIRLASOFT OFFICE …20h ago
-
Team Lead INR 2535K-4200KAWS | Application Insights | Azure | Azure DevOps | BashAnnual performance bonus | Flexi time 2 5 hours off | Health insurance | Hybrid work arrangement | Inclusive cultureSenior-level Full TimeBangalore, India Office20h ago
-
Data Analytics Lead Analyst - C13 - CHENNAI INR 2000K-2400KBig Data | Classification | Clustering | Data Pipelines | Data WarehousingSenior-level Full TimeIT BUILDING, RAMANUJAN IT SEZ,, India20h ago
-
Data Science Sr Lead Analyst - C14 - PUNE INR 2000K-2600KBig Data | Data Quality | Data Visualization | Data Warehousing | ETLProject planning | Resource allocation | Staff management | Stakeholder managementSenior-level Full TimeTOWER B, EON FREE ZONE II, …20h ago
-
Database Administrator INR 1685K-2000KBackup and Recovery | Database Backup | Database backup and recovery | Database security | Microsoft SQLSenior-level Full TimeHyderabad, HDC4A, India20h ago
-
Lead, Platform Engineering INR 2000K-3100KApex | Backup and Recovery | Bash | Binary Logical Replication | Binary StreamingCross-functional collaboration | On-call rotationSenior-level Full TimePune, India20h ago
-
Senior-level Full TimePune, India20h ago
-
Lead Software Engineer–Embedded INR 2500K-3630KARM | BIOS | Build System | C# | CI/CDRelocation within IndiaSenior-level Full TimeIND - Bangalore, India20h ago
-
Principal Software Engineer INR 2000K-3100KAI machine learning | Agile | Data Modeling | Data Warehouse | Data integrationSenior-level Full TimeBangalore, India20h ago
-
Data Platform Administrator INR 716K-1200KAWS | Azure | Bash | CI/CD | Data Governance24/7 on-call rotationEntry-level Full TimeHyderabad, Office Level 3 & 4, …20h ago
-
Dashboard Development | Data Automation | Data Pipelines | Data Visualization | Power BICharity match program | Employee assistance program | Group medical insurance | Hybrid work flexibility | Paid time offSenior-level Full TimeGurgaon - Cyber Park, India20h ago
-
Database Engineering Specialist INR 500K-1000KAWS | Active/Active | Active/Passive | Backup and Recovery | CassandraFollow-the-Sun support | On-call supportMid-level Full TimeNoida Berger Tower, India20h ago
-
Database Administrator INR 1500K-2000KBackup and Restore | Best practices | Cause analysis | Database Administration | Database MaintenanceMid-level Full TimeHyderabad, India1d ago
-
Database Administrator INR 885K-1475KAccess Management | Automation | Clustering | Data replication | Database AdministrationMid-level Full TimeHyderabad, HDC3B, India2d ago
-
DBA (PostgreSQL/Oracle) in AWS INR 800K-2000KAWS CloudFormation | AWS IAM | Amazon Aurora | Amazon CloudWatch | Amazon EC2Hybrid work scheduleSenior-level Full TimeBangalore, Karnataka, India3d ago
-
Lead, AI Engineer INR 2000K-4500KAI Assistants | API Integration | AWS | AWS Bedrock | AWS CDKBenefits | Bonus eligibility | Competitive pay | Equity | Hybrid work environmentSenior-level Full TimeAhmedabad, Gujarat3d ago
-
Database Engineer I INR 800K-1200KAgile | Amazon Web Services | Automation | Data Modeling | Database AdministrationSenior-level Full TimeIndia3d ago
-
Database Engineer II INR 1000K-1330KAmazon Web Services | Automation | Data Modeling | Database Administration | Database DesignSenior-level Full TimeIndia3d ago
-
AWS | Agile | Azure | Big Data | Data ComplianceFlexible workplace arrangements | Internal mobility | Internal training | Learning and development programs | MentoringSenior-level Full TimeHyderabad, India3d ago
-
AWS | Agile | Azure | Big Data | Data GovernanceFlexible workplace arrangements | Internal mobility | Learning and development programs | MentoringSenior-level Full TimeHyderabad, India3d ago
-
SQL Database Administrator (DBA) | Cloud & Automation Expertise INR 2040K-2400KAWS RDS | Agile | Azure SQL | Azure SQL Database | BashFlexible workplace arrangements | Internal mobility | Learning and development programs | MentoringSenior-level Full TimePune - Hinjewadi (Ascendas), India3d ago
-
Lead - Database Administrator INR 300K-370KAWS S3 | Amazon Web Services | Azure Blob | Azure Blob Storage | Blob StorageSenior-level Full TimeBlock 1 DT, Chennai India3d ago
-
Lead Risk Analytics Consultant INR 1400K-1500KCredit Risk | Data Aggregation | Data Visualization | Data Warehousing | Descriptive modelingSenior-level Full Time110380-IND-BENGALURU-INTL BLR Twr-1&2 CARNATION, India3d ago