SUMMARY:

• Senior Database professional with experience in learning and application of new skills in constantly changing technical environments within multiple industries and database environments.
• As a database administrator, database and data analyst providing IT solutions and problem resolutions for financial, government, manufacturing and sales industries.
• Thrives in detail - oriented, fast-paced environments, handling multiple assignments and meeting deliverable dates.
• Excellent investigative, problem solving and troubleshooting skills.

TECHNICAL SKILLS:

MS SQL Server:  Experienced with SSMS for query and manipulation of schemas, databases, and reporting. Scripting of ETL packages using SSIS. 

ORACLE:   9-11G & 12C Performance/Tuning, Oracle Upgrades, Migration of databases from Unix/Linux to Solaris using Oracle Datapump, Import/Export and SFTP. Worked directly with myOracle support (Oracle Level 3) to resolve major issues, Backup & Recovery using RMAN, Interpretation of Performance Reports, Tuning of SQL, OEM, Schedule Maintenance with Cron, Creation of Instances, Tablespaces, tables, user, roles, indexes.

DB2: ZOS/OS/MVS/V4-10DB2 UDB V8 LUW Performance/Tuning, DB2 database Upgrades/Patches, system patches and application builds, Omegamon used for monitoring Performance, Backup/Recovery using CA & BMC tools. Creation of Databases, Indexes, tables, users. Performed design, modeling and conversion of logical to physical models using Erwin and IBM tools

Development: Eclipse, CVS, SQL Developer, SQL*Plus

Languages: PL/SQL, SQL*Plus, T-SQL, Unix/Linux/Solaris, BASH and SQL

O/S:  UNIX/Linux/Solaris, ZOS

Tools:  Erwin, TOAD, RMAN, OEM, CA & BMC, Omegamon, Putty

PC Skills:   Microsoft Windows, Word, Outlook, PowerPoint, and Excel

PROFESSIONAL EXPERIENCE:

Senior Oracle Database Administrator

Confidential, Richmond, VA

• Upgraded Oracle 9i/10g/11i to 12c, migrated databases from Unix to Solaris servers
• Migration of non - ascii and non-UTF8 character set data using sftp, import/export and data pump
• Migration of dbms jobs to scheduler, crons, stored procedures and SQLoader jobs
• Monitoring of logs, backup and recovery jobs
• Worked with systems administrators to determine specific requirements for builds of new machines
• Worked with development teams to bring application tools into compliance with new environment
• Collaborated with project management, business analysts, and department management teams
• Monitoring of backup and recovery procedures 24X7 on-call
• Tuning of long running scripts and processes, problem analysis and space management resolution

Software Developer Apprentice

Confidential, Richmond, VA

• Project work exposure to Wordpress, Liferay, HTML/CSS, PHP, Java, JavaScript, jQuery, Developer Tools
• Onsite liaison for large client implementing web sites, technical support and training

Oracle Database Administrator

Confidential, Fort Lee, VA

• Supported Oracle 9i, 10g, 11i on HP UX and Solaris for international military commissary
• Managed implementations and migrations of data using putty, sftp, import/export and data pump
• Migration from Oracle 10g to 11i including shell scripting and RMAN scripts
• Ensured Oracle database systems operate efficiently and securely by monitoring jobs and logs daily
• Member of Oracle Enterprise Manager 12C implementation team included integration existing scripts
• Monitoring of backup and recovery procedures and 24X7 oncall
• Tuning of long running scripts and processes, problem analysis and space management resolution

Senior Services Technical

Confidential, Islandia, NY

• Developed on - site client relationship supporting large financial customer for East Coast Sales Division
• Client support representative for CA World 2011 in Las Vegas, Nevada
• Aided in development and testing projects for CA Database Management Solutions Tools

DB2 Database Administrator

Confidential, Richmond, VA

• Provided DBA support on multiple Agile application technical teams on credit card decision projects
• Developed and implemented SQL, DML, DDL, DB2 scripts for database migrations/changes/conversions
• Data sourcing and mappings, ETL, performance tuning, monitoring, backups, import/export
• Utilized Erwin reverse engineering to document the different objects and properties of the DBMS s
• Participated in the scrum team under agile development process utilizing test - driven-development

Oracle Database Analyst

Confidential, Richmond, VA

• Implemented application credit strategies defined by Agile project team specifications
• Retrieval and validation of data from tables using putty, sftp, SQL*Plus, HP UX, Toad and SAS
• Created, tested and loads of test applications and data for database partitions in test and qa environments
• Participated in the scrum team under agile development process utilizing test - driven-development

DB2 LUW Database Administrator

Confidential, Richmond, VA

• Lead database administrator on Agile technical team supporting 400 magistrate s in 230 offices
• Participated in the scrum team under agile development process utilizing test - driven-development
• Installed and migrated DB2 UDB LUW across all SUSE Linux environments
• Performed database upgrades, system patches and application builds
• Developed, implemented and maintained Linux BASH and DB2 SQL scripts and Stored Procedures
• Tuning of existing environments including dataset extents, DB2 threads and DSNZPARM settings

DB2 Database Administrator/Analyst

Confidential, Richmond, VA

• Researched, implemented and integrated DB2 Disaster Recovery Processes
• Implemented CA Platinum Tool s, DB2 security and migration practices and procedures
• Performed design, modeling and conversion of logical to physical models using Erwin and IBM tools

DB2 Database Administrator/Analyst

Confidential, Richmond, VA

• Primary DBA supporting highly visible HR and Payroll application Tesseract
• Trained Application DBA's to use in - house and vendor utilities to support development environments
• Supported software releases, application systems releases, and disaster recovery testing
• Utilized Erwin reverse engineering to document the different objects and properties of the DBMS s
• Performance tuning, problem analysis and resolution
• Back-up and recovery for DB2 daily and 24X7 on-call