Job
Description
Job Description Designation : Postgres DBA Job Location : Chennai Job Objective The Database Administrator role is to administer design database schemas, all type of database objects like tables, views, stored procedures, functions etc for IT project, including maintaining databases while ensuring high levels of data availability. The Database Administrator will evaluate and advise on all technology components for database management systems and applications. They may handle databases for entire systems as well as for individual applications. Using their analytical and problem-solving skills, database administrators help companies structure their data in a way where it's easily accessible, valid and secure environment. work on continues upgradation of technical artifacts. Core Responsibilities: Postgres SQL, SQL Server, Enterprise monitoring. Extensive work experience on query optimization, script optimization, other related optimization tools and techniques including Performance monitoring. Design and create database objects such as data table structures, stored procedures, views, Triggers, reports, Database Administration, Configuration, Maintenance and Support. Data migration, backup, restore & recovery, Resolving performance issues, blocking and deadlocks. Implement and Monitor 2-Node Active\Passive clustering to provide High Availability for mission critical events, database mirroring, replication and log shipping. Implement and maintain security and integrity controls including backup and disaster recovery strategies for DBMS. Help in translating business requirements into technical design specifications and preparing high-level documentation for the Database Design and Database Objects. Create alerts and notifications, operator, Database mail configuration for system errors, insufficient resources and fatal database errors. Database partitioning, replication, Migration Able to handle large database (more than 1 TB) Integrate Database with Windows Active directory security for database/table level permissions Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts. Coordinate and work with other technical staff to develop relational databases and secondary databases, Identify inefficiencies in current databases and investigate solutions. Diagnose and resolve database access and security issues. Plan and execute data migrations between different database systems. Develop, implement, and maintain change control and testing processes for modifications to databases. Ensure all database systems meet business and performance requirements. Creating and scheduling Jobs in Database, ETL, deploy SQL patches, Perform Data Migration Activity. Coordination with respective OEMs/Vendors. Education and Experience Education: B.E or B.Tech in CS or PG in IT/CS or equivalent Experience: 10+ years of experience in database administration using Postgres Work experience must span over 5 turn key projects (end to end) as DBA Certification in DBA Essential Skills Experience in Postgres database architecture logical and physical design Experience in Postgres SQL/ MS SQL Server database architecture logical and physical design (preferable) Knowledge of BI tools Experience of querying/ data retrieving using multiple database types Exposure to Database administration jobs Scheduling tasks, jobs, and data migration Knowledge of Postgres administration on Linux / Windows Knowledge of Client tools for Postgres/ MS SQL Regards, ManikandaPrabhu J Process Lead - Human Resources linkedin.com/in/manikandaprabhu-j-8ab5b115b
