SUMMARY

• Seek a senior team leadership position in the database design, development and operations management of very large complex database and data warehouse system using various latest technologies including Oracle, SQL Server, and SDLC/Agile methodologies.
• Confidential TEMPhas over nineteen years of database management experience in the areas of very large information system infrastructure and database design/development/implementation/operational management. Confidential . Confidential TEMPhas broad experiences leading and managing large database infrastructure related IT activities and projects.
• Confidential currently works as Senior Lead DBA in Promontory Interfinancial Network. She led the project planning and implementation of 12C upgrade for the whole organization. Prior to it, she worked as Senior Database Architect in Colege Board leading the new SAT/PSAT database re - design and Oracle RAC and data guard infrastructure implementations and operational database support. Prior to it, she worked as Technical Supervisor of Database team supporting GEICO very large (500TB) high availability high volume internet business back-end database systems. She led the team and successfully upgraded 350 Oracle databases from 10G to 11G. Prior to that, Confidential . Confidential worked as Technical Lead of database engineer team to provide Freddie Mac database engineering solutions and operational database enhancement and management. She also led multiple data center build, enterprise disaster recovering strategic design and practice using Oracle RAC, SQL Server Always-On, Cloud Computing, and VMware.
• Prior to dis position, Confidential . Confidential worked as Lead Information System Engineer at Confidential Corporations. She led the team, designed, developed and delivered the new IRS Excise Tax database system and provided database engineering solutions. Prior to joining Confidential, Confidential . Alice Confidential worked on the Smart Border Alliance Program under the Homeland Security Division as a Senior Lead Database Architect. She led the re-architecture, Oracle database software and hardware upgrade for the world largest image database (50TB).
• Confidential got many years experience of working with cross functional teams to provide IT operational management for hundreds of mission critical very large database systems; improved system reliability, scalability, high availability and performance; established the IT standard and policies and procedures for the enterprise level database operation, data center, and disaster recovery solutions.
• Highly motivated, responsible, attention to detail; Commitment to quality work; Customer focused; Strong analytical skills; Strong communication skills.
• Extensive experience in the design, development and operational management and support of very large database and data warehouse using the latest technologies and methodologies including Oracle RAC, Cloud computing, Oracle 11G/12C, Data Guard, ASM, Microsoft SQL Server, MongoDB and Big Data.
• Experienced in database and data warehouse database installation, configuration, instance and RAC cluster creation, performance tuning and improvement, troubleshooting, database software version upgrade and patching, database automation, database system integration, data migration, database backup and recovery, data requirement collection, data flow diagram, ETL development, data architecture design, data modeling, and data security process control and compliance. Extended experience in implementing high available and high-volume large production database with strong problem solving capabilities.
• Strong Leadership. Good at team leadership and large and long-range project management. Tracking record on delivery large projects on time. Strong on project planning, scheduling, communication among cross teams, resource planning and management, work assignment and adjustment, project risk management and mitigation planning, priority adjustment and settings, progress tracking.

PROFESSIONAL EXPERIENCE

Confidential, VA

Senior Lead DBA

Responsibilities:

• Provided the technical expert expertise and leadership in the operational database support and management of large financial database system. Responsible for installation and configurations, database creation, operational support and 24x7 oncall, database troubleshooting, performance tuning and system optimization, database backup and restore, disaster recovering solutions and procedures, multi-site failover clustering management, database patching and database version upgrade etc.
• Led the data management technology transformation to improve database scalability, reliability and high avaibility. Led the implementation of database encryption including transparent data encryption, data redaction, data mask. Managed multiple database platforms including Oracle, SQL Server. Collected the data requirement, designed logical and physical data models, defined data flow diagram.
• Supported IT Continuity operations planning and built procedures. Established and ensured database management standard, procedures and guidelines. Designed database security standard and system audit procedures.
• Led the database version upgrade project from 11G to 12C. Provided project planning, resource planning, technical procedures and solutions, priority adjustment, work assignment, in-place and out-of-place upgrade strategies for different environments, risk measure and mitigation, back-out plan, schedule planning and tracking, progress tracking and priorities setting and adjustment.

Confidential, VA

Database Architect, IT Data Services and Infrastructure

Responsibilities:

