Yyyyyy x. yyyyyy

0000 xxxxxx xxxx , xxxx , xxxxx 00000

xxx-xxx-xxxx

abc@xyz.com

Senior Database Administrator

 

Results-oriented Sr. Database Administrator with over 15 years of experience on OS/390 DB2, as well as 4 years of Oracle and 1 year of Teradata database experience. Demonstrated expertise in database administration, database design, tuning databases, and software development solutions with a proven background of technical problem-solving. Self-motivated, responsible, and reliable team player with a comprehensive technical background.

  Software:  OS/390 DB2 ver 8, Oracle 10g, Teradata, Platinum, BMC utilities like catalog manager, Apptune, Log master, File-aid for DB2,SPUFI, TOAD for Oracle, Grid control, I3, COBOL/SQL store procedure, DB2 connect, , MVS utilities, ER Studio, RACF, Vanguard, CA7 , DB2 Replication DPROPR, CICS, CICS Web Enable, MVS JCL, TSO, Endevor, DB2 connect, CA7, FILEAID, Omegamon for DB2, DB2 Insight, QMF, QMF Form, MICROFOCUS Workbench Cobol II, Expeditor, Window, Librarian, Endevor, CLISTS, MS Office, Visio.

  System:  OS/390 MVS, VM, UNIX (Solaris, Sun O/S)

  Hardware:  IBM Mainframe (360, 370, 30xx, Z9/Z10, Sun, HP

  Programming:  COBOL, PL/1, CICS, IMS, Visual basic, Java, PL/SQL, SQL

 

Railinc Corp                                                                                                                  1998-Present    

Senior DBA

  Maintain full responsibility for database administration, maintenance, and support of complex databases for MF DB2, mid-range Oracle and Teradata (data warehouse) for Railinc, which provides IT support for Railroads for North America and Canada.

  Oversee DB2 Database Administration responsibilities of complex databases as the sole DBA in the company.

  Perform multiple years of Tune-up and optimization MF DB2 databases, saving 20% of database cost per year.

  Participate in the design and development of several web-based applications, including Steel road, Parameter Trace, EMBARGO, UMLER/EMIS, as well as large database repository system including Event, Equipment cycle, ETA ,Trip plans,waybill, Rail Messaging system, Interline settlement system.

  Work directly with application developers and customer to define their needs and provide quality solution on time.

  Create logical and physical data models using ER-studio based on users and developers requirements.

  Provide 24x7 Database Administration production on-call support.

  Backup, restore and support Disaster Recovery testing.

  Identify and manage project dependencies and critical path.

  Design, establish and maintain security and protection controls.

  Determine the content, internal structure, and access strategy for RAILINC databases.

 

Page 1 of 2

 

Yyyyyy x. yyyyyy                                                                                                       Page 2 of 2

 

Career Background continued

 

 

  Perform database administration, tuning, troubleshooting, and security; identify and implement solutions for DB2 using and Oracle.

  Handle database capacity planning, architecting of databases and performance tuning (system, bufferpool, SQL s etc)  of using various tools like Omegamon, BMC Apptune, and Explain for DB2,  Toad, I3 and grid control for Oracle.

  Participate in product and vendor selection evaluations.

  Proactively stay available for non-business hours support and work when necessary.

  Recommend formal/informal policy and procedure improvements to management, to optimize performance.

  Evaluate risks on existing and new database/projects.

  Provide continued process improvement in areas of responsibility.

 

Sykes/IBM Global Services/Qualex                                                                                1997-1998       

Senior DB2 DBA consultant

  Supported the design, maintenance, and DB2 Replication DPROPR; evaluated SQL s and performance tune up, while providing production support.

  Developed QMF dynamic reporting system and written programs to generate different database reports.

  Participated in development of complex RMS system, which supported 700 labs throughout the United States.

  Developed synchronization of data on different databases.

 

Syntel/AIG Insurance Company                                                                                      1994-1997

Senior Systems Analyst/Programmer

  Developed projects, interacted with business/user group to collect requirements, and designed, analyzed and managed product development.

  Managed group of 6-8 developers, with accountability for assigning tasks, creating development plans, and implementing/supporting production system.

  Developed 800-telecom product, which collected claim information via phone and built database to process accident claims.

  Created logical and physical model for complex Litigation Management system for insurance company.

  Performed major DB2 database tune-up for Loss management system.   

 

Additional Experience (Select List)

 

Sr. Programmer/DBA - International Data Group Inc./Ashland Oil, Kentucky/Cincinnati Bell, Ohio/Detroit Edison

Sr. Programmer-Analyst - National Leather Cloth Mfg Co, India

Sr. Programmer-Analyst - Computer Engineering Services, India

Post Graduate Degree in Computer Management &Information Science - University of Bombay, India

Oracle Database 10G Administrator Certified Associate

Professional Training: Oracle Database 10G part I/II, Oracle; DB2 Administration, IBM; DB2 UDB distributed system, IBM