SUMMARY

• 18+ Year’s of IT industry experience encompassing a wide range of skill set & roles
• 18+ Years working experience as DB2/UDB Database Administrator On Unix/ZOS environments
• 10+ years working experience in designing OLAP & OLTP data models as Data Architect.
• 9+ Years working experience in Data and Application Administration for ORACLE & SQL Servers.
• 7+ years working experience as database administration for NO SQL (MONGODB & Hadoop) database.
• Extensive experience on Data staging, ETL and data warehousing methodologies as Data Architect.
• 6+ Years’ experience as SAP basis administrator and SAP FICO
• Good working experience on HANA,Teradata,GeoSpatial, Informix,Bigdata,Hadoop database environments
• Strong shell scripting, Power shell, Perl and SQL scripting skills.
• Confidential certified professional and extensive hands on experience wif Confidential technologies.
• Good Working experience in Replication process Failovers,DPROP,Purescale,RAC,HADR, HACMP skills
• Good communication skills, interpersonal skills, self - motivated, quick learner, team player.

TECHNICAL SKILLS

RDBMS: Confidential db2 UDB V7/V8/V9/V10/V11, SQL2005/2008/2012Server, Oracle8.1,10G,11G Informix,IMS,IDMS,Sybase ASE/IQ, MongoDB, Progress,Hana,Teradata,Geo database, Big data, Hadoop.

Languages: VB script, Net, Java,PL/SQL,A.S.P 2.0, COBOL, Shell script, Power shell, Perl script.

O/S: AIX, SOLARIS, Linux, Z/Linux, WINDOWS and OS/390

Tools: DB2MON, Erwin, TSO, SMIT, CA-7, OMEGAMON, SPUFI,Query Patroller, Replication center,DB2 Control Center, TDadmin,Sql Assistance, Visual Explain,Toad,TASM,DBArtisian, Aqua Studio

Process: Remedy, Site scope, HP Service Desk management, TSE Bugzilla,Citrix

Software: SAP NetWeaver, SUN JDK 1.5, TOMCAT, Apache Web Server, IIS, SSIS, SSAS,SSRS.

PROFESSIONAL EXPERIENCE

Confidential, Lansing, Michigan

Database Administrator

Responsibilities:

• Created data models, solution designs and data architecture documentation for complex information systems and managed all changes to the data models.
• Worked wif project and application teams to ensure dat they understand and fully comply wif data quality standards, architectural guidelines and designs.
• Developed, tested and version controlled physical database changes & application system databases.
• Installing & Configuring, implementing and supporting database systems & clusters.
• Applying fix packs, service packs and performing version upgrade for database systems.
• Monitoring users wif the audit facilities and revoking permissions.
• Monitoring and configuring buffer pools for improving database performance.
• Tuning SQL statements using the explain facility and advise utilities.
• Performed SQL tuning and bind plan/package creation for enhancements and developments.
• Designed, debugged and implemented stored procedures and triggers
• Optimized SQL queries dat helped improve application performance
• Supported application programmers and users in their daily interactions.
• Performing database clones from production to load and regression systems
• Involving database design for capacity planning and metadata databases.
• Design & implement indexing strategies for improving database performance
• Moving data between database environment using data moving utilities.
• Database maintenance tasks and recycling instances during maintenance window.
• Creating and maintaining conceptual, logical and physical data models.
• Worked on 9 different database management systems and related technologies as dba
• Design, create, and alter databases and database systems.
• Maintain databases (backups, reorgs, run stats, rebuild indexes)
• Monitor, analyze and tune databases (collect, store, and report on database metrics)
• Support to Application teams wif database requests,problems, changes, and projects
• Automate database-related processes through Shell, Power shell and Perl scripting.
• Plan, design, test, and implement database failovers (provide for high availability and recoverability)
• Documenting database-related processes and procedures.
• Support internal and external audits and manage database licenses.
• Applying weekend change controls across all RDBMS after customer approvals.
• Participating disaster recovery drills and scheduled failovers during maintenance window.
• Involving database activities and changes during maintenance window.
• Migration of DB2 UDB database from V10.5 version to V11 Version.
• Worked on data migrations between different RDBMS.

