Manage PostgreSQL and Progress 4GL databases, ensure data integrity, perform backups, tune performance, assist in release management, and develop runbooks for deployments.
Job Description:
Responsibilities:Database Administration:
- Manage and support Production, QA, and Development environments for PostgreSQL and Progress 4GL databases.
- Monitor and manage database backups and ensure proper data growth management.
- Refresh Dev, Test, and Preprod environments by syncing them with the Live environment.
- Tune database performance by analyzing and optimizing query execution, index usage, and general database configurations.
- Perform Database Dump and Load operations, including experience with Progress database management.
- Ensure data integrity and consistency across different environments (Dev, Test, Preprod, and Production).
- Troubleshoot database-related issues, especially around code deployments, compilation, and their interaction with the database.
- Collaborate closely with the Development Team, providing support for database-related queries, optimizations, and issues.
- Use PROMON and other tools to regularly perform database health checks.
- Proactively monitor database performance and make adjustments to ensure optimum functionality.
- Experience in tuning performance issues and implementing changes when necessary.
- Knowledge of Appserver and Webspeed to optimize the performance of Progress-based applications.
- Manage SQL Server instances using SQL Server Management Studio (SSMS).
- Perform regular backup and restore operations for SQL Server databases.
- Prepare runbooks for production releases, outlining all steps and procedures for application deployment and database changes.
- Assist in Release Management by coordinating deployment schedules and ensuring that deployment goes smoothly.
- Handle deployment issues, ensuring the release process is seamless across all environments.
- Experience managing both PostgreSQL and Progress 4GL databases.
- Expertise in database backups, restores, and data refreshes across environments.
- In-depth experience with database performance tuning (e.g., query optimization, indexing).
- Familiarity with Progress 4GL queries, Appserver, and Webspeed.
- SQL Server management skills (backup, restore, etc.) are a plus.
- Experience with release management and writing/maintaining runbooks.
Top Skills
Appserver
Postgres
Progress 4Gl
Promon
SQL Server
Sql Server Management Studio
Webspeed
Bahwan CyberTek Chennai, Tamil Nadu, IND Office
148, Rajiv Gandhi Salai(OMR), Okkiyam Thoraipakkam, , Chennai, India, 600 097
Similar Jobs
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
As a Workday Consultant, you will support multiple Workday modules, troubleshoot inquiries, conduct audits, and engage with stakeholders while contributing to projects.
Top Skills:
EibsJIRAWorkday HcmWorkday RecruitingWorkday Reporting
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
The Sr. Software Engineer will develop feature extraction engines, collaborate with data scientists, and test software systems while working with complex file formats and reverse engineering.
Top Skills:
AWSAzureBitbucketC++GCPGitJenkinsJIRAPythonRust
Artificial Intelligence • Big Data • Logistics • Machine Learning • Software • Transportation
Oversee secure cloud infrastructure, implement automation for CI/CD, ensure compliance with security standards, and respond to incidents.
Top Skills:
AnsibleAWSAzureBashC#ChefCloudFormationDockerGCPJavaJenkinsKubernetesPuppetPythonTerraform
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
