The role involves database administration, supporting production environments, performance tuning, code deployment, and release management.
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.
Database Operations:
- 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.
Monitoring & Performance Tuning:
- 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.
SQL Server Support (Optional but helpful):
- Manage SQL Server instances using SQL Server Management Studio (SSMS).
- Perform regular backup and restore operations for SQL Server databases.
Release & Deployment Support:
- 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.
Key Skills Required:
- 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 Management Studio
Webspeed
Bahwan CyberTek Chennai, Tamil Nadu, IND Office
148, Rajiv Gandhi Salai(OMR), Okkiyam Thoraipakkam, , Chennai, India, 600 097
Similar Jobs
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
The role focuses on managing projects using SAP Spartacus, leading scrum teams, creating technical designs, and liaising between business and technical teams.
Top Skills:
AgileSap Spartacus
Agency • Digital Media • eCommerce • Professional Services • Software • Analytics • Consulting
The Salesforce Marketing Cloud Architect will lead implementation projects, support marketing automation, and develop technical requirements to enhance client experiences through data-driven marketing solutions.
Top Skills:
AmpscriptCSSHTMLJavaScriptJSONMjmlSalesforce Marketing CloudSQLXML
Aerospace • Digital Media • Information Technology • Internet of Things • Mobile • Software
Develop software for Intelsat's ecosystem, lead diverse teams, engage with stakeholders, and create architecture artifacts while applying industry trends.
Top Skills:
Apache KafkaDockerJavaKubernetesOracleRedisRest Apis
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.
