Database Lead

SUMMARY

• Seasoned Data Management Expert with over 20 years of experience in project management, data analysis, reporting, data modeling, performance optimization, database architecture design, administration, and development.

• Proven success across diverse industries including internet infrastructure, financial services, government, manufacturing, and insurance.

• Adept at presenting technical information, coordinating team efforts, and managing multiple projects simultaneously.

• Highly motivated, detail-oriented problem solver with quick learning skills, capable of evaluating new technologies and developing actionable recommendations.

EXPERTISE:

• Database Design & Security: Proficient in schema design, database instance management, database upgrades, and security management to meet current and future business requirements.

• AWS & Database Management: Proficient in AWS RDS, data migration, data modeling, performance optimization, backup and recovery, and troubleshooting.

• Scripting & Data Manipulation: Expertise in SQL & PL/SQL, Unix Shell scripting and XML scripting for data manipulation and maintenance.

• Reporting Tools: Skilled in developing complex reports using OBIEE, Tableau, and Crystal Reports.

• Agile & Waterfall Methodologies: Real-world experience with Agile (Scrum) and Waterfall development.

• Full Development Lifecycle: Extensive experience in leading development projects from design to implmentaion, supporting various applications in Oracle, MySQL, PostgreSQL, DB2, SQL Server, and AWS Redshift environments.

• Data Analysis & Reporting: Expert in organizing, analyzing, and interpreting large datasets to develop trend forecasts and risk reports to inform business decisions.

• Problem Solving: Capable of finding root causes of difficult problems to integration/interoperability issues, and developing efficient solutions in a timely manner.

• Technological Recommendations: Skilled in assessing new theories, concepts, principles, standards, methodologies and technologies for new and existing projects, making informed recommendations, implementing solutions, and providing advice on a wide range of IT issues.

• Solution Recommendations: Very skillful in identifying data management scenarios and potential weaknesses, providing realistic recommendations of solutions and appropriate application of best practices to clients and development teams.

• Cross-functional Collaboration: Effective collaboration with business analysts, QA, project management, development team, end users, management, and operation teams.

EDUCATION AND CERTIFICATIONS

• MBA, Information Systems Analysis and Design, UW-Madison, WI, 1997

• BS, Management Information Systems, Tsinghua University, Beijing, P. R. China, 1990

• Certified Oracle Professional DBA (7.3, 8, 8i, 9i, and 10g)

• Microsoft Certified Database Administrator (SQL Server 2000)

• Microsoft Certified Solution Developer (Visual Basic 4.0 and 6.0, and SQL Server 6.5)

TECHNICAL SKILLS:

Operating Systems: Windows XP/7/8, IBM AIX, Sun Solaris, HP-UX, Redhat Linux, AWS

Database Software: Oracle 19c/12c/11g/10g/9i/8i/8, SQL Server 6.5/2000, PostgreSQL, IBM DB2 10/11, GoldenGate, Streams, Oracle text, SPM, Oracle Grid Control/OEM, IBM DSM, AWS RDS Oracle, AWS RedShift, AWS MySql, WorkBench

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL, C++, Java, XML, ColdFusion, Python

Tools: Tableau, Databricks, AWS Glue, Jira, GitLab, Crystal Reports, SQL*PLUS, DBeaver, TOAD, SQL Developer, Informatica, PUTTY, RMAN, Eclipse, StarTeam, Imp/Exp, Data pump, Control-M, BI Publisher, Oracle Answer, SQL*LOADER, Merant Tracker, Visual SourceSafe, Smart SVN, TortoiseSVN, BladeLogic, AppWorx, Subversion, RPM, ANT, Gradle, Nagios, Make, Cygwin, Github, SourceTree, Fitnesse, Remedy, IBM Data Studio, IBM ClpPlus, Citrix, MS SharePoint, MS Teams

Data Modeling Tools: ERWin, Microsoft Visio Professional, ERStudio

Networking: SQL*Net, Net 8, TCP/IP, FTP, WinSCP, JDBC, ODBC, Telnet

PROFESSIONAL EXPERIENCE

2024-Pres. Internal Revenue Service, New Carrollton, MD

Database lead:

• Led database support for multiple tax filing related projects.

• Optimized PostgreSQL databases by redefining tables, adding missing foreign keys and indexes, and normalization.

• Identified and fixed data related issues in Tableau reports with better performance.

• Help streamline ETL scripts in Databricks to provide more accurate results to meet business needs.

• Prepared technical documents, such as data dictionaries, and collaborated with different teams for their database needs.

