SUMMARY

• Seasoned Database Administrator with 12 years of experience in system and software analysis, design, development, maintenance including around 8+ years of DBA experience in SQL Server and DB2 on Mainframes, Windows
• Very good experience in Installation, configuration and maintenance of SQL Server.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Very good T - SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
• Experience in Database backup and disaster recovery procedures.
• Experience in Replication - Transactional.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load and Table partitioning
• Created SSIS Packages for Data Migration and Transformation. Experience in data migration from Excel Sheets to SQL Server
• Worked in OLTP & OLAP environment that includes Pre Production (24x7), QA and development databases in SQL Server.
• Has Knowledge of Analysis Services & Reporting Services, SQL Server Clustering AlwaysOn Availability for HADR, Database Mirroring and Log Shipping,
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Has the ability to work in a fast paced environment, Good team player and can work independently. Helped the database developers on technical issues.
• Creating Logins, Schema and Users
• Granting appropriate permissions to the Users
• Extensively used Performance tools like SQL Profiler, Activity Monitor and DTA (Database Tuning Advisor), Redgate Monitor
• Perfmon and Activity Monitor to monitor the database performance
• Used DMV (Dynamic Management Views) to administer SQL Server Databases
• Developing SSIS packages to load data from Excel sheets to tables in database
• Used Import and Export tool to load data
• Designing the database using ERWIN
• Implementing data structures designed in ERWIN
• Generating DDLs using reverse engineering of ERWIN
• Performance Monitor (Perfmon) for checking Database Health
• Extensively used Red Gate tool for Schema Compare, Data Compare and to generate Test data
• Scheduling regular backups
• Extensively used DBCC (Data Base Console Commands) to maintain databases
• Created Management plans and scheduled jobs for daily backups, Update statistics, REORG and Rebuild Indexes.
• Strong experience in Creating, maintaining and tuning the databases in development and testing environments on both Mainframes and Windows
• Migrating data from legacy systems to DB2 on Windows and SQL Server
• Setting Alerts for Database space issues
• Implemented database standards and naming convention for the database objects.
• Table Partitioning for better performance
• Wrote Automated scripts to execute Alter scripts to run in different environments
• Extensively used RED GATE Schema Compare, Data Compare tools, Synchronization of data and generating test data
• Worked on Transactional REPLICATION
• Developed automated process to refresh the databases using SSIS packages
• Strong background in Database administration of DB2 UDB on Mainframes and Windows
• Extensively used Utilities like LOAD, UNLOA, RUNSTATS, DSNTIAUL, DSNUPROC for refreshing the Test Environments
• Worked on DB2 Control center
• Worked on DB2 DDL scripting
• Automated the process of Creating and Altering database objects using DB2 scripts
• Worked on Data Studio and DB2 optimization Service Center
• Extensively worked on BMC tools, CA Platinum Tools R/C Query
• Knowledge of Omegamon performance tool
• Performance Tuning using DB2PM
• Providing 24 × 7 DB2 Support for Production.
• Scheduling regular backups / Image Copies and REORG and RUNSTATS
• Weekly/Monthly production staging/migration.
• Worked on updated versions of mainframes version 8.1 and version 9.1
• SQL performance Tuning
• Maintaining the databases environments for Production and Test regions.
• Troubleshooting database problems encountered in normal day to day running of a production database within stipulated times as defined SLAs.
• Proven leadership, mentoring skills and consistent track record of building good rapport with customer, end users, team members and management in a short span of time.
• A follower of continuous learning, knowledge sharing and result oriented approach to make significant contributions to the top and bottom line of an organization.
• Good analytical, problem determination, customer interaction and interpersonal skills.

TECHNICAL SKILLS

Databases: SQL Server, DB2

Data Modeling Tool: ERWIN

Platforms: Windows and Mainframes

Microsoft Technology: SQL Server 2008 R2, SSIS

IBM Technology: VS COBOL II, JCL, VSAM, CICS

Operating Systems: MVS, Windows, Z/OS

Tools: SQL Profiler, Database Tuning Advisor (DTA), ERWIN, REDGATE, PERFOMON, BMC tools, CA Platinum Tools R/C Query, DB2PM, Data Studio and DB2 optimization Service Center, FILE-AID, CHANGEMAN, STROBE, ENDEVOR, SPUFI, SDSF and QMF

PROFESSIONAL EXPERIENCE

Confidential

DBA

Environment: SQL Server 2008 R2, Visual Studio, SSIS

Responsibilities:

• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Implemented database standards and naming convention for the database objects.
• Developing SQL scripts for maintaining administration tasks.
• Tuned the SQL queries using SQL profiler.
• Involved in tuning the database using Profiler and Perfmon tools
• Updating with latest service packs and security patches.
• Partitioned the Database based on business requirements
• Supporting Conversion team in tuning SP’s and Tuning SSIS packages
• Maintain all the SQL documents include installation and data conversion Procedures documents.
• Trouble shooting Problems by using SQL server profiler.
• Solved critical production problems and performed point in time recovery plans.

Confidential

DBA

Environment: SQL Server 2008 R2, Visual Studio, SSIS, IBM Z/OS 1.7, ISPF 5.7 Mainframe, MVS, JCL, DB2 V8.1, DB2 V9.1, Windows, DB2 on Control Center

Responsibilities:

• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Implemented database standards and naming convention for the database objects.
• Developing SQL scripts for maintaining administration tasks.
• Tuned the SQL queries using SQL profiler.
• Involved in tuning the database.
• Updating with latest service packs and security patches.
• Based on the business need created all three replication models on different applications.
• Implementing stand by servers and Log shipping.
• Involved in developing stored procedures, triggers for the application.
• Estimating of Table sizes and Record sizes.
• Maintain all the SQL documents include installation and data conversion Procedures documents.
• Trouble shooting Problems by using SQL server profiler.
• Solved critical production problems and performed point in time recovery plans.

