Postgresql Database Administrator

Database Administrator - Job Description

Position Overview:   

This position is responsible for managing and maintaining all databases in the Company to meet defined SLAs. This role will primarily ensure database resources on Azure and AWS are consistently available, accessible, optimized, backed up, monitored, and secure. This position will be responsible for database tasks such as schema design, performance tuning, capacity planning, upgrades, patching, and change control activities. This position also entails all activities associated with the management and operations of lower database environments, and working closely with developers, system administrators, quality engineers to ensure system availability, continuity, data integrity and performance of production databases.

- Work hours: 

  - 11 am - 8 pm IST (2-3 days)

  - 2 pm - 11 pm IST (2-3 days)

  - 4 pm - 1 am IST (1 day or whenever necessary)

1.  Essential Job Functions:

Core duties and responsibilities include the following. Other duties may be assigned.

• Tune PostgreSQL and MSSQL databases on AWS and Azure to reduce cost.
• Support all activities associated with PostgreSQL and MSSQL databases.
• Support the production environment by proactively managing the performance, integrity, and security of all applications' databases and database servers.
• Design, create and maintain highly available and secure database instances.
• Perform under limited supervision, maintain reliability of data and databases, and assist in developing and implementing standards for database maintenance and configuration.
• Mentor and provide support to developers in best practices for database design, programming, and tuning. 
• Responsible for database administration including database system architecture, configuration, database creation, security, performance tuning and monitoring, backup and recoveries, database replication, failover strategies, data partitioning and scripting.
• Conversant with AWS RDS, Aurora, and Microsoft SQL Servers.
• May write PL/SQL code to load, migrate, summarize, and analyze data in support of application developers and other business objectives.
• Consult with developers to optimize query performance and provide best practice.
• Prepare / review implementation plans for major code pushes on production systems.
• Document all changes, upgrades, maintenance, and procedures following controls.
• Analyze products and recommend to senior management.
• Participate in an on-call rotation that provides 24x7x365 support of critical systems.

•        Plan growth and changes (Capacity planning) on servers and databases

•        Work closely with other team members for effective IT operations and business continuity

•        Provide an effective Disaster Recovery strategy for the infrastructure on AWS and Azure

2.  Competencies:

        Analytical collects and researches data; uses intuition and experience to complement data.

        Design – demonstrates attention to detail.

•        Problem solving – identifies and resolves problems in a timely manner; gathers and analyzes information skillfully; develops alternative solutions; works well in group problem solving situations; uses reason even when dealing with emotional topics.

•        Oral Communication – speaks clearly and persuasively in positive or negative situations; listens and gets clarification; responds well to questions.

•        Written Communications – writes clearly and informatively; able to read and interpret written information.

•        Teamwork – contributes to building a positive team spirit; supports everyone’s efforts to succeed.

•        Planning/Organizing – prioritizes and plans work activities; uses time efficiently; sets goals and objectives.

•        Adaptability – adapts to changes in the work environment; manages competing demands; changes approach or method to best fit the situation; able to deal with frequent change, delays, or unexpected events.

Required Skills/Experience:

• Minimum of 7 years Postgres DBA experience in an enterprise environment
• Minimum of 4 years SQL Server DBA experience in an enterprise environment
• Bachelor’s degree in computer science or comparable education and experience
• Strong SQL background and demonstrable ability to optimize complex SQL queries
• AWS RDS, Aurora, SQL Server, PostgreSQL, and MySQL
• Experience with scripting – PowerShell and Unix/Linus, SSRS, TSF, SSRS, and Cloud Infrastructure (AWS/Azure).
• Experience with backup/recovery, DR, and performance tunning
• Experience with systems monitoring, alerting, and patching.

• Language Skills

Ability to read, analyze, and interpret general business periodicals, professional journals, or governmental regulations. Ability to write reports, business correspondence, and fill out employment forms. Ability to effectively present information and respond to questions from managers and employees.

• Mathematical Skills:

Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio and percent and to draw and interpret bar graphs.

• Reasoning Ability:

Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exits. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.

Desired Skills/Experience:

• Knowledge with PostgreSQL, RDS, Aurora, Parameter groups, Azure, AWS, Microsoft SQL Server, MySQL, and CloudWatch.
• Experience with Cloud Infrastructure and High Availability solutions
• Knowledge of Postgres, SQL Server, MySQL, and Oracle