Environment: Windows 10, AWS PostgreSQL, AWS Databricks, SQL, Tableau, DBeaver, TortoiseSVN, Gitlab, Visio, MS SharePoint, MS Teams, Jira

2020-2024 Precise Software Solutions, Rockville, MD

Lead database engineer:

• Led drug submission data analysis and submission frequency reporting, data modeling, data access auditing, and legacy data migration for the ESGNG project.

• Recommended and implemented AWS Glue for complex data migrations from on-premise Oracle 12c databases to AWS MySQL.

• Identified data scenarios and potential issues for CERES project through in-depth analysis of data and disseminating the results of those analyses, and provided informed recommendations to clients and development teams.

• Advised the benefits of automation to improve the efficiency of data duplication, and migrations, and implemented them.

• Provided database support for critical and complex projects using AWS RDS, Oracle, Redshift, and MySQL databases.

• Managed AWS migration projects, ensuring timely completion and smooth transitions.

• Collaborated with cross-functional teams to ensure successful product releases.

Environment: Windows 10, Oracle 11g/12c/19c, Exadata, AWS RDS, AWS Redshift, AWS MySQL, Linux, SQL, PL/SQL, TOAD, SQL Developer, SQL*LOADER, Data Dump, Putty, TortoiseSVN, SVN, Citrix, Erwin, Visio, ColdFusion, MS SharePoint, MS Teams, Jira, Python, Appian

2016-2019 Thomson Reuters/Refinitiv, Rockville, MD

Senior DB Engineer:

• Provided database support for ETL and reporting projects using Informatica.

• Led Oracle DB engineering efforts for mission-critical applications in Exadata environments.

• Evaluated and implemented data movement solutions, selecting GoldenGate for optimal performance.

• Developed SQL scripts, PL/SQL packages, and Unix shell scripts to meet business requirements.

• Coordinated with different project teams to ensure smooth product releases.

Environment: Windows 7, IBM AIX, Linux, OpenStack Private Cloud, Oracle 11g/12c, Exadata, SQL Server, SQL, PL/SQL, IBM Federation Server, IBM DSM, DB2, ClpPlus, Control-M, Informatica, TOAD, SQL Developer, SQL*LOADER, GoldenGate, Explain Plan, Partitioning, Data Dump, Putty, SourceTree, Gitlab, IBM Data Studio, Remedy

2010-2016 VeriSign, Reston, VA

Senior ORACLE DBA:

• Designed and optimized high-performance Oracle databases for Java-based web applications.

• Created and maintained accurate data models using ER/Studio.

• Developed SQL scripts and PL/SQL packages for business requirements.

• Provided 24x7 production support, ensuring 100% system uptime.

• Implemented data integrity and consistency solutions using GoldenGate.

Environment: Windows XP/7, IBM AIX, Linux, Oracle 10g/11g/12c, MySQL, Grid Control, SQL, PL/SQL, OBIEE, Control-M, Java, JDBC, TOAD, SQL Developer, StarTeam, ERStudio, Streams, SQL*LOADER, GoldenGate, Explain Plan, SPM, Partitioning, Data Dump, RMAN, Eclipse, Perl, XML, Putty, WinSCP, Smart SVN, Subversion, RPM, ANT, Gradle, SourceTree, Gitgub, Stash, Fitnesse, Teamcity, Nagios, Tomcat

2005-2009. TekSystems, Rockville, MD

Senior Oracle Application DBA for FINRA:

• Played a key role in database design and maintenance for multiple projects.

• Conducted Oracle database development tasks, including performance monitoring and optimization.

• Collaborated with cross-functional teams to solve data-related issues and ensure smooth rollouts.

Environment: Windows, Unix, Oracle 9i/10g, .NET, XML, AppWorx, TOAD, OEM, Merant Tracker, Visual SourceSafe, BladeLogic, StarTeam, SQL Developer, DOORS and Erwin.

2003-2004 Pointe Technology Group, Baltimore, MD

Senior Oracle DBA for Department of Social Security:

• Led database design and management activities, improving project quality.

• Developed Unix shell and PL/SQL scripts for project automation.

• Collaborated with various teams to ensure smooth rollouts of new application releases.

2002-2003 DuPont Capital Management, Wilmington, DE

Oracle and SQL Server DBA and Programmer Analyst:

• Provided comprehensive DBA services for Oracle and SQL Server databases.

• Managed large Oracle databases in RAC environments, improving stability and performance.

• Applied technologies such as DataStage, AppWorx, PCAnywhere, and Visual Basic to enhance project performance.

Contact this candidate