EXPERIENCE SUMMARY:

• I am an accomplished and seasoned professional Oracle Database Administrator with Over 15 years (including 10+ US) of professional 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.
• 15+ years of experience in Data Engineer/Database Administration, Performance Analysis and SQL Tuning
• 15+ years of experience in RDBMS: ORACLE 11g/12c, SQL, PL/SQL, SQL Developer - RDS and EC2
• 4+ years of experience and exposure in data warehouse databases: RedShift, Snowflake, Hive
• 4+ years in experience and exposure in OLTP databases PostgreSQL, MySQL, SQL Server - RDS and EC2
• 10+ years of experience in ETL Script/Programming.
• 10+ years of experience in Modeling/Architecture of OLTP, OLAP (Data Warehouse)
• 4+ years of experience with Python, and (REST) API.
• 4+ years of experience with AWS, EC2, RDS, S3, Cloud Watch, CFT, EBS, Route53, ELB, VPC, Security Groups, Subnets, IAM
• 4+ years of experience with JavaScript, XML/JSON
• 4+ years of experience in automation CI/CD (continuous integration/continuous deployment) using Jenkins.
• 3+ years of experience with Agile.
• Good exposure on data migration tools: Talend, AWS Migration tools
• Good exposure on NOSQL and BIGDATA databases: Mongo, Hadoop (Hive, EMR)
• Good communication and interpersonal skills.
• Comprehensive experience in AWS (EC2, RDS, VPC, Security Groups, Subnets, IAM, Lambda, BOTO3, S3, CloudFront, CloudWatch, Route53, ELB, AWS CLI)
• Experienced in Database Installation, Provisioning, Creation, Configuration, Administration, Upgrades and managing of On-Premises and Cloud - AWS RDS, EC2 and other AWS resource. Oracle, PostgreSQL, MySQL, SQL Server, RedShift, Snowflake
• 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
• Experienced in database refreshes, data movements between Production and Non-productions; and between Non-productions
• Experienced in database migration: moving data from one place to another. Like from database unto S3 bucket; or S3 bucket unto database - I use Database Migration Tools, Native Tools (Export/Import and RMAN, Goldengate (OGG)
• Database DR solutions / TREX solutions (enabling/managing SNAPSHOTS cross regions)
• Capacity Planning and Health Checks for the databases such as free storage, used and adding capacity
• Database design and modeling (Logical to Physical) and assisting Data Architects, Data Analysts for their quick resolutions for their data transformation and loads
• Experience in Creating and Managing Lambda function/CloudWatch/Python - an integration solution for database solutions. I used technologies such as Lambda function, CloudWatch and Python).
• Experience in Setting automation and managing CD/CI pipelines (continuous integration/continuous deployment) using Jenkins, Docker and Python for automate the jobs/tasks such as rehydration, TREX, Application deployments
• Experience in creating CloudFormation (CFT) and other AWS technologies to automate provisioning RDS, EC2 and other.
• Experience in Datadog (monitoring tool) setup/configuration for application servers and database servers (EC2, RDS) - Datadog templates, development, testing and production.
• Experience in Rehydrate the EC2 (automate) - automate the tasks using Jenkin Pipelines, Python, HTML and Shell Scripts.
• BAU work as needed to manage database changes, infrastructures
• Ability to adapt to New Technologies quickly

TECHNICAL SKILLS:

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

Cloud Technologies: AWS (Amazing Web Services) - EC2, S3, CloudFront, VPC, Route53, RDS, Elastic IP, IAM, CloudWatch, EMR, SQS, SES, SES, SNS, Redshift, Snowflake, Snap logic, Glue

Database: Oracle 11gR2/12c, SQL Server 2008/2012, MySQL, PostgreSQL, Mango DB, RedShift, Hadoop, HBase, Hive, Hue, Spark, Presto, TERADATA

Database tools: AWS database migration tool, Native tools, Golden Gate, Performance metrics (AWS, ASH, ADDM, OEM), SQL Developer, SQL Workbench, pgAdmin4, SSAS, SSRS, SSMDS

CD/CI, Scheduler: Jenkin, Bogie, CD/CI pipelines, Python language, Shell script

Monitoring: Datadog, AWS CloudWatch and SNS, Pager Duty

Application: COBOL, PYTHON, IDE, JAVA, C/C++, FORMS 6.0, VB6 Java platform, Visual Basic, Web Technologies (PHP, JS, XML, AJAX, .NET), WebSphere, Reports 6.0, Cognos 8 suite

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

PROFESSIONAL EXPERIENCE:

Confidential, Falls Church, VA

Database Engineer/DBA

Responsibilities:

• Database Creation, Configuration, Administration, Database Upgrades. AWS RDS, EC2 and other AWS resources - provisioning and managing. Technologies: Oracle, PostgreSQL, MySQL, RedShift, Snowflake and others as require.
• 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
• Database migration: ETL design and moving data from one place to another. Like from database unto S3 bucket; or S3 bucket unto database - I use Database Migration Tools, Native Tools (Export/Import and RMAN, Goldengate (OGG)
• Database DR solutions / TREX solutions (enabling/managing SNAPSHOTS cross regions)
• 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
• Creating and Managing Lambda function/CloudWatch/Python - an integration solution for database solutions. I used technologies such as Lambda function, CloudWatch and Python). Setting and managing CD/CI pipelines using Jenkins, Bogie, Docker, Python for automate the jobs/tasks
• Creating and managing CloudFormation (CFT) and other AWS technologies to automate provisioning RDS, EC2 and other. Datadog (monitoring) setup/configuration - development, testing and production.
• Rehydration (automate) - using Jenkin, Python and Shell Scripts.
• BAU work as needed to manage database changes, infrastructures.

