PROFESSIONAL SUMMARY:

• Over 12 years of experience in working with DB2 Database and Linux administration along with broad range of Cloud services and it’s features in development and production settings.
• Manage internal databases starting from planning, testing and implementation. In - depth knowledge of backup and security procedures to guarantee integrity.
• Background in Linux/AIX/Windows administration, developing disaster recovery and backup plans for nationwide officers. Involved in all stages of Software development life cycle (SDLC) and Confidential ’s Lean Methodologies. Good knowledge in cloud automation applied in DevOps field using virtualization, CI/CD tools. Proficient in container based technologies.
• Excellent communication, problem solving, analytical and presentation skills. Work very well with every level of business.

TECHNICAL SKILLS

RDBMS: DB2 UDB 7.2/8.1/8.2/ 9.5/9.7,10.1,10.5 Oracle 11g, MS SQL Server, Amazon RedShift, RDS.

Cloud Services: AWS Solutions Architect

Application Server: Java, Web sphere, Ariba

Operating Systems: Linux (AIX, Linux, Sun Solaris2.6/2.8, HP-UX), Windows XP/NT/2000, 2008

Scripting/Lang: Shell Scripting, AWK, JAVA, Python, Bash, Perl

Configuration Automation: CHEF, ANSIBLE/YAML

CI/CD Tools: JENKINS, GIT, GIT HUB

Build Tools: Ant, Maven.

Container Technologies: Docker, Kubernetes.

SDLC: Agile, Lean Methodologies.

Modeling/Database Tools: DB2 SQL and Q- Replication Center, DB2 relational connect, DB2 connect, BMC Tools and Quest Tools

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. Database Administrator

Responsibilities:

• Planned and designed DB2 UDB databases for development, test and production databases using features like Auto Storage. Involved in product installation, instance and database builds.
• Worked with other teams in providing the database build requirements such as user/instance ids, file systems by calculating current database size and the growth rate.
• Experience with tuning Database configuration parameters. Worked with product support in analyzing STMM logs.
• Good experience with design and build both SQL and Q replication using Unidirectional and bidirectional parameters between staging and production servers.
• Knowledge of using Routed Protocols: FTP, TCP, SFTP, SSH, HTTP, HTTPS.
• Experience in creating system and database managed tablespaces. Involved in reducing high water mark on tablespaces after performing Reorgs/Runstats on large tables with lob data.
• Setup Disk, Tivoli Storage Manager (TSM) and NetBackup for transactional and database backup logging. Used DSMC commands to archive maintenance script output reports.
• Designed and implemented database backup and restore procedures depending on the size of the database and business requirements. Different options such as online/offline/tablespace level backups/restorations were performed at various times such as during change windows/deployments/disaster recoveries. Assisted in database restores performed using snapshots and OS cloning.
• Designed and implemented korn/bash scripts to backup database metadata (Database manager and database configuration parameters), database DDL, perform maintenance (Runstats/Reorgs/rebinds), daily database backups, log archival and HADR monitoring.
• Tune databases using tools like DB2PD, Snapshot monitor, visual explain, INDEX ADVISOR, DB2EXPLN, DB2EXFMT etc.
• Involved in setting up Tivoli tool for monitoring the database processes such as db2sys, Max Agents, tablespace container thresholds, file system thresholds.
• Involved in migrating and upgrading database product and instances to latest level of DB2 version and fix packs in AIX, Linux and Windows environment. Special build fix packs were applied after discussing the consequences with the application teams.
• Proficient in setting up DB2 environment variables based on the application requirements and security policy requirement.
• Cataloged node and remote databases based between federated systems based on the autantication requirements.
• Maintained sudoers file to provide limited sudo access to user to improve the security of theDatabase environment by avoiding shared id usage.
• Built and supported HADR in multiple environments. Performed several changes in HADR environment including OS/DB2 product upgrades apart from trouble shooting any HADR failures. Additionally, built and supported HADR with TSA and DB2 HAICU using virtual IP addresses.
• Involve in developing database application objects like stored procedures, functions, triggers and user defined data types
• Used EXPORT, IMPORT and LOAD, DB2MOVE, Cursor load utilities, moving Data between tables and Database environments.
• Experience with the command tools like top, vmstat, TOP, DB2PD etc.
• Good knowledge with disk formatting, pvcreate, creating, extending and reducing of Volume group(VG)s, Logical volume(LV)s, disk striping and file systems creation.
• Good knowledge in configuring network services like NAT, DHCP, DNS, Web Server, VPN and Firewall.
• Installed and setup RHEL servers for applications like WebSphere, Apache, Tomcat and MySQL database.
• Participate in the 24x7 on call rotation for production environment. Provide detailed over view of problem description and solution for rest of the team.
• Experience working on ticketing tools like Remedy, Service Now to resolve helpdesk tickets and change records with defined SLA's.
• Engage PMR support for DB2 engine related issues and product special build upgrades.
• Worked with backup team to backupLinuxservers using NetBackup.
• Good knowledge in ID administration in creating, changing ownership and assigning ids and group.
• Configure SSH settings in configuration management architecture.
• Performed database health checks using several Confidential policies ( GSD330, ISec ) setting up control points that will grant appropriate user and group privileges on different DB2 objects.
• Assisted in building DB2 LDAP and supported LDAP databases.
• Experience in creating both Hash and Range partitioning on tables and indexes for managing large tables.
• Setup SSH keys between servers to eliminate manual password autantication.
• Experience in Python Scripting.
• Cleared mandatory security policy certifications such as HIPPA, Hard Drive Reuse and Destruction processes for State of California, and other on boarding and off boarding certifications.
• Install and configure Ansible configuration management tool. Experience in creating Playbooks in YAML for Provisioning virtual hosts Configuration Management, Patching and software deployment to create and assign appropriate privileges to different ids and groups.
• Good knowledge with Amazon RDBMS technologies such as (Amazon RedShift and RDS).
• Implemented AWS solutions using E2C, S3, EBS, Elastic Load Balancer, Route53, Cloud Formation, Auto Scaling groups.

