Database administrator Resume

SUMMARY

Overall Experience of 14 years as Database administrator with extensive experience in New builds, Production support for databases in db2.
Worked on several new build and configurations for stand - alone, HADR and partitioned databases
Successfully completed database patching and migrations for db2 databases.
Automated backup and database maintenance tasks for db2, postgresql.
Successfully implemented HA for on-premise databases and DR solutions on-prem and cloud db2 databases.
Database migration in Azure across regions
Excellent Analytical, troubleshooting,documentation and communication skills and open to new skills learning curve and implementations.
Worked with US, European clients across Banking, Retail, Investments, credit card company and experience in server multiple customers part of dba teams.
Experienced in troubleshooting, Performance tuning, capacity planning and involved in architecture, design and configuration of databases for on prem and cloud.

TECHNICAL SKILLS

Databases: DB2, postgresql, mysql, couchbase, Teradata, db2connect.

Operating systems: Windows, Linux, Aix, Solaris

Cloud: Azure, Aws

Language: SQL, Unix shell scripting.

PROFESSIONAL EXPERIENCE

Confidential

Database administrator

Responsibilities:

Installation and configuration of db2 database software and ensure high availability of databases.
Trouble shoot db2 issues and tune the performance of all database systems.
Proactively monitor databases and plan for capacity and ensure optimal performance.
Ensure all the databases in good health on a daily basis and report critical functional parameters to client.
Provide solutions to repeated issues and manage problems related to the same.
Respond to high severity issues and resolve within the agreed service level agreements
Plan, coordinate, implement schedules db2 software patches and maintenance.
Ensure critical databases are highly available for business demands
Lead the efforts for customer s backup and restore requests.
Participate in security meetings to plan, strategize, implement db2 related Security requirements .
Lead the efforts for db2 related audits for customer requests and make the database compliant with required regulatory standards
Involve and follow the Change, Incident, Problem management policies set by the client and make the db2 databases compliant for the same.
To identify and recommend available database features to customers in sync with business demands and implement the same.
Participate in Business continuity plan and ensure disaster recovery exercises are implemented successfully.
Installed and configured Couchbase database in single and multiple nodes for linux servers.This couchbase systems are part of a tier 1 critical fraud detection applications
Setup Couchbase XDCR configuration between Prod and DR for high availability and disaster recovery purposes.
Couchbase single and multinode backup and restorations
Couchbase logs monitoring and data flushing for development.
Couchbase LDAP integration for database servers.
Couchbase health check and user access grants and revokes
Couchbase replication stop/start deletion between primary and standby in XDCR setups
Installed and configured EDB postgresql databases.Setup archival logs, backup, restore tested. Migration from postgresql community version to EDB postgresql versions.
Setup SSL configurations for community postgresql and EDB postgresql.
Setup roles and privileges for application users, administrators for EDB postgresql .
Postgresql community version migration from 9.6 to 10.11
Postgresql community version 10.11 to EDB 11.1 migration.
LDAP integration from EDB postgresql.
Health check and compliance scan remediations for EDB postgresql databases to comply with Banking regulations and CIS standards conformity.
Set up MySQL on windows servers for loan processing systems.
Data load, backup, restore for MySQL databases.
Knowledge on AWS.

Confidential

Database administrator

Responsibilities:

Design, strategize and Architect db2 database new build solutions in SAP, Microsoft Azure cloud with Linux virtual machines
Design highly available automated failover db2 databases in SAP, Microsoft Azure virtual machines
Configure the databases with maintenance scripts and required parameters to run as per business requirements with frequent health checking and reporting.
Responsible for database readiness for client and third party auditing.
Responsible for testing and delivering new db features like backup software to the existing and new environments for databases.
Support customer, database and infrastructure patching requests.
HADR db2 configuration with TSA setup for applications
Database Azure migration from US east to US east2 region.
DB2 database encryption using IBM gskit.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship