OBJECTIVE:

• I am an experienced senior SQL DBA consultant seeking for a job assignment anywhere in US. I am US citizen and willing to relocate & travel on my own to the job site.
• I am available immediately for interviews and job acceptance.

SUMMARY:

• 20+ years of technical experience in IT with concentration in Database Management & Administration.
• 15+ years of hands - on experience with SQL Server Administration and Development
• 7+ years of experience of SQL database migration in data center and public cloud environments: AWS and Azure.
• 10+ years in IT technical lead and architect positions.

CORE EXPERTISE AND EXPERIENCE:

• SQL Server Administration
• Design, architect, install, configure, administer, and support all SQL Server versions: 6.5, 7.0, 2000, 2005, 2008, 2012, 2014, and 2016.
• Extensive experience in high availability (Always-On, Clustering, Mirroring), disaster recovery, replication, performance. optimization, query tuning, In-Memory OLTP, backup and recovery.
• Support all SSIS, SSRS, and SSAS related components and features in both production and development environments.
• Experience in database migration from data center to Azure and AWS.
• Develop T-SQL store procedures, triggers and scripts for applications.
• Install, administer and maintain high availability of SQL Server and ETL platforms.
• Deploy and schedule ETL production releases from development and QA environments
• Support production processes and troubleshoot ETL job performance issues
• Implement version upgrades, patches, and service packs for SSIS and ETL environments.
• Design and develop mappings for EDW (Enterprise Data Warehouse) and Confidential (Operational Data Store)

TECHNICAL SKILLS:

• Informatica
• SAP BODI ETL
• Oracle PL/SQL
• SQL SSIS, SSAS, and SSRS
• Control-M Scheduler
• Toad / Erwin

PROFESSIONAL EXPERIENCE:

Confidential

SQL Database Administrator/ Developer

Responsibilities:

• Support several key projects with SQL Server 2014 implementation. Implemented hardware infrastructure requirements, and deployed data integration jobs for application production go-live.
• Design and implement HA and DR for business-critical systems.
• Create and support application and database development environments in Azure.
• Develop and write TSQL store procedures and SSIS packages for BI reports.
• Setup nightly ETL jobs, develop and support SSRS reporting environments.
• Responsible for database performance analysis with query tuning for both production and development. Work closely with application development team and resolve application blocking and deadlocking issues.
• Provide database design consultation to application and infrastructure IT management team and create planning roadmap.
• Conduct and perform quarterly database security audits.

Confidential, Irvine, California

SQL Database Administrator - Technical Lead

Responsibilities:

• Provided Informatica and SAP BODI ETL support for the company’s main data warehouse system with 2000+ reporting users
• Provided Level 3 support for all company’s high critical incidents where business revenues are impacted.
• Consolidated over 100+ SQL database servers and saved over 1.5M in licensing true-up cost avoidance over 4 years.
• Successfully migrated and centralized over 200 database servers from multiple global locations to Chicago and Singapore Data Centers.
• Successfully implemented global database security infrastructure to conform to SOX (Sarbanes-Oxley) audit requirements for 6 years.
• Designed and implemented multiple-node clustered SQL servers for high-availability enterprise database solutions using high performance EMC DMX SAN with Cisco UCS servers, improving system overall uptime and resource usage efficiency.
• Created and implemented global best practices and database administration standards for SQL DBA group, minimizing inconsistencies in server configurations and database setup.

Confidential, Orange, California

Sr. SQL Database Administrator / Informatica ETL

Responsibilities:

• Led a team of SQL DBAs and ETL developers supporting the SQL Server database and reporting environment in Confidential Residential Lending. Effectively utilized strong leadership and decision making skills in managing and providing technical resources in a dynamic and volatile business environment.
• Worked collaboratively with all IT managers and directors in providing support for all development projects as well as daily critical business operations. Other responsibilities also include: vendor interaction, software license maintenance, and budget management.
• Successfully downsized and centralized several hundred databases into a single high availability centralized multiple-node clustered environments. Also successfully upgraded several hundred production and development databases from SQL 2000 to SQL 2005 with minimal glitches to application functionality.
• Responsible for company data security, specifically in SOX (Sarbanes-Oxley) audit requirements, resolving all audit issues in the areas of database administration, system downstream integration, and enterprise reporting.
• Architected and implemented several large-scale data integration processes between Confidential Residential and external vendors, resulting in seamless data process between internal applications with external systems.
• Successfully migrated Loan Servicing nightly processes from MSP to internal in-house systems which mostly written in SQL DTS and legacy transact-SQL store procedures to Informatica ETL processes, significantly reducing the nightly support calls to DBAs.
• Successfully completed several medium to large scale integration projects merging data from Confidential Residential (former Confidential Capital Holding) to Confidential Mortgage (new acquirer), improving the data exchange between the two business entities.
• Enhanced and re-architected the company’s enterprise Confidential to support and accommodate new reporting requirements from Confidential Mortgage, expanding the visibility to the parent company data for business executives.

Confidential, Orange, California

SQL DBA/ETL Team Lead

Responsibilities:

• Managed the company’s enterprise Confidential (Operational Data Store) environment, a central reporting repository for all operational, analytical, and ad-hoc reports for all subsidiary lines of business.
• Managed the ETL Informatica group which consists of on-site production support and offshore (India) development teams from 8/2004 to 9/2007.
• Managed the SQL Server DBA group supporting over 500 production databases/ 60 clustered servers from 05/2007 to 9/2007.
• Responsible for data integrations between systems within the company and external vendors using Informatica Powercenter as the main ETL integration tool.
• Architected and supported the company’s Enterprise Data Warehouse. The size of archive data is averaging 3Tbs per month.

Confidential, Orange, California

SQL Database Administrator

Responsibilities:

• Supported all company DB infrastructural components for SQL Server 6.5/7.0/2000 platforms which include installations, version upgrades, service packs, security patches, backups, and DR & business continuity. Worked with SQL Server databases as large as 500GB.
• Implemented and supported over 40 SQL replications and Clusters (active-active and active-passive) for all critical databases in the company.
• Reviewed, approved, and implemented production modifications to database objects and data.
• Developed and supported DTS packages and trans-act sql store-procedures for ETL integration between application databases.
• Handled any critical database conditions, database locking, low disk space, and performance issues.
• Enforced enterprise policies and standards to secure access and data in SQL Sever databases in accordance with company IT policies, procedures, and database standards.
• Supported Peoplesoft HR application and database configurations.
• Designed and implemented the company’s Confidential (operation data store) and CIF( Corporate Information Factory) databases in SQL 7.0/2000 in over 300GB of data size.

Confidential, Cypress, California

SQL Database - System Engineer

Responsibilities:

• Maintained and supported servers and desktops for Loan Servicing Systems.
• Installed Microsoft Windows/ Novell servers and administered the user, system level accounts for Loan Servicing division.
• Administered the production database security within company’s policies and guidelines.
• Managed user, system, application, and database level security of roles, privileges, accounts for SQL Server 7 & 2000