Database Administrator (PostgreSQL)


  • EnergyTech Global
  • Hyderabad
  • 5-9 Year
Job Description
Database Administrator (PostgreSQL) We're looking for exceptional DBA's who are interested in using the latest database technologies to deliver industry-leading systems.  Requirements: A minimum of 5 to 8 years previous work experience as PostgreSQL database administrator. Exposure and understanding of PostgreSQL DB Architecture. Experience in database administration, upgradation, maintenance, backup and recovery. Experience in database tuning. Connection Pooling, Load balancing with pgBouncer, pgBadger reporting tools. Implementing and managing Database Mirroring, Log Shipping, Streaming Replication and basic understanding and implementation of Slony Replication. Understanding of normalization, indexing, locking, MVCC, transactions, concurrency. Experience in Failover & Failback. Innovativeness; And should be an out of the box thinker. Excellent communication skills. Key Functions: Create and maintain all databases required for development, testing, education, load reporting and production usage. Performs the capacity planning required to create, monitor and maintain the databases. Performs ongoing tuning of the database instances to gain better performance and optimisation than before. Conducts rigorous database testing and optimisation using appropriate database monitoring and optimisation methods. Install new versions of the PostgreSQL RDBMS and its tools and any other tools that access the PostgreSQL database. Plans and implements backup and recovery of the PostgreSQL database. Implements and enforces security for all of the PostgreSQL Databases. Performs database reorganisation as required to assist performance and ensure maximum uptime of the database. Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to. Evaluates releases of PostgreSQL and its tools and third party products to ensure that the site is running the products that are most appropriate. Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact. Provides technical support to application development teams. This is usually in the form of a help desk. The DBA is usually the point of contact for any database related questions. Enforces and maintains database constraints to ensure the integrity of the database. Administers all database objects, including tables, clusters, indexes, views, sequences, packages, procedures, clusters and load balancing. Assists with impact analysis of any changes made to the database objects and their required hardware. Troubleshoots with problems regarding the databases, applications and development tools. Create new database users as required. Manage to share resources amongst applications. Work towards sustaining current processes and implementing new ones. We can offer: Full-time day shift job (support will be during India normal business hours during weekdays) All the equipment, tools and knowledge you will ever need or want. Work in MNC company with international reach. Work in a business park with amazing workplace facilities. Competitive compensation package, health insurance and much more. Everyday coffee, breakfast and lunch are on the house. Work with people who will have your back when you need it. Minimum Qualification: B.E/B.Tech/M.E/M.Tech/MCA - Computer science / Information Technology with an excellent academic record Send in your resumes to rachel.edadhasari@energytech-global.com and careers@energytech-global.com and we will get in touch with you as soon as possible.
INR 50Lac - 90Lac
IT- Software Services
Full Time
March 10,2017

Keyskill Required
  • dBase Jobs

Designation
  • Database Administrator

Company Profile

Company Name: EnergyTech Global

Company Profile: EnergyTech Global Private Limited is a 100% wholly owned subsidiary of Electric Kiwi Limited, an independent electricity retailer in New Zealand. EnergyTech is a technology development arm of Electric Kiwi which is tasked to develop, support and maintain enterprise software solutions for Global electricity retail markets. EnergyTech Global activities include cloud server management and support code base management, application layer development, code documentation, system testing and live environment support of Electric Kiwi enterprise software platform. EnergyTech practices the agile software development and project management methodology. EnergyTech also offers full range of value based services comprising of developing company wide application strategies through solution implementation, training and support services in the electricity industry.

Contact Company: 9100939681

Website: http://energytech-global.com/aboutetg.php

Recruiter Name: Rachel