SUMMARY

• Nearly 20 years of Information Technology experience with last 15 years focused on database administration and design
• Hands - on experience with the major database technologies, Oracle, Sybase ASE and MS SQLServer
• Solid knowledge and hands-on skills with database DR solutions (Data Guard, Golden Gate, EMC Recoverypoint, Sybase Replication Server, SQL Server Replication, Mirroring, Clustered server and Log-shipping)
• Experience working with Oracle OEM (Grid Control), Oracle RAC, and Oracle RMAN
• Database performance and tuning experience
• Solid skills and knowledge with hands-on experience programming in Shell, Perl and Powershell scripting
• Oracle 10g Certified Professional
• Most recent certified trainings:

PROFESSIONAL EXPERIENCE

Confidential, Owings Mills MD

Lead Database Administrator

Responsibilities:

• Lead DBA in a 24x7 High Availability and heterogeneous database environment for Core Trading and Investment Systems
• Lead onsite and offsite DBA team, coordinating weekly team meetings and escalate tasks assignments
• Provide support, administration and maintenance over all Investments and Core Trading databases
• Coordinate production database upgrades and patches
• Deliver Institutional Warehouse and Data Hub database on Oracle Exadata and Grid infrastructure
• Work as data architect during the deployment of several relational and analytical data models designing CDM, LDM and PDM
• Start the process of migrating Oracle 11g and 12c Non-Container databases to CDBs on Private Database Cloud and DaaS
• Setup AWR and ADDM reports; providing weekly diagnostics report to the IDW (Institutional DW) Project Managers
• Deliver multiple databases migration from Sybase ASE to Oracle 11g Engineered System (Super Cluster)
• Perform multiple database migration from Sybase ASE to MS SQLServer 2008/2012
• Support and manage Disaster Recovery database environment for Core Trading and Investment monthly and annual DR
• Deliver backup, monitoring and alert scripts using Autosys, OEM Cloud Control scheduler, RMAN scripts, Foglight Performance Analyzer reports, BMC Patrol, and largely use of Perl and Shell scripts

Environment: Oracle 10g, Oracle 11g, Oracle 12c, Oracle Exadata X2-8 half-rack and Engineered System, Oracle 12c Data Guard, Oracle RMAN, Oracle RAC, Oracle ASM, Oracle OEM Grid/Cloud Control, Sybase ASE 15.7, ASE 15.0, ASE 12.5, SAP Sybase Replication Server 15.7, Sybase RS 15.5, MS SQL 2008 and 2012, MS SSIS, MS SSAS, MS SSRS, SAN, NAS, Unix Solaris 10/Solaris 11, Linux, Red Hat 4, Windows Server 2003/2008/2012 , BMC Patrol, Foglight, Embarcadero DBArtisan, Autosys

Confidential

Consultant Database Analyst

Responsibilities:

• Migrate very large database from Sybase ASE to Oracle 10g
• Provide database support during design, schemas, index, convert T-SQL (embedded query, stored procedures, functions and triggers) to PL-SQL
• Install and configure new Oracle 10g database instance on Oracle Grid infrastructure, setup RMAN backups, OEM admin, Grid Control, Foglight, etc.
• Automate ETL scripts using Informatica Power Center, Shell and Perl scripts

Environment: Oracle 10g, Oracle 11g, Sybase ASE 15.7, ASE 15.0, ASE 12.5, Sybase Replication Server 15.7, Sybase RS 15.5Oracle 12c, Oracle Exadata, Oracle Data Guard, Oracle RMAN, Oracle RAC, Oracle OEM, Grid/Cloud Control, SAN, NAS, Sybase

Confidential

Senior Database Administrator

Responsibilities:

• Lead DBA in a heterogeneous environment using Oracle, Sybase ASE and MS SQLServer
• Data architect during design and implementation of large Data Warehouse and Business Intelligence project implementation, building and deploying all stages of data models, CDM, LDM and PDM
• Install and configure Oracle 10g environment
• Perform large Oracle database migration from Unix Solaris to Linux platforms
• Coordinate the deployment of database Management Security Polices, create access roles, implement data auditing features, security vault, data-disclosure polices, apply security patches
• Develop and document best performance tuning practices
• Performance tuning and troubleshooting at database, Unix or storage levels during critsit events
• Deliver multiple new database instances, including several coordinated upgrades and patching

Environment: Oracle 9i, Oracle 10g, Oracle RMAN, Sybase 11.9.2, Sybase 12.0, Sybase 12.5, Sybase 15, Sybase IQ 12.x, Sybase IQ 15.x, Sybase SQL Anywhere, MS SQL Server 2000/2005/2008 , MS SQL Server 2003, Unix Solaris 9/10, Linux Red Hat, Unix/Linux shell scripts, VNC, EMC, Sybase Power Designer, CA Erwin Data Modeler, Vision, MS Project, MS SSIS, MS SSRS, MS SSAS

Confidential

Database Architect

Responsibilities:

• Integrate production databases during the acquisition process of Lloyds Bank UK by Confidential
• Migrate global databases systems into the Corporate security polices, implementing access roles and auditing mechanism
• Design, install, configure and monitor new Sybase ASE and Sybase Replication Server instances during transition
• Lead performance analysis and troubleshooting at database, OS or storage levels during calls events
• Primary Sybase IQ DBA responsible to support existing DW projects on Multiplex architecture
• Perform performance tuning on Sybase IQ SQL code and indexing implementation according to the performance requirements
• Deploy routine Sybase IQ database maintenance and backup scripts integrating with SQL Backtrack and TSM TDP
• Deliver optimization of ETL processes pulling legacy data from DB2 and loading into Sybase IQ

Environment: Sybase 11.9.2, Sybase 12.0, Sybase 12.5, Sybase 15, Sybase Replication Server 12.x, Sybase IQ 12.x, Unix IBM AIX 9/10, Linux, Unix/Linux shell scripts, Sybase Power Designer, IBM DB2 UDB 8.2, SQL Backtrack, Tivoli Storage Manager, BMC Patrol .