Environment: DB2 LUW,DB2 ZOS,SYBASE ASE/IQ, ORACLE11G, SQL SERVER, POSGRESS, MONGODB, HRDW,AIX,Linux,DBARTISIAN,DB2PURESCALE,HADR,TSA,TSM,,OMEGAMON,CA7,Remedy,TWS,HUB&SPOKE,ORACLERAC/GRID,AQUASTUDIO,NAGIOS,PL/SQL,POWERSHELL,PLAYBOOKS,SSIS,SSRS,SSAS,DEVOPS,AWS CLOUDS, ETL, ERWIN, Confidential WebSphere/MQ/Informatics/Rational data Architect, Visual Explain

Confidential, Austin, Texas

Database Administrator

Responsibilities:

• Performing database installations, instance creations, instance upgrade and version migrations on production servers.
• Managing Database user privileges (Granting & Revoking permissions after approvals from Customer).
• Performing all system admin tasks related to db2 admin tasks..
• Database monitoring (Free space in table space, event monitor outputs, security reports)
• Performing database security audit reviews by using db2shc tools and removing all the violations.
• Migrating databases and applying fix packs for db2 udb databases on Aix servers.
• Database backup & recovery experience wif offline, online full & incremental backups and restores & roll-forward including redirected restores.
• Configuring and Monitoring the HADR setup on the database servers.
• Setting SQL/QUEUE propagation from source databases to target databases
• Monitoring the capture process at source servers and Apply process at target servers.
• Supported to development teams for wif database structural changes & database access issues.
• Worked wif different GUI tools like db2mon,db2 control center, command center, replication center.
• Monitoring paging space and memory usage and taking appropriate actions when they reaching thresholds.
• Increasing file systems and logical volumes as in the process of adding space to tablespaces..
• Monitoring all scheduled jobs and job logs and taking actions if any jobs stopped.
• Performed SQL tuning for improving the performance of queries.
• Monitoring all database servers and bring them up when databases are down.
• Troubleshooting & fixing problems faced by application developers.
• Source data analysis / profiling where necessary to support ETL design.
• Developed necessary metadata repositories to ensure to flexibility for future growth.
• Configured, and monitored Informatics on Windows operating systems.
• Starting and stopping MQ servers, WebSphere, Info Sphere servers .
• Monitoring queues and trouble shooing Queue replication issues.

Confidential

Database administrator

Responsibilities:

• Resolving the Problem tickets of different severity levels during off shore support.
• Responding calls from operations and resolve all database issues
• Monitoring all database servers and bring them up when databases are down
• Responding calls from operations and resolve all databases
• Running run stats and reorgs on tables as per requirements.
• Moving databases for various environments using db2 utilities
• Monitoring locks & Deadlocks and solving lock issues
• Monitoring and Handling table space and file systems space issues.
• Created ETL jobs to load external db servers data into MongoDB and transported MongoDB.
• Develop data models for data warehouses and operational data stores.
• Translated business requirements into logical and physical data models.
• Setup and maintenance of environments created to support projects
• Data loading and extraction from spreadsheets and different source files.
• Created source to target documents for ETL developers.
• Performed Basis support activities, printer support, security and authorization for SAP users.
• Responsible for daily R/3 Basis Administration tasks.
• Installation, Configuration, upgrades and Administration of SAP Applications

Environment: DB2 v9.1.0.2,Remedy,Teradata,DB2 MON,AIX 5.3,Erwin,Oracle,SQL server Confidential WebSphere/MQ/Infospere/Rational data Architect, Visual Explain,ETL,SAP R3,HANA,SAP NetWeaver.

Confidential

Database administrator