Confidential

SQL Server DBA, DB2 UDB DBA on Z/OS and Windows

Environment: SQL Server 2008 R2, SSMS, SSIS, IBM Z/OS 1.7, ISPF 5.7, Mainframe, MVS, JCL, DB2 V8.1, DB2 V9.1, Windows, DB2 on Control Center

Responsibilities:

• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Implemented database standards and naming convention for the database objects.
• Developing SQL scripts for maintaining administration tasks.
• Tuned the SQL queries using SQL profiler.
• Involved in tuning the database using Profiler and Perfmon tools
• Updating with latest service packs and security patches.
• Based on the business need created all three replication models on different applications.
• Implementing stand by servers and Log shipping.
• Involved in developing stored procedures, triggers for the application.
• Estimating of Table sizes and Record sizes.
• Maintain all the SQL documents include installation and data conversion Procedures documents.
• Trouble shooting Problems by using SQL server profiler.
• Solved critical production problems and performed point in time recovery plans.
• Creating and maintaining the database environment on Mainframes and Windows platforms
• Providing support to application team in everyday activities
• Performance Tuning (Both Database and SQL tuning)
• Moving data cross platforms i.e., from Mainframes to Windows and vice versa
• Creating Federated object likes Wrappers, Server Definitions and Nicknames
• Troubleshooting database problems
• Backups

Confidential, Torrance, CA

DB2 DBA

Environment: IBM Z/OS 1.7, ISPF 5.7 Mainframe, MVS, JCL, DB2 V8.1

Responsibilities:

• Providing support to Test applications
• Regular backups / Image Copies.
• Performance Tuning (Both Database and SQL tuning)
• Weekly/Monthly production staging/migration.
• Develop and execute appropriate Data Definition Language (DDL) to support projects.
• Creating new Tablespaces and new tables.
• Using Changeman to move to Production
• Maintaining the databases environments for Production and Test regions.
• Troubleshooting database problems

Confidential - New York

DB2 DBA

Environment: IBM Z/OS Mainframe, MVS, JCL, DB2 V9, VSAM, BMC tools, CA Tools

Responsibilities:

• Providing support to both Test applications and Production applications
• Extensively worked on BMC tools
• Providing 24 × 7 DB2 Support for Production.
• Regular backups / Image Copies.
• Performance Tuning (Both Database and SQL tuning)
• Weekly/Monthly production staging/migration.
• Develop and execute appropriate Data Definition Language (DDL) to support projects.
• Maintaining the databases environments for Production and Test regions.
• Troubleshooting database problems encountered in normal day to day running of a production database within stipulated times as defined SLAs.
• Upgrade mainframes from version 7.0 to 8.0

Confidential

DB2 DBA

Environment: IBM Z/OS Mainframe, MVS, JCL, DB2, VSAM, BMC tools

Responsibilities:

• Proactive maintenance
• Weekly/Monthly production staging/migration
• Develop and execute appropriate Data Definition Language (DDL) to support projects
• Maintaining the databases environments for Production and Test regions
• Troubleshoot database problems encountered in normal day-to-day running of a Production database
• Monitoring schedule Backups and Reorgs, create new tables as required and help users to design applications
• Performance tuning, designing and implementing database related solutions and controlling security

Confidential

DB2 DBA

Environment: IBM Z/OS Mainframe, MVS, JCL, DB2, VSAM, IBM Admin Tools and BMC tools

Responsibilities:

• Develop and execute appropriate Data Definition Language (DDL) to support projects
• Maintaining the databases environments for Production and Test regions
• Taking ownership of problems and troubleshooting issues related to DB2 within stipulated times as defined in the SLA
• Backups and Reorgs, perform Recovery if needed create new tables as required and help users to design applications

Confidential

DB2 DBA

Environment: IBM Z/OS Mainframe, MVS, COBOL, JCL, IBM Admin Tools, DB2

Responsibilities:

• Providing support to the application team
• Weekly/Monthly production staging/migration
• Develop and execute appropriate Data Definition Language (DDL) to support projects
• Maintaining the databases environments for Production and Test regions
• Troubleshoot database problems encountered in normal day-to-day running of a Production database
• Monitoring the Schedule Backups and REORGs
• Create new databases as required and help users to design applications
• Performance tuning

Confidential

DB2 DBA

Environment: IBM Z/OS Mainframe, MVS, COBOL, JCL, DB2

Responsibilities:

• Support to the application team
• Weekly/Monthly production staging/migration
• Develop and execute appropriate Data Definition Language (DDL) to support projects
• Maintaining the databases environments for Production and Test regions
• Troubleshoot database problems encountered in normal day-to-day running of a Production database
• REORG done to improve the performance
• Performance tuning

Confidential

Mainframe Developer

Environment: IBM Z/OS Mainframe, MVS, COBOL, JCL, DB2

Responsibilities:

• Understanding the requirements provided by the clients and understanding the Business Functionality
• Analysis of the programs which deals with the functionality.
• Preparation of Detail Design document
• Coding.
• Performed DBA activities to Load and Unload the data
• Binding the programs using SPUFI and BMC tools.
• Preparation of Unit Test Plans & Testing
• Defect fixing

Confidential

Mainframe Developer

Environment: IBM Z/OS Mainframe, MVS, COBOL, JCL, DB2

Responsibilities:

• Understanding the System Investigating Report, which contains the requirements, and understanding the Business Functionality
• Analysis of the programs which deals with the functionality.
• Preparation of Detail Design document
• Coding.
• Performed DBA activities to Load and Unload the data
• Preparation of Unit Test Plans & Testing
• Defect fixing