• Provided database development, implementation, monitoring, and operational management expertise. Led the database infrastructure enhancement and expansion, operational database incident management, database centric project management, using the latest technologies including Oracle 10G/11G/12C RDBMS, RAC, Microsoft SQL Server, Data Guard, SQL Server, MySQL, Big Data, Azure, Always-On, VMWare, Grid Control to ensure high performance, high scalability and business continuity etc.
• Provided the database architecture design, database technology transformation, and database security compliance for the Colege Board SAT/PSAT Assessment databases. Led the effort of database operational maintenance including version upgrade, patching, performance monitoring and tuning, code releases, backup and recovery, database integration and migration, database automation with Shell scripting and SQL scripting, database installation, configuration, high availability implementation and enhancement etc.
• Led the data warehouse build. Managed the Oracle RAC and Data Guard implementation project. Responsible for project and resource planning and scheduling and tracking.
• Provided the technical solution for database version upgrade to meet high availability and minimum down-time requirement. Led the team successfully planned, communicated, implemented the upgrade for Oracle databases. Provided 24x7 operational support. Led the database incident management. Managed and coordinated the monthly large application development releases.
• Worked with cross team on large infrastructure development and improvement projects and IT process improvement. Worked with Oracle vendors to identify and fix Oracle and SQL Server bugs. Kept the database software updated and secured through patching and upgrade.
• Managed and provided database standard, policies and guidelines. Provided database disaster recovery solution and procedures, technologies recommendations, vendor management, etc.

Confidential, MD

Technical Manager, Data Services and Operations

Responsibilities:

• Led a team of Database engineers and DBAs to support GEICO’s mission critical internet application back-end databases for insurance and customer service businesses. Communicated with business partners to confer requirements. Designed and built high availability, high volume (500TB) and very large complex databases systems. We utilized latest technologies including Oracle RDBMS/RAC, SQL Server, Data Guard, Big Data, MySQL, VMWare, Azure, and Always-On to ensure high availability, high performance, high scalability and business continuity.
• Provided operation DBA support to PeopleSoft software 8.5 and above. Managed and provided PeopleSoft database upgrade and data management tools. Responsible for PeopleSoft application and tool upgrade, troubleshooting and resolving complex problems and issues, technical support application team, maintaining and improving PeopleSoft technical architecture, technical maintaining and supporting large scale PeopleSoft HCM Applications.
• Provided the technical solution for 10G to 11GR2 database upgrade to meet high availability and minimum down-time requirement. Led the team successfully planned, communicated, implemented the upgrade from 10G to 11G for 350 databases. dis project was delayed for three years due to the high demanding internet business minimum downtime requirement and challenges. Provided the best risk mitigation plan. Got customer buy into the upgrade strategies with minimum down time and lowest risk. Led the team optimized the database system and identified the performance issues and fixed the top SQL performance issues.
• Provided 24x7 database support, and coordinated the monthly large application development releases. Installed, configured, optimized and managed new Oracle and SQL Server Databases including RAC cluster, Data Guard, Always-On, RDBMS.
• Managed and coordinated with cross team on the large infrastructure development and improvement and IT process improvement activities and projects. Worked with Oracle vendors to identify and fix Oracle and SQL Server bugs. Kept the database software secured through patching and version upgrade.
• Managed the provisioning, operation, and maintenance of database system, software, storage and hardware platforms. Defined data standards and designed data architecture. Ensured the data security.
• Led the development of the enterprise content management and data asset management systems using SDLC. Analyzed designed, developed, deployed and sustained business process flow, portals and business intelligence dashboard.
• Provided technical directions and evaluated and chose technologies. Responsible for database architecture design.
• Led the team and provided 99.99% uptime service level agreement. Built data guard databases in the other data centers for critical databases. Led and successfully implemented the disaster recovery practice companywide for production information system.
• Provided directions and led built the database management standard, policies and procedures, database security policies, data management policies, etc. Built the database backup and recovery strategy and standard procedures. Enforced the implementation of the daily incremental backup and weekly full backup to all production environment. Led the ETL development to extract, transform, load data. Researched and provided Big Data strategy and architecture design. Identified data sources for Big Data Hadoop analytical system.
• Developed and trained the team members. Provided year end review. Status tracking and prioritize projects. Provided directions and guidance. Provided project and resource planning/management, tasks assignment and adjustment, priorities setting and adjustment, technical guideline, database architecture and engineering solutions.
• Designed/implemented the database security policies and controls and database server storage/memory/CPU/hardware capacity planning. Led the database migration and data integration projects.
• Responsible for the research, recommendation and procurement of database system hardware and software.

Confidential VA

Tech Lead, Database EngineerLed Database Engineers

Responsibilities:

• Provided strategy and Disaster Recovery architecture design for the new data center build and multiple data center moves. Implemented the solution with the latest technologies including cloud computing, VMWare, Microsoft SQL Server, Oracle Data Guard, Oracle RAC, Grid Infrastructure, Grid Control. Created, tested and certified the technical steps for Oracle 10GR2 RAC and stand-alone upgrade to 11GR2 and SQL Server upgrade.
• Provided 24x7 database operational support and management. Supported large application and database development releases. Enforced the database security compliances including data encryption and data masking.
• Built the standard database engineering solution diagram and specifications. Presented complex technical solutions/finding and recommendations to upper management. Provided database architecture solution and developed and delivered 15TB mission critical financial database system integration (DSI) using Oracle 11G etc. Built the database solution decision work flow to provide database engineering solution with Oracle, DB2, Microsoft SQL Server database platforms.