Responsibilities:

• Setting Crontab, scheduling jobs like backups,reorgs,runstats,space checks and Monitoring scheduled jobs
• Monitoring locks & Deadlocks and solving lock issues.
• Loading data from production servers to development and testing servers as per customer request.
• Monitoring performance of databases & HADR process.
• Restoring databases for various environments as per customer request.
• Stopping and starting DB2 HADR servers during maintenance window.
• Switching database roles and performing HADR failover operations.
• Setup and configuring database parameters related to HADR.
• Involved SAP R2 basis administration tasks.

Environment: DB2 UDB 7.2 and 8.1, DB2MON,HADR,AIX 5.3 Oralce,SQL Server,Sybase,SAP R2.

Confidential

Database administrator

Responsibilities:

• Creating instance and database objects(databases,tablespaces,tables,indexes and views)
• Setting crontab, scheduling jobs like backups, reorgs, run stats and monitoring scheduled jobs.
• Monitoring table space and file systems space usages and fixing all space issues.
• Responding calls from operations and bringing databases and replications online when stopped.
• Granting authorizations to users to access db2 database as per customer request.
• Involving databases upgrades and applying fix pack on regular basis.
• Creating users, groups, Resetting users passwords and removing locks on userids on unix environment
• Creating file systems, logical volumes and assign them to table spaces.
• Mounting file systems and un mounting file systems.
• Increasing file systems and logical volumes as in the process of adding space to tablespaces.
• Removing users, groups,file systems and logical volumes when they are not needed.
• Setting propagation from source databases to target databases.
• Removing props to source database to target databases.
• Monitoring the apply process at source server and capture process at target servers.
• Participate in root-cause analysis of recurring issues, system backup, and security setup.
• Maintain Web servers, file servers, firewalls, and directory services, and set up user accounts.
• Perform software installation, upgrades/patches, troubleshooting, and maintenance on UNIX servers.
• Administered workstation configuration and connectivity to servers, databases, and applications.
• Responsible for capacity planning, including allocating storage,

Environment: DB2 LUW, AIX,DPROP, Confidential WebSphere, SAP R2,SAP FI/CO,Linux,ZOS

Confidential

Application DBA

Responsibilities:

• Installing db2 udb and db2 connect on Linux and windows servers
• Creating db2 database objects on os/390 servers
• Establishing connection from db2Luw on Linux to db2 servers on OS/390
• Configuring on db2 connect on Linux and Windows servers as gateway servers.
• Developed triggers, functions and stored procedures.
• Assisting developers for database access issues and client installations.
• Working wif the application development team to ensure dat appropriate and efficient SQL is being coded.
• Monitor and tune SQL as well as other aspects of the database and applications for database performance.
• Analyzing index usage and creating new indexes based on db2advis recommendations for performance.
• Troubleshoot application/database issues during development/testing and deployment phases.

Environment: DB2 UDB EEE 7.2 and 8.1, DB2 connect, LINUX,OS/390

Confidential

Information Analyst

Responsibilities:

• Executing scheduled Change management tickets and Service requests.
• Resolving the Problem tickets of different severity levels during on-call support.
• Creating physical schemas and database maintenance scripts.
• Creation of all DB2 objects in both Test and Production environment.
• Performed Capacity planning and tracking table space and file systems.
• Performed loads, backups, and recoveries as needed.
• Research and resolve data base problems and database access issues.
• Monitoring the scheduled jobs like backups, data loads etc.
• Participated in crash recoveries and version restores.
• Gathering and analyzing requirement, developing project plan and design.
• Developed stored procedures and performed table design changes.
• On call support for trouble shooting production database issues and job failures.
• Planning, reviewing and executing database Deployments during weekend schedules.
• Executing change controls on DB2/ZOS environment through TSO,SPUFI.
• Working wif Storage and Systems administrators on storage &OS issues related to Databases.
• Troubleshoot database production problems and database connectivity issues.