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 2005: Experienced with SSMS for query and manipulation of schemas, databases, and reporting. Scripting of ETL packages using SSIS. Currently refreshing skills with MCSA .

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:

Confidential, Richmond, VA

Senior Oracle Database Administrator

Responsibilities:

• 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

Responsibilities:

• 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

Oracle Database Administrator

Confidential, Fort Lee, VA

Responsibilities:

• 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

Responsibilities:

• Developed on - site client relationship supporting large financial customer for East Coast Sales Division
• Aided in development and testing projects for CA Database Management Solutions Tools

DB2 Database Administrator

Confidential, Richmond, VA

Responsibilities:

• 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

Database Analyst

Confidential, Richmond, VA

Responsibilities:

• Developed data extracts, structures and reports for data import/export processes
• Assisted team in change control management, monitoring, troubleshooting and data loading production
• POC for Test Coordination Center reporting activities, communicated to the customer base, handled ad - hoc requests, fielded questions and other customer-interfacing tasks

Oracle Database Analyst

Confidential, Richmond, VA

Responsibilities:

• Ensured accurate monthly reporting through monitoring and testing of data import/export processes from Oracle/Access databases using PL/SQL, SQL*Developer, TOAD and SAS for actuarial analyst s current forecasts
• Supported division pricing, forecasting, closing, data requests and system enhancements
• Maintained data interfaces between the Decision Support System and custom systems working closely with actuarial analysts to ensure accuracy for product pricing and client management

Database Support Analyst

Confidential, Richmond, VA

Responsibilities:

• Member of 24X7 support project team converting critical operating system to outside vendor platform
• Lead meetings between Business, Support and Outside vendor for problem analysis and resolution
• Followed up on problem tickets with technical issues across all areas to drive problem resolution
• Utilized Erwin reverse engineering to document the different objects and properties of the DBMS s

Oracle Database Analyst

Confidential, Richmond, VA

Responsibilities:

• 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

Responsibilities:

• 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

MS SQL Programmer Analyst

Confidential, Richmond, VA

Responsibilities:

• Data analysis, development, and reporting of data related to SPEM, Systematic Program Evaluation and Measurement, project to measure various outcome measures for specific diseases reporting to CDC
• Wrote SQL/T - SQL programs to summarize medical claims, provider data and utilization
• Created DTS packages and loaded tables to transfer results of clinical studies reporting to tables for BI tools
• Implemented solutions for system problems including SQL changes, scrubbing of data, and table redesign

DB2 Database Administrator/Analyst

Confidential, Richmond, VA

Responsibilities:

• Implemented, maintained and migrated data and databases for partitioned environments
• Performed database tuning, monitoring, maintained database security, and disk space monitoring
• Problem analysis, resolution and support for Child Support databases and Disaster Recovery 24X7

DB2 Database Administrator/Analyst

Confidential, Richmond, VA

Responsibilities:

• Wrote and maintained UNIX scripts for MQ Series for transfer of data between Oracle/DB2 applications
• Database tuning and monitoring, maintained database security, performed disk space monitoring
• Created scripts for backup process and participated in DB2 Disaster Recovery testing

DB2 Database Administrator/Analyst

Confidential, Richmond, VA

Responsibilities:

• 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