SUMMARY:

I am an accomplished and seasoned professional Oracle Database Administrator with Over 10 years IT experience in Data Engineer and Database Administration, Modeler, Analysis, Design, Development, Testing and Implementation of various database, data warehouse, software applications and developing and managing automate scripts. I have worked on very large production databases, performing various DBA roles, across a multitude of platforms (LINUX, Solaris, and UNIX) in production, development and test environments. I am an enthusiastic, proactive team player who is fast at picking up new technology with great attention to detail as well as great communication & documentation abilities. I am proven leader with motivational management style, a solid reputation for building and retaining highly motivated teams and development of innovative solutions. Dedicated team player whom listens, thrives on collaborating with diversely talented team members, and integrates their divergent thoughts, opinions, and perspectives into meaningful actions.

TECHNICAL SKILLS:

OS/Platform: HP - UX/SOLORIS/AIX UNIX, SUSE & RH-Linux, Windows 2007/2000/NT/XP, VMWare, AWS (Amazon Web Services)

Cloud Technologies: AWS (Amazing Web Services) - CloudWatch

Database: Oracle 11gR2/12c, SQL Server 2008/2012, MySQL, PostgreSQL, TERADATA

Database tools: AWS database migration tool, Performance metrics (AWS, ASH, ADDM, OEM), SQL Developer, SQL Workbench

Monitoring: Datadog, AWS CloudWatch

Application: Java platform, Visual Basic, Web Technologies (PHP, JS, XML, AJAX, .NET)

Data Modeling: E/R Modeling, Dimensional Modeling (Schema Modeling)

PROFESSIONAL EXPERIENCE:

Confidential, VA

Sr. Database Engineer/DBA

Responsibilities:

• Database Creation, Configuration, Administration, Database Upgrades. provisioning and managing. Technologies: Oracle, PostgreSQL, MySQL
• Working with the application team on supporting Database Design/schema design for OLTP and OLAP (Data Warehouse) - table, index, column creation and management
• Monitoring databases for database performance analysis and SQL Optimization using native tools such as AWS, ADDM and OEM other metrics: including PL/SQL and complex Queries)
• Database Refreshes between Production and Non-productions; and between Non-productions
• Capacity Planning and Health Checks for the databases such as free storage, used and adding capacity
• Assisting Data Architects, Data Analysts for their quick resolutions for their data transformation and loads
• Datadog (monitoring) setup/configuration - development, testing and production.
• Rehydration (automate) - using Shell Scripts.
• BAU work as needed to manage database changes, infrastructures.

Confidential, Richmond, VA

Sr. Database Engineer/DBA

Responsibilities:

