We provide IT Staff Augmentation Services!

Senior Dba Resume

4.00/5 (Submit Your Rating)

Tampa, FL

SUMMARY

  • me am an information technology professional wif over 23 years of experience and therefore highly skilled.
  • me am a confident leader and dedicated professional wif formal education in Management Information Systems as well as numerous professional courses in specific database technology and programming.
  • me has extensive experience in relational databases, having supported them as a DBA as well as a programmer throughout my 23+ years in IT. In addition, me has excellent communication skills and am highly TEMPeffective working in a team environment.

TECHNICAL SKILLS

  • SQLServer (2000, 2005, 2008 & 2012)
  • DB2 for z/OS (Version 5 through Version 10)
  • Oracle (8i, 9i, 10g and 11g)
  • SSIS Packages
  • Data modeling and physical database design
  • IBM DB2 ADMIN Tools
  • SQL, QMF, SPUFI
  • COBOL
  • OMEGAMON
  • CA Insight
  • IBM DB2 Utilities
  • IBM Data Studio
  • Enterprise Manager
  • DB2 Connect
  • ORACLE SQLDeveloper
  • JCL
  • TSO/ISPF
  • VSAM
  • REXX
  • Prism Warehouse Executive(ETL Tool)
  • EZtrieve
  • HTML
  • UNIX
  • ENDEVOR
  • Infoman/CPMA
  • Microsoft Office
  • CSP
  • OPCA
  • File - Aid and File-Aid for DB2
  • InSync
  • Embarcadero DBArtisan
  • Embarcadero ERStudio

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Senior DBA

Responsibilities:

  • Sole DBA for SQL Server
  • Security Vulnerability Assessment, Review and Remediation
  • Creation and maintenance of physical database objects
  • Creation, modification and administration of SSIS Packages
  • Responsible for backup and recovery for both offsite disaster recovery as well as application error recovery
  • Performance analysis
  • Query, application and database tuning
  • Database operational status monitoring
  • Standards development and maintenance
  • Database change coordination and management
  • Support and testing for database upgrades
  • Assist developers wif application design, including complex queries containing nested table expressions, correlated subqueries, left and full outer joins
  • Training applications developers and end users in RDBMS usage
  • End user support
  • 24 hour on call support for production systems

Confidential, Columbia, SC

Information Systems Consultant

Responsibilities:

  • Primary support for SQL Server 2000, 2005 and 2008
  • Support of over 600 separate database instances
  • Strong emphasis on security and database hardening
  • Security Vulnerability Assessment, Review and Remediation
  • Creation and maintenance of physical database objects
  • Responsible for backup and recovery for both offsite disaster recovery as well as application error recovery
  • Performance analysis, query, application and database tuning
  • Database operational status monitoring
  • Standards development and maintenance
  • Database change coordination and management
  • Support and testing for database upgrades
  • Assist developers wif application design, including complex queries containing nested table expressions, correlated subqueries, left and full outer joins
  • Training applications developers and end users in RDBMS usage
  • End user support
  • 24 hour on call support for production systems
  • Backup support for Oracle & DB2 LUW

Confidential, Tampa, FL

DB2, SQLServer and Oracle DBA

Responsibilities:

  • Supported three major database platforms - DB2 for z/OS through v10, SQL Server 2000, 2005, 2008 and 2012, and Oracle 8i, 9i 10g and 11g
  • Logical data modeling using both relational models for transaction based systems and dimensional (star schema) models for reporting systems. Developed models to be used wif vendor reporting tools (COGNOS and e.Piphany)
  • Physical database design including partitioning and indexing for performance.
  • Creation and maintenance of physical database objects
  • Responsible for backup and recovery for both offsite disaster recovery as well as application error recovery
  • Database security: In addition to standard access grants also set up auditing on SQLServer databases
  • Supported teh IT Security Team for teh database portion of PCI and SOX compliance audits
  • Query, application and database tuning
  • Support and testing for database upgrades
  • Assist developers wif application design, including complex queries containing nested table expressions, MQTs, global temp tables, correlated subqueries, left and full outer joins
  • Training applications developers and end users in RDBMS usage
  • End user support
  • 24 hour on call support for production systems

We'd love your feedback!