Confidential, VA

Lead Information System Engineer

Responsibilities:

• Led the team and designed the new database architecture design and built the database servers. We created and configured and tuned database systems. Implemented Oracle 10G Data Guard, ASM (Automatic Storage Management), RAC architecture, SQL Server RDBMS; developed and implemented the new database backup and restore strategies and solutions; installed the centralized 10G OEM Grid Control to monitor databases.
• Performed the following database management tasks -- performance tuning; installing and upgrading oracle software; database configurations; resolved the problem areas; implemented database access and security control; database migrations; built processes and practiced contingency of operations test scenarios for operational data center failover and disaster recovery practice.
• Tested, certified and established standard procedures for Oracle RAC, ASM and Data Guard implementation at IRS. Managed large IT cross teams activities and projects. Provided project plan, resource plan, schedules, progress tracking, tasks assignment and adjustment, risk management, etc. Coached and developed team members. Helped formulating IRS Enterprise Data Warehouse Architecture strategies, including building OLAP reporting architecture, and defining ETL methodology.

Confidential, VA

Senior Lead Database Architect

Responsibilities:

• Led a team of Oracle DBAs to redesign and re-engineer the critical 50TB database system of the 10 billion dollars Department Homeland Security US-VISIT Smart Border Alliance program. dis DHS critical database is growing at a 3TB per month rate. In order to transform immigration and border management through enhancing the security of United States citizens and visitors while facilitating legitimate travel and trade. We redesigned the largest critical Biometric Oracle database systems in the world which is used at all land, air, and sea Ports of Entry of US. me led the team and improved the performance, provided high availability solutions, storage architecture redesign, and data access and security control; bottleneck production issues troubleshooting; developed integrated, high efficient and secured database system evolving with Department of Homeland Security Enterprise Architecture.
• Designed the optimal strategies for production VLDB to be upgraded from 9i Oracle RDBMS to 10g RAC and 10g Data Guard with the minimal outrage. Led through the successful implementation.
• Led the development and execution of database system re-modernization strategy - optimized and redesigned the IDENT data modeling. Designed the multiple data centers data replication and synchronization using Oracle RAC, Oracle Data Guard.
• Delivered the data architecture design. Designed and implemented the new three layers database storage architecture. Improved database performance. Responsible for the database system capacity planning. Installed and configured Oracle software including RAC and Data Guard and created databases. Established and enforced the new database operation policies, standards, guidelines, procedures and strategies for IDENT database operational management and database backup, restore and recovery, and disaster recovery.

Confidential, Washington, DC

Senior Lead DBA

Responsibilities:

• Led the design, implementation and support of Confidential class 1 critical financial databases in Multifamily, Single family, HCD CORE, Credit, Risk Credit, Asset Servicing, Data Warehouse and Customer Solutions clusters. Accomplished the following projects:
• Built, maintained and monitored hundreds of highly complex mission critical class 1 financial Oracle databases. Established and implemented the Oracle databases backup, restore, recovery strategic standards and procedures.
• Identified the new technologies that could be used to increase Confidential database reliability, high availability and database performance. Built the standard procedures of the Oracle Data Guard primary/secondary site switchover.
• Led the team successfully built and practiced Confidential yearly contingency of operations test scenarios for all Confidential critical financial Oracle production databases failover and disaster recovery practice using RAC, Data Guard etc.
• Built, tested and certified the standard procedure for the Oracle software installation, configuration, and database creation. Led the team to conduct performance tuning. Led the database software upgrade and security patching for over 500 Oracle databases.

TECHNICAL EXPERIENC

Databases: Oracle 11GR2/12C (RDBMS, EXADATA, Grid Control, Active Data Guard, RAC, Gloden Gate, Partitioning, RMAN, ASM, SQL Profile, AWR, ADDM), Microsoft SQL Server 2016/2014/2008(SQL Studio), MongoDB

Programming: UNIX Shell scripting, PERL, Stored Procedures, Triggers, PL/SQL, AutoSys

Operating: Linux, VMWare, UNIX, Windows

Systems: ToolsAWS, Hadoop, Big Data, ER Studio, ERWin, ER Studio, TOAD, Oracle SQL Developer, DBArtisan, Weblogic, VERITAS, Netbackup, Confidential Office Tools,