SUMMARY

• 15+ years of experience with various database management systems: Oracle, MS SQL, Sybase, Teradata, PostgreSQL, etc.
• Tested and proven database specialist, working in heterogeneous database environments with complex business - critical applications
• Expertise areas include database administration and development for high availability services in various industries: travel, healthcare, insurance, financial, telecommunications, government agencies and others
• Highly skilled in database support, monitoring, backup and recovery, tuning and performance improvement, database analysis, system design, data modeling, conversion, data extraction, transformation and loading
• Very strong in database application development and shell scripting
• Demonstrated analytical mentality, excellent problem solving and troubleshooting skills, adaptability and willingness to learn

TECHNICAL SKILLS

Databases: Oracle, MS SQL, Sybase, Teradata, PostgreSQL, MySQL, DB2, Vertica

Technologies: RAC, ASM, Exadata, Data Guard, Replication/GoldenGate, AWS, RDS, Agile

Tools: RMAN, OEM, SQL Developer, Toad, Erwin, Informatica, Pentaho, TFS, JIRA, Jenkins

Languages: SQL, PL/SQL, T-SQL, shells, COBOL, C, HTML, CSS, JavaScript

Operating Systems: Linux; UNIX; Mac OS X; Windows

PROFESSIONAL EXPERIENCE

Confidential, Quincy, MA

Sr. Database Engineer

Responsibilities:

• Works on a global team with offshore development engineers participating in full software development lifecycle within Agile/Scrum environment
• Responds to technical requests and directions from VPs, providing technical database design recommendations to management
• Works with product managers and business analysts in translating business requirements into high level functional design specification
• Conducts project design and application code reviews, makes best design and implementation decisions to ensure quality and efficiency
• Performs customized SQL and PL/SQL development tasks, query performance tuning, including execution plan improvement, running AWR reports, SQL monitoring, analyzing tables, gathering statistics, using indexing techniques, etc

Confidential, Westborough, MA

Sr. Database Engineer

Responsibilities:

• Performed database administration and maintenance tasks including but not limited to capacity planning, backup/recovery, export/import, database connectivity, database refresh, data cleansing, de-duplication, etc.
• Communicated and managed change in requirements over the project life cycle translating nontechnical business requirements into technical action plans
• Conducted performance improvement and tuning of SQL queries and PL/SQL program units
• Modified ETL routines to efficiently load and extract the data warehouse data

Confidential, Westborough, MA

Sr. Database Engineer

Responsibilities:

• Database design and system enhancement for the international pharmaceutical company
• Analyzed the existing Process Data Warehouse (PDW) Oracle database, identifies and manages areas of risk related to requirements and design
• Generated technical specifications that describe the proposed modifications to the system to meet the requirements
• Worked closely with Genzyme cross-functional business Subject Matter Experts and other technical resources to ensure the proposed design is well communicated
• Performed Oracle database enhancement tasks including but not limited to database tuningcapacity planning, creating partitioned tables, customized views, materialized views and database links, writing complex SQL queries, stored PL/SQL program units, SQL*Plus scriptsETL routines to efficiently extract data from the data warehouse environment, etc.
• Conducted performance improvement and tuning of the developed solution to ensure that requirements are met
• Communicated and managed change in requirements over the project life cycle; partnered with the project manager to assess the impact on the project scope
• Generated test data and test scenarios, executed the test scripts, recorded the deviations and drove their resolution and closures
• Contributed to the creation or update of the business and IS related standard operating procedures (SOPs), standard work instructions (SWIs), training materials, etc. as needed for implementation of the new functionality and corresponding processes
• As a primary Oracle subject matter expert on-site, provided knowledge transfer to the
• Genzyme technical personnel

Confidential, Cambridge, MA

Sr. DBA

Responsibilities:

• Performed different scheduled and ongoing tasks, including, but not limited to server installation, patching, database creation, user initialization and data export/import, deployment of customized applications or sandbox schemas as appropriate
• As a member of DB Engineering team for Mergers and Acquisitions department, worked on implementations, upgrades, conversions and consolidation projects with various database systems, including but not limited to Oracle, MS SQL, PostgreSQL, MySQL, Vertica, MongoDB, Cassandra
• According to rotation schedule acted as an on-call DBA: performed all necessary database activities for the Ops team, Tier 3 support for the SOC and engineering support, when requested
• Monitored database / application processes, responded in timely fashion to the raised problems; escalated issues appropriately when necessary; reported discovered bugs
• Installed new database servers, set up data replication between new databases and replication hubs
• Explored possible engineering solutions on AWS to migrate existed database environments
• Performed migration / merge of legacy database servers to new database servers
• Performed quality check for newly created databases
• Worked on performance improvement and tuning of PL/SQL, T-SQL and SQL code

Confidential, Cambridge, MA

Sr. DBA

Responsibilities:

• Database administration, maintenance, support and system enhancement
• Performed different scheduled and ongoing tasks, including, but not limited to server installation, patching, database creation, user initialization and data export/import, deployment of customized applications or sandbox schemas as appropriate
• According to rotation schedule worked as an on-call DBA: performed all necessary database activities for the Ops team, Tier 3 support for the SOC and engineering support, when requested
• Monitored database upgrade progress during deployment process, responded in timely fashion to the raised problems; escalated issues appropriately when necessary; reported discovered bugs
• Performed various DBA customized development tasks: suggested and implemented solutions for RAC environment, wrote shell scripts to execute any administrative tasks, created a sophisticated code-parsing tool to process / analyze/ modify all existed PL/SQL program units
• Performed code review, acted as primary responder for code change approval requests: validated structural integrity, data consistency and database security, raised concerns regarding potential implications; performed knowledge transfer, walking other DBAs through the whole database requirements review process
• Maintained distributable DBA libraries of SQL/PL/SQL code and shell scripts created by DBAs for diagnostics and administration purposes; worked on enhancements to the code; modified existing sandbox management application code to be deployable and versioned like other database schemas
• Performed quality check for newly created databases
• Worked on performance improvement and tuning