Database Administrator Resume

SUMMARY:

8+ years of total IT experience, 5+ years of IT experience
Good Understanding of SQL usage in different databases, SQL scripts and stored procedures.
Hands on experience in creating database objects as Tables, Table spaces, Indexes, Views, MQTs, Triggers.
Experience in designing of tables paces based on the requirement of project.
Sound Knowledge in using Mainframe OS and have good hands on experience in using ISPF interface, Spoofi, QMF, SCLM and JCL
Worked with Cognos and ETL development teams and have understanding of reports and ETL.
Ability to meet deadlines and handle multiple projects and multiple tasks, flexible in work schedules.
Strong communication, interpersonal skills and adopt in working in onsite / offshore model.
Sound knowledge of SQL and Database administration on DB2 on Mainframes.
Extensive experience in using Mainframe utilities as COPY, LOAD, UNLOAD, REBUILD, DSN1COPY, DSN1PRNT, CHKINDX, RUNSTATS, REPAIR, CHKDATA, REORG.
Met SLAs for all production issues and timely response in resolving issues addressed by team members in dev and test environments.

TECHNICAL SKILLS:

Database: DB2, Oracle, SQL Server

Languages: SQL, C, C++, Java, HTML

Scripting languages: JCL

Mainframe Tools: ISPF, Spoofi, SCLM, Omega Mon, QMF, CLAS,SDSF

Operating Systems: AIX, Unix, Mainframes, Windows.

Others: MS Office (MS - Excel, MS-Word, MS-PowerPoint, MS-Project 2000), Lotus Notes, Remote Desktop, Toad, SQL * Loader, SQL Query Analyzer.

EXPERIENCE:

Confidential, Philadelphia, Pennsylvania

Database Administrator

Responsibilities:

Performed data modeling and implemented database design to support the project planning process.
Assisted Application developer teams in database and application tuning for optimal performance
Provided Support for DBA activities across Build, Test, UAT and Production environments.
Provided on call weekend production support and performed RCA (Root cause analysis) for Production Issues.
Created the DR (Disasterrecovery) environment and performed backup and recovery.
Worked with Operations teams to configure jobs and set schedules for Business reporting.
Managed database growth and performance with database reorgs
Performed reorgs on a monthly basis and installed quarterly application releases.
Prepared detailed improvement plans of problem records and their resolutions.

Confidential

DB2 z/OS - DBA

Responsibilities:

Supported several applications, worked with application analyst on design, testing and tuning. Created Confidential for new Databases, tablespaces in the unit test, system test and production system.
Worked on designing tablespaces and tables as providing space constraints choosing the type of table space required and creating indexes on columns based on the requirements of project.
Worked on creating database objects like tables, views, indexes, sequences, MQTs, triggers etc.
Maintaining databases which involve taking Backups, performing Runstats, checking the space indatabases in all the environments Test, Dev, QA and Production.
Prepared JCLs to perform creating and modifying database objects where Confidential script is provided as inline member.
As a DBA, created RACF (DB2 security) groups and granted the needed DB2 access authorities for individuals, application groups and production jobs through CLAS.
Identified inefficient SQL code and made recommendations for improvement.
Troubleshooting common SQL codes and error messages. Worked on Query Performance.
Worked on SQL updates.
Loaded and refreshed non-production databases for application testing.
Provided 24/7 on call support for production databases on a rotation basis.
Performed image copy, recovery, and reorg, modify and loads.
Creating and modifying Database objects.Adding new tables, modifying structure of tables and removing tables.
Developing and maintaining database standards and naming conventions.
Granting rights/privileges on database objects through CLAS.
Performing daily database health check. Troubleshooting common SQL codes and error messages.
Worked on utilities like LOAD, IMGCOPY, UNLOAD, DSN1COPY, DSN1PRNT etc.
Worked on Recovery of LOB tablespace.
Worked on project specific issues where we come across Windows DB interface such as creating views, logical files and physical files.
Worked on up gradation of stored procedures.
Created and maintained LOB objects.
Creating and modifying Database objects.
Adding new tables, modifying structure of tables and removing tables.
Worked on giving access to end users on Database objects through CLAS.

Confidential

Database Administrator

Responsibilities:

Supported testing of API's whenever there is some code changes.
Worked on SCLM to upgrade changes made in code and correct if there are any errors.
Troubleshooting common SQL codes and error messages.

Confidential

Database Administrator

Responsibilities:

Worked on testing of ETL scripts.
Worked on testing of Cognos reports.
Worked on SQL queries.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship