Senior Database Engineer Resume Rockville, MD - Hire IT People

SUMMARY:

Seasoned database development/administration professional with over 20 years of experience in many IT projects.
In - depth knowledge of database design, development and maintenance.
Many years experiences of monitoring and optimizing database performance with system and application level tunings.
Generated many client and management reports with complex queries.
Accomplished variety of tasks such as new development, database migration, and system integration including several database systems with tables and complicated database functions.
Completed more than 10 projects with Agile development approaches throughout development life cycle from requirement analysis to production support.
Demonstrated ability to work closely with cross-functional teams to complete complex database tasks.
Extremely motivated, self-starter, results-oriented, and accountable individual who is able to work comfortably in a team environment.

TECHNICAL SKILLS:

Platforms: UNIX, Linux, Windows Servers, and AWS Cloud

Languages: UNIX Shell Script, SQL, PL/SQL, Oracle 11g/12c, MySQL, HiveSQL, PostgreSQL

Products: Oracle Enterpriser Manager, Informatica PowerCenter, Designer, TOAD, PLSQL Developer, ERwin, SQL*Loader

PROFESSIONAL EXPERIENCE:

Confidential, Rockville, MD

Senior Database Engineer

Designed and created database objects including schemas, policies, tables, indexes, triggers, constraints, database links, and sequences. Developed and maintained database stored procedures, functions, and packages for data ingestion and applications.
Designed and developed database components for data loading, data quality validation, and data mart calculations. Performed unit/integration tests. Gathered and analyzed requirements.
Created and maintained materialized views with replicating data from company’s data center. Defined and created the replication schedule.
Built metadata used by variety of reports. Constructed and tuned complex queries to ensure accuracy and efficiency.
Managed database deployments in production release.
Provided production support including: monitoring system resource usage, analyzing database statistics, reporting status and issues of data ingest processes, and maintaining system security.
Resolved production issues promptly and provided recommendations to enhance performance.
Created ad-hoc statistical reports to support business team and company executives.

Confidential, Rockville MD

Senior Database Engineer

Analyzed new database requirements according to product specifications.
Designed logical and physical databases. Created database objects to support data processing and applications.
Developed a batch data ingestion process included framework setup, source and target definition, transformation and mapping design, task and session creation, and workflow development. Conducted data modeling, data extraction, transformation, loading (ETL).
Provided technical support to developers and QA staff and performed data quality control audits.
Reviewed and tuned SQL statements for developers. Wrote deployment scripts for application/database releases, system documents, and testing scripts for clients.
Monitored system usage and reported status and issues of data ingestion batch processes in production.
Provided solutions for database related issues in production.
Created and scheduled automated jobs.
Generated statistical reports to clients.

Confidential, Silver Spring MD

Senior Database Administrator/Engineer

Defined database objectives and provided technical options to management team.
Designed and managed the database infrastructure. Performed web server updates.
Created data replicating processes using Oracle snapshot and export/import utility.
Implemented database triggers and constraints to enforce data integrity and business rules.
Tuned databases. Guided developers in writing efficient SQL code. Tested and validated new products and enhancements.
Performed extensive database administration functions, including database system installation, configuration, upgrading, and troubleshooting.
Created processes to receive, validate, calculate, and transform data from various sources to the application database.
Developed and maintained backup procedures for data centers and production databases.