• Provided database administration, configuration and maintenance for the databases including OLTP/OLAP (Data Warehouse) of PROD, DEV, QA environments in on-premier and cloud.
• Provided support in database design/architect, data analysis, data modeling (logical & physical), data profiling, ETL, automatic solutions using Unix shell scripts, database Scripts for data migration, and Optimizing Queries
• Provided support for Oracle, PostgreSQL, AWS (database object management, User/Access
• Developed, tested, optimized, implemented and supported queries: SQL, PL/SQL, PSQL, TSQL, ETL scripts.
• Coordinating and implementing databases on AWS Cloud and on premises
• Providing Performance & Query Optimization and troubleshooting for databases: Oracle, SQL server, PostgreSQL, Redshift
• Worked with Storage Team, Unix Team, and Capacity Planning Counsel on reviewing capacity assessment the resource utilization such as CPU, Memory, IO and Storage and request process.
• Co-ordinated pre-production and production deployments. Developing deployment plan (implementation steps for Production DBA) and rollback plan. Supported prod-fix.
• Providing technical support on WINDOWS, UNIX systems; SHELL SCRIPTS, and Health check scripts assisting with lifecycle management and marketing business intelligence.

Confidential - Herndon VA

Oracle Database Administrator

Responsibilities:

• Provided support in Database Administration and architect solutions for OLTP/OLAP (Data warehouse). Optimizing ETL Scripts, SQL and PL/SQL procedures and database performance tuning and proving best practices is main role and responsibility.
• Provided support in Analyzing, designing, developing, data modeling and database design, data profiling, testing and implementing ETL solutions for Data Warehouse projects.
• Provided support in Maintaining and enhancing legacy Oracle databases in support of production break fixes and application enhancements.
• Provided support in Working with development team to perform database tasks related to application enhancements such as creating new tables and/or columns, writing and tuning PL/SQL, SQL scripts, stored procedures, debugging production database issues.
• Provided support in Database structure changes such as tablespaces, schemas, tables, synonyms, sequences, constraints, indexes, roles, table/system level privileges and profile.
• Provided support in Reviewing data model review packets and normalization, start schema, snowflake schema
• Provided support in Helping development team and configuration management to make build scripts, rollback scripts and unit test scenarios and ensure deploy to the QA environment for testing and then to the production environment.
• Provided support in Installation, configuration, troubleshoot Oracle Application/Web services and databases Oracle DB 11gR2 and 12c, SQL Server
• Troubleshoots oracle databases issues and optimization issues using Explain Plans, AWR, ADDM, 12C and other performance metrics and analysis and providing solutions.
• Database performance tuning through database configuration, partition, parallelism.
• Ensure SQL and PL/SQL scripts as per Confidential standards.
• Planning, defining and implementing backup, recovery and restores
• Working with Network/UNIX team for any network / server level needs and issues;
• Providing middle range of technical support on UNIX systems; SHELL SCRIPTS, and Health check scripts and cleaning databases.
• Reviewing database and server level violations and fixing the violations as per company standards.
• Helping and guiding Application Developers in creating/developing SQL scripts / PLSQL scripts appropriately; and getting access to database. Coordinating pre-production and production deployments. Developing deployment plan (implementation steps for Production DBA) and rollback plan.

Confidential, Falls Church, VA

Oracle Database Administrator

Responsibilities:

• Provided support in Database Administration and architect solutions for OLTP/OLAP (Data warehouse). Optimizing ETL Scripts, SQL and PL/SQL procedures and database performance tuning and proving best practices is main role and responsibility.
• Provided support in Analyzing, designing, developing, data modeling and database design, data profiling, testing and implementing ETL solutions for Data Warehouse projects.
• Provided support in Maintaining and enhancing legacy Oracle databases in support of production break fixes and application enhancements.
• Provided support in Working with development team to perform database tasks related to application enhancements such as creating new tables and/or columns, writing and tuning PL/SQL, SQL scripts, stored procedures, debugging production database issues.
• Provided support in Database structure changes such as tablespaces, schemas, tables, synonyms, sequences, constraints, indexes, roles, table/system level privileges and profile.
• Provided support in Reviewing data model review packets includes data model and normalization, start schema
• Provided support in Helping development team and configuration management to make build scripts, rollback scripts and unit test scenarios and ensure deploy to the QA environment for testing and then to the production environment.
• Provided support in Installation, configuration, troubleshoot Oracle Application/Web services and databases such as Oracle DB 11gR2 and 12c, SQL Server
• Troubleshoots oracle databases issues and optimization issues using Explain Plans, AWR, ADDM, OEM 12C and other performance metrics and analysis and providing solutions.
• Database performance tuning through database configuration, partition, parallelism.
• Ensure SQL and PL/SQL scripts as per Confidential standards.
• Planning, defining and implementing backup, recovery and restores
• Working with Network/UNIX team for any network / server level needs and issues;
• Providing middle range of technical support on UNIX systems; SHELL SCRIPTS, and Health check scripts and cleaning databases.
• Reviewing database and server level violations and fixing the violations as per company standards.
• Helping and guiding Application Developers in creating/developing SQL scripts / PLSQL scripts appropriately; and getting access to database. Coordinating pre-production and production deployments. Developing deployment plan (implementation steps for Production DBA) and rollback plan.

Confidential, Vienna, VA

Oracle Database Engineer

Responsibilities:

• Provided performance tuning/SQL tuning support for PROD and NON-PROD env.
• Generated performance metrics such as EXPLAIN PLAN, AWR, ADDM. Real-time performance monitoring using SQL*Monitor and GRID CONTROL (OEM)
• Database performance and SQL tuning includes table analysis, index analysis for schema tuning. Performed stats gather (Histograms), extended stats on column level. Used SQL Tuning Advisor, SQL Access Advisor, SQL Performance Analyzer, SQL Tuning Set and other advisors to generate tuning recommendations; reviewing, analyzing and providing solutions.
• Helped Application Developers in creating/developing SQL / PLSQL scripts appropriately; Deploy scripts and Rollback plans for production deploys. Created and managed PARTITIONING/Sub-partition as VLDB solution. Configured PARALLELISM to speed up the execution process.
• Worked with Production DBA to co-ordinate the production deploys. Developing Action scripts (deploy steps/implementation steps) and rollback plans for deploys.
• Worked with Infrastructure Team in building new servers and databases; design and implementing data center migrations. Worked with Network/UNIX team for network and server level issues; and resolving the issues.
• RAC/Non-RAC, Grid Control and ASM - software installation, Cluster ware installation, migrations, upgrades (10g to 11gR2), cloning, patch management and data refreshes. Grid Control and Agent management - OEM practices
• Working with development team to perform the database tasks related to application enhancements such as creating new tables and/or columns includes XML tables, writing and tuning PL/SQL, SQL scripts and prod-fixes.
• Performed health checks for databases, servers, listeners, connectivity, RMAN backups and recovery.
• Created and managed database objects such as user/passwords, schemas, tablespaces, tables, indexes, views, columns, synonyms, sequences, database links, constraints etc.
• Performed CAPACITY ASSESSMENT for storage and submitting request to add new file systems (mount points)
• Provided data model support - creating and managing PDM (physical data models). Ensured the Entities and Attributes having appropriate NAMING STANDARDS and appropriate DEFINITIONS; Entities having primary keys, appropriate JOINS (relationships), appropriate INDEXES; and appropriate ROLES, TABLE/SYSTEM level privileges; and security standards.
• Data move/migration from source to target server’s native tools such as data-pump, SQL*Loader, External Tables.
• Change management for tracking and processing all types of DATABASE tasks and production and non-production deploys.

Confidential, Greenbelt, MD

Oracle Database Engineer

Responsibilities:

• Provided database solutions to the production and development databases. Provided database support for the databases: ORACLE 9i,10g,11gR1, R2, SQL Server, DB2 (UDB). E-business databases
• Working with Application teams, Business analysts and QA Team on database design and business requirement.
• Supported production deploys; worked with Production DBA to co-ordinate the production deploys. Provided Action scripts (deploy steps/implementation steps) and rollback plans for deploys.
• Worked with Infrastructure Team in building new servers and databases; design and implementing data center migrations. Worked with Network/UNIX team for network and server level issues; and resolving the issues.
• Worked with Application Team in creating/developing SQL / PLSQL scripts, ETL scripts as require; testing and deploy scripts in production. optimizing the scripts for better performance. developing rollback scripts for production deploys
• RAC/Non-RAC, Grid Control and ASM - software installation, Cluster ware installation, migrations, upgrades (10g to 11gR2), cloning, patch management and data refreshes.
• Provided DB services such as creating and managing tablespaces, tables, columns, constraints, indexes, views, sequences, database links and synonyms etc., Managed user accounts, password management, data security through encrypt/decrypt, data accountability through auditing; and access controls through privileges, roles and profiles; etc.
• Provided replication solutions using Data Guard, Materialized Views.
• Use/remove of HINTS in queries to change directives so to improve performance;
• Recommended INDEXES such as b-tree, index-organized table, reverse-key indexes, descending indexes, b-tree cluster indexes, bitmap indexes, function-based indexes, application domain indexes to speed up the access.
• Created and managed PARTITIONING
• Data move from source to target system using DATAPUMP, IMPORT/ EXPORT.
• Performed monitoring database, analyzing the database changes trends and providing solutions.
• Provided Performance and SQL tuning solutions: AWR, ADDM, ASH, Explain Plan
• Database performance tuning using Memory, PGA tuning, Partitions, parallelism
• Provided support to Business Applications (ERP, E-Business, Oracle Application Server, SOA) such as writing PL/SQL scripts, packages, stored procedures, triggers, functions and constraints.
• Shell scripts in UNIX/LINUX