Post Job Free

Resume

Sign in

Database Administrator

Location:
Lutz, FL
Posted:
February 02, 2019

Contact this candidate

Resume:

Gokul Padmanabhan

Contact ac8dia@r.postjobfree.com 813-***-****

LinkedIn http://www.linkedin.com/in/go-kool/

OBJECTIVE

Professional seeking a senior Database Administrator position.

--

SYNOPSIS

Professional with over 16-years database administration experience in DB2 LUW (Unix), 2 years in Oracle and PostgreSQL (AWS) and 24 years in Unix / Shell scripting.

Experienced in DB2 LUW versions v10.5 on Linux, AIX and Solaris. Installed and deployed DB2 LUW v10.5 and PostgreSQL databases on Amazon(AWS) cloud.

Familiarity with DB2 High Availability Disaster Recovery (HADR), Q-Replication, SQL Replication

and Log Shipping; Performed database backups and restores, failover and failback.

Proficient in physical database design techniques and performance tuning.

Created, Configured and Administered DB2 LUW databases in a cluster and standalone

environments, and in the cloud on AWS.

Dedicated team player with strong work ethic and fast learning curve; excellent communication and troubleshooting skills.

--

PROFESSIONAL EXPERIENCE

OCT 2005 – Present VERIZON Tampa, FL

Database Administration & Systems Engineer

Database Administration - DB2 LUW version 9.7/10.5, Oracle, PostgreSQL, MySQL; DB2 HADR, SQL/QReplication, WebSphere MQ, Goldengate; Amazon Web Services(AWS) – EC2/RDS, Jenkins, Stash, Artifactory, DataDog; UNIX Shell Scripting

Deployed Amazon EC2 DB2 LUW and RDS Aurora PostgreSQL databases into the AWS cloud. Responsible for creating Linux(EC2) servers, carving out storage, creating database users, deploying database binaries, creating and populating databases via export/import and by using AWS Schema Conversion tool (SCT) and Data Migration service (DMS). Built CI/CD pipelines and worked with Jenkins, Stash and Artifactory.

Used variety of database utilities and tools for administration and maintenance.

Utilities such as db2top, db2pd, db2explain, db2advis, db2batch, db2rbind, db2runstats, db2reorg, PSQL etc.

Tools like Toad for DB2, IBM Data Studio, Quest Central, DB2PE, Control Center, SQL/Q Replication Center, pgAdmin4, DBeaver and Toad for Oracle.

Replication technologies including SQL replication, Q Replication (WebSphere MQ), HADR, Log shipping, Goldengate. Created and managed MQ queues and channels.

Determined project requirements; planned for database backup & recovery, infrastructure, capacity and maintenance. Designed physical databases to meet project performance objectives. Participated in Disaster Recovery exercises.

Monitored and tuned databases for performance, provided query analysis, expanded / rebalanced tablespaces. Troubleshoot issues related to database locks, memory/CPU, heap, swap etc.

Installed and configured DB2, Oracle, MQ and Goldengate. Built and tested DB2 System5 and RPM installation packages for database product deployments on Linux, AIX, Solaris and Amazon EC2 servers.

Provided 24x7 DBA supportGokul Padmanabhan

--

APR 2003 – OCT 2005 ALGOMOD TECHNOLOGIES Tampa, FL

Software Consultant (client: Verizon)

Database Administration - DB2 LUW version 9.7, DB2 HADR, SQL Replication, UNIX Shell Scripting

Provided 24x7 database support for DB2 LUW databases.

Performed database upgrades; backup and restore/rollforward operations; failover and failback

Developed shell scripts to monitor databases and to generate alerts for critical situations

--

APR 2003 – OCT 2003 COTT INDUSTRIES Tampa, FL

Software Consultant

Database Administration - Oracle; Unix Shell Scripting

Developed UNIX shell scripts to automate invoice reconciliation reports.

Performed database loads and unloads; Implemented database life-cycle maintenance.

--

SEP 2000 – APR 2003 AT&T LABS Tampa, FL

Database Developer (DB2 DBA - Development)

Database Administration - DB2 LUW; C Programming; Perl Scripting; UNIX Shell Scripting

Managed clustered databases, performed database migrations, and produced SQL queries for

applications and reporting purposes.

Implemented unidirectional and bidirectional SQL replication.

Developed mass-mailer facility to extract customer information from a database, and relay service level

communications.

Developed secure authentication, encryption algorithms and validation schemes to mask messages, and

eliminate credit card fraud.

Documented project designs, test cases and install documents to conform to ISO 9002 software quality

procedures and specifications.

--

DEC 1994 – SEP 2000 STRATEGIC STAFFING SOLUTIONS Tampa, FL

Software Consultant (client: Advantis, IBM, AT&T Business)

Web Administration; Perl Scripting; UNIX Shell Scripting

Developed Perl scripts for applications.

Designed a problem reporting engine, and a web-based knowledgebase containing resolutions for

customer issues. Created Order entry application for software kits.

Designed and built web applications using NetObjects and FrontPage; administered NCSA, Apache and

Netscape Enterprise servers.

EDUCATION

AUG 1986 – APR 1990 Osmania University Hyderabad, India

Bachelor of Engineering

--

MISC

U.S Citizen; preferred full time/long term opportunity, remote work opportunity

--

REFERENCES

Upon request



Contact this candidate