Confidential . Plano, TX

Database Administrator

Responsibilities:

• Confidential is automobile financing company. It’s an OLTP application which consists of 52 productions instances and 92 (Test, Dev and Staging) instances. The application mainly consists of single partition databases. However, Confidential is also built with a small data ware house environment with 6 partitions. The Confidential data ware house size is 300 gigs approx. with nearly 2500 tables and 450 schemas.
• Implement and support High availability disaster recovery process using HADR and HACMP.
• Planned and implemented the creation of DB2/UDB instances, databases, table spaces, containers and database objects.
• Build, alter and load db2 tables using tools like db2move and db2look.
• Performed daily production maintenance jobs like runstats, reorgs etc.
• Performance tuning of dynamic SQLS captured from snapshots using tools like db2 explain, db2advis, and db2 snapshots.
• Database tuning in terms of calculating buffer pool hit-ratios, reorgchks, runstats, DB CFG Heap parameters, lock escalations using db2 event monitors and snapshots
• Did periodic checks of the various database environments in terms of the growth of the data and maintained the threshold limit of 70% across all DMS table spaces.
• Creating Db2 partition groups, table spaces, partition tables, views in DPF (EEE) servers used in Data Warehouse.
• Configured SQL replication building capture/apply tables. Performed and setup scripts to monitor replication stability. Periodically reset the asnpwd files as per the security rules.

Confidential,Poughkeepsie, NY

Database Administrator

Responsibilities:

• Built materialized query tables (MQT) for improved performance.
• Cataloged nodes and remote databases using DB2 encryption.
• Implemented Confidential security policies (GSD330, ISec, ITC104) to manage users/groups having access to the database systems.
• Provided 24x7 on call support for various database systems.
• Installed/upgraded DB2 to latest level of fix pack. Migrated database environment from version 8 to version 9.
• Provide development and production support to multiple Confidential internal applications as a steady state DBA in Confidential ’s Lean process.
• Creating and maintaining the instances and databases in development, test and production environments in LINUX, AIX and WINDOWS platforms.
• Physical database design, creation, implementation & maintenance operations (file system mount points & storage parameters) and logical database mapping to physical database (storage calculations, file systems, tablespaces, rollbacks, indexes, data files & logs).
• Effectively improved Batch jobs performance by almost 50% by tuning by adding correct indexes using DB2 Design Advisor.
• Assisting in data movements across different db2 databases using tool like db2move, db2 cursor load, import etc.
• Database maintenance for development, and synchronizing it with the production database.
• Writing shell scripts to collect buffer pool and table space utilization data on a regular basis to monitor system performance trends.
• Implementation of backup and recovery tasks using Tivoli Storage Manager (TSM) and tune databases using Confidential Tools like snapshot monitor, db2exfmt, db2expln, Index Advisor etc.
• Database Clean up (development database) scripts (Unix Shell Scripts, Crontab, & SQL) for automated clean up every week.Disaster Recovery Process:
• Developed and supported HADR for different Confidential internal applications.
• Developed and supported disaster servers for various Confidential internal databases.