Confidential, Richmond, VA

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 and/or python scripts, database Scripts for data migration, generating metrics, automate the process. Optimizing Queries
• Provided support for Oracle, PostgreSQL, Redshift on-premises and AWS (database object management, User/Access
• Provided support in managing AWS Cloud technologies: EC2, S3, RDS,
• Developed, tested, optimized, implemented and supported queries: SQL, PL/SQL, PSQL, TSQL, ETL scripts.
• Coordinating and implementing DR solutions, HA solution for 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, CRONTAB jobs and Health check scripts
• Supported Application Projects such as MAGIC (Managing s and rewards, Growth, Incentives and Compensations) that provides the functionality that covers ABO (distributors or accounts) profiles and ps, as well as assisting with lifecycle management and marketing business intelligence.

Confidential, Herndon, VA

Senior Oracle DBA

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 (PDM) 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 such as OBIEE, Fusion Middleware Serer, WebLogic, OBIEE, Oracle DB 11gR2 and 12c, SQL Server DB, AWS RDS etc.
• Troubleshoots oracle databases issues and optimization issues using Explain Plans, AWR, ADDM, Trace Files (10053 and 10046), 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, CRONTAB jobs 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

Sr. Database Administrator/SQL Analyst

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 (PDM) 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 such as OBIEE, Fusion Middleware Serer, WebLogic, OBIEE, Oracle DB 11gR2 and 12c, SQL Server DB, AWS RDS etc.
• Troubleshoots oracle databases issues and optimization issues using Explain Plans, AWR, ADDM, Trace Files (10053 and 10046), 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, CRONTAB jobs 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

Senior 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, ASH and TRACE DUMPS and interpreting and analyzing. 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.
• Involved in two GOLDENGATE IMPLEMENTATION PROJECTS. Performed OGG Installation, implementation, trouble shooting on source and target environments. Configuring OGG components: EXTRACT, DATAPUMP, REPLICAT and Remote / Local TRAILS; monitoring replication services. Configured UNI-DIRECTIONAL, Active-Active and Active-Passive replicates.
• UNIX: AIX, HP-UX, SOLARIS, LINUX. Shell scripts and CRONTAB scheduler for monitoring and managing processes

Confidential, Greenbelt, MD

Senior 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: SRM, CIS, OBIEE
• 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/Sub-partition as VLDB solution
• 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, Auto Trace, Trace files 10053, 10046
• 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 and scheduling in CRONTTAB

Confidential, Chevy Chase, MD

Oracle Database Engineer

Responsibilities:

• Managed and coordinated multiple IT projects in Finance department, Andhra Pradesh, involved in design, development, implementation and maintenance. I was in-charge for the district level operations - one district data processing centers and 18 remote data processing centers. Managed a team of 20+ data processing assistants (5 onsite and others remote) including junior DBA, developers and production support. and facilitating 20+ professionals (same cadre - EDP Officers with DBA/System Admin role) those support the operations in the allocated district, on project implementation including database, application and ETL jobs.
• Worked closely with the customers and their requirements and attending state level project meetings for analyzing and planning for improvements and new techniques.
• Provided database solutions to the production and development databases. Provided 60% support as DBA; and 40% as Database Development includes ORACLE PSP/FORMS/REPORTS and ETL jobs.
• Co-ordinated a Major Conversion project from Legacy application (COBOL, database and VB6) to Oracle Application. Developed staging tables, scripts for Extract, Transformation and Loading the data from COBOL to Oracle.
• Database administration and system analysis and design; and database support for the databases: ORACLE 9i,10g, Worked with Application teams, Business analysts and QA Team on database design and setup reviews 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. Created and managed database objects such as tablespaces, tables, indexes, views, sequences, database links and synonyms etc.
• Performed System Administration such as installing, configuring and managing Operating systems such as Windows, Linux and UNIX; and networking administration - OS level and application level.
• Performed Database Analysis, Modeling and Design including Capacity planning of system storage and application growth for the projects. Helped Application Developers in creating/developing SQL / PLSQL scripts appropriately; Deploy scripts and Rollback plans for production deploys
• Installing, Configuring and Tuning the Oracle Database. Upgrading Versions and patches. Cloning database and Database refreshes. Cold/Hot Backups using RMAN, old EXP/IMP. Performed data capturing, data transforming, data conversion, data load and extracts using SQL*Loader, LOADPSP (), EXPORT/IMPORT and PL/SQL scripts and creating, managing data Marts
• Management - provided strong leadership, direction, guidance, decision making. Project Management - facilitation, risk assessment, task decomposition, resource planning, tracking the work and reporting. Asset Management - routine maintenance including system, database, hardware, application; asset recording system (identification, verification and reporting), budgeting. Vendor/Procurement: vendor management, volume agreements and inventory management