Database Administrator Postgresql Dba

Summary:

• Over * years of experience as DBA in development and production environments. In-depth knowledge in supporting and managing Postgres & MSSQL databases.

• Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages. Adopt developer experience to drive process improvements.

• Experience in handling large scale database upgrades and server migrations. Ensure database availability and handle database capacity issues.

• Solid understanding of Incident Management, Problem Management, and Change Management.

• Implement DevOps best practice to streamline agile SDLC and optimize time to delivery applications.

• Superior communication, presentation, analytical and problem-solving skill. Work well with our partners, vendors and all levels of business.

• Participated in evaluation, design and implementation of new and major enhancements of business applications.

• Aligned systems with business needs to enhance scalability of database structures and recommend improvements. Technical skills:

Skills Processionary Total years Last used

PostgreSQL Advanced 3 Present

MSSQL Advanced 3 Present

Shell scripting Intermediate 3 Present

Qualifications:

Database servers Data security

Performance tuning Database automation & deployment Capacity monitoring Strong collaborative skills

Disaster recovery planning Excellent problem-solving skills High availability Cloud-based infrastructure services Work Experience:

Database administrator, Oretes Consulting, India

Assistant professor at MITM, India

PostgreSQL DBA:

Working as PostgreSQL DBA and handling various duty of PostgreSQL DBA part of remote service group providing support to consulting clients for various projects for ongoing issue in Development, Testing and PROD environment (V9.5, V9.6, V10, V11, V12, V13, V15) including Database upgrade, Application patches and DR activities

Responsible for monitoring environments using monitoring tool PGadmin, PEM and custom scripts installed in crontab.

Installing and configuring new servers as per customer's request.

Cloning the Development, test and UAT environments with production data as per customer's request.

Design and implement disaster recovery for the PostgreSQL Database.

Configuring the backup jobs on customer system using BART & Pgbackrest. Experienced in performing PITR.

Patch, Upgrade and keep the PostgreSQL DBs current. Develop and enhance scripts to automate and execute various DBA tasks.

Assist engineering team in the design of appropriate DB Schema and indexing strategy for performance and scalability.

Identifying and resolving incidents and address to user problems/concerns. Trouble shooting database issues.

Support developers for efficient SQL query and identifying long running queries and optimizing. Setup/Maintenance of Test/Development/UAT Servers setup.

Coordinating of Service Request (SR) with business team and providing them SQL queries.

Monitoring of system logs, OS logs, database logs, trace files, database alert files to detect and troubleshoot runtime problems. Linkedin.com/in/manaswinipuhan

Highly skilled database administrator with over 3 years of experience offering a unique combination of technical and analytical skills. Extensive experience in maintaining and supporting heterogeneous database solutions utilizing PostgreSQL & MSSQL.

*************@*****.****

Planning, deploying RDBMS Upgrades/Patches and performing other weekend maintenance activities as a part of On Call support.

Active participant in discussions related to Backup Strategy, DC/DR architecture.

Maintained, patched, and upgraded servers as required.

Manage high availability using enterprise failover manager (EFM).

Expertise in Analyzing data Quality checks using shell scripts. Upgrading, installing, and configuring PostgreSQL servers.

PostgreSQL Installation, Configuration, Migration, Upgrades and Patches. Server versions ranged from PostgreSQL V9.5 to V12.

Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases.

Optimize postgresql.conf for performance improvement. Review all PostgreSQL logs for problems.

Ensure night corn jobs for backups, re-Indexing & vacuuming & materialized views executed properly on 24/7 high availability Postgres production and development databases. Also used Goldengate for database migration.

Experience supporting Nutanix Era opensource PostgreSQL database, deep knowledge on Patroni failover manager, Pgbackrest.

Ability to troubleshoot difficult issues quickly, deliver RCA and resolve in a 24x7 production environment.

Ability to work off hours/weekends as required for maintenance. MSSQL DBA:

Configured, Installed, and Maintained SQL Server 2008,2012,2014 & 2016 in development, test, and production environment

Experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers

Working experience in Database Backup, Restore and Point-in-Time Recovery

Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification

Developed Different Maintenance Plans for database monitoring

Monitor Server Activity, Error Log, space usage, and solving problem as needed.

Developed & maintained scripts, utility jobs or implement needed software for database maintenance.

Developed, tested & implemented a robust database backup and recovery strategy with client assistance.

Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks and long transactions.

Suggested Application level tuning changes for code, queries, SQL objects that may not be performing up to the optimum database performance standards.

Experience in creation of logins, users and configuring permissions and assigning roles to users.

Configured and maintained high availability features like Replications, Log Shipping and always ON.

Monitoring and Tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, Windows Performance Monitor.

24 x 7 Production Database on Call Support. Excellent Analytical, problem solving and communication skills.

Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent and interpersonal and teamwork skills. Technologies Used:

Operating system: Windows, Linux

Special software: SQL Server Management Studio, SSIS, SSRS, Putty, SCOM.

DBMS: PostgreSQL (EDB and Open source), MSSQL.

Tools/Platforms:

PGADMIN, PEM, Grafana, ServiceNow, Putty, Ansible. Academic qualification: Bachelor of Technology in Electrical Engineering, Biju Pattnaik University & Technology(BPUT), Rourkela, Odisha, India

Contact this candidate