SUMMARY

• ProfileHighly motivated, disciplined individual with exemplary interpersonal quantitative and analytical skills. Ability to adapt and respond to a dynamic, changing environment.

TECHNICAL SKILLS

Skills: Microsoft SQL Server 2017/2016/ 2014/2012/2008 /2005/2000 , Microsoft Azure, Sybase 12.5/11.9, ORACLE 8i/9i, Oracle Designer, Oracle Developer, Forms 4.5, Reports 2.5, C, FORTRAN, COBOL, RDBMS.

Operating System: - Unix (Solaris 2.8/2.7), Windows NT 2014/2012/2008 R 2/2008/2005/2000 , Microsoft Cluster Services, High Availability (HA) and Disaster Recovery (DR) options for SQL Server, EZ Cap System.

Advanced Transact: SQL and PL/SQL, Data Warehousing, Replication

Tools: PeopleSoft 8., PeopleTools, SSRS, SSIS, DTS, Epiphany, Business Objects, ERWIN, Crystal Reports, Clear Quest, Redgate, Change Manager, Delphix, LiteSpeed, DBArtisan, SolarWinds DPA, SQL Loader, Attunity Replicate, Visio

PROFESSIONAL EXPERIENCE

Confidential, Long Beach, CA

Sr. Engineer / Sr. Database Administrator

Responsibilities:

• Installation and upgrade of corporate managed databases and health plans database servers following established standards.
• Provided database administration support to assigned projects and led database-related technical tasks.
• Designed, implemented and maintained multi-site high availability database clusters for multiple database management systems.
• Problem management through troubleshooting and root cause analysis on database and underlying server related issues.
• Provided coaching and guidance to application developers, ETL developers and data analysts regarding database methodologies, best practices on performance tuning, query optimization, index tuning, caching, buffer tuning, etc.
• Provided technical leadership in planning and implemented strategic technology initiatives including but not limited to upgrading, patching, security, consolidation.
• Provided leadership in the direction, engineering and support for enterprise data management solutions.

Confidential, Long Beach, CA

Sr. Database Administrator

Responsibilities:

• Monitored and take correction action on database performance issues, database capacity issues, replication, and other distributed data issues.
• Managed new and maintained existing databases based on specifications.
• Database administration and server documentation procedures, standards and Backups.
• Provided database configuration synch on various environments.
• Managed security of database structures and corporately-data held within databases.

Confidential

Sr. Database Administrator

Responsibilities:

• Led and contributed to the management of projects requiring coordination with other functions and disciplines.
• Provided guidance and recommendation to the project’s technical teams on potential solutions to complex applications structural issues.
• Organized and managed database tools selection process.
• Defined and implemented database standards for all Confidential database performance activities from planning, scripting, execution to reporting.
• Defined and implemented a continuous tuning and optimization Performance Modeling test approach to capture performance related issue earlier on in a project life cycle and eliminate the huge cost associated with rework.
• Developed Database Policies and Procedures and instituted Database Plan design & development procedures now in use by the Database team at Confidential .
• Led the database team on testing of all Hot Fixes, Quarterly Releases and first-time core development project.
• Led and acted as a liaison between database team and development team to resolve application issues and plan code release cycles.
• Engaged DBA’s in all projects from the requirement phase to ensure all phases’ entry and exit criteria are met and ensure database testability and clarity of the Business requirements.
• Developed change-management procedures for automated script based on changes to the underlining Application under Test (AUT).
• Provided support to Quality Assurance for their testing and to users for User Acceptance Testing (UAT).
• Performed database installation and configuration, scheduled and performed upgrades, backup and recovery. Monitored database and replication servers for resource utilization.
• Managed the appropriate access authorities for database users, provided database tuning, server installation and configuration, logical database design, physical database design, database security and privileges, database logging, backup and recovery, data transfer utilities, monitored databases, tuned configuration parameters, implemented constraint enforcement techniques, reorganized table data, indexes, primary keys and triggers.

SQL Server / Sybase Database Administrator

Responsibilities:

• Implemented Epiphany Data Warehouse (1 TERABYTE). This involved designing appropriate Star Schema, extracting data from Sybase, Transforming, Cleansing, De-duping and finally loading into an Oracle Database. Also conducted benchmarks, gathered and monitored database statistics in order to optimize performance.
• Extensive Transact SQL coding, writing stored procedures, triggers and functions for customizations and reports.
• Implemented Microsoft Cluster Services for SQL Server 2000 on Windows 2000.
• Led team to migrate databases from Sybase 11.9 and 12.5 to Microsoft SQL Server 2005. This involved managing the project, capacity planning, making recommendations for Hardware and software installation.
• Migrated data across heterogeneous ODBC data sources using Microsoft Data Transformation Services (DTS).
• Others - Supported over 70 Production SQL Servers, Standardized Backup and Recovery plans, tuned high availability 24/7 databases, and rebuilt fragmented tables and indexes.

Oracle Database Administrator

Responsibilities:

• Member of the team responsible for upgrading PeopleSoft 7.52 to 8. This was a 3-tier upgrade of the Operating System from Solaris 2.6 to 2.8, the database from Oracle 8.0.5 to 8.1.7 and then PeopleSoft. This involved Oracle installation, creating, administering and migrating multiple Oracle instances, Performance tuning (STATSPACK), Backup and Recovery (RMAN).
• Optimized queries from PeopleSoft using Advanced SQL Tuning techniques. This reduced run time of many queries significantly.
• Exported and Imported data between Production and Development.
• Day to day administration (schema, storage etc.) and support for PeopleSoft Technical team.