SUMMARY:

• Over 10 years’ experience as Oracle Database Administrator and Architect
• 11g Administrator Certified Associate
• As a Lead I planned and led all Oracle Database Upgrade tasks including 9i,10g, 11g, 12c and patching
• Experience in Database capacity planning, creation of schemas and space management.
• Good knowledge of RAC environment with ASM file system
• Supported Database implementations in a Shared Services environment
• Administration of database security (create and maintain users, roles and assign privileges)
• Oracle utilities such as SQL*Loader, Export/Import and data pump utilities
• Performed auditing of database authentication and authorization methods
• Experience in developing and creating Database Model and Several Physical Databases linking multiple applications
• Creating SQL Queries, PL/SQL packages, functions, stored procedures, triggers, and cursors
• Experience in Shell Scripting
• Worked as database lead and I was responsible for Query Optimization and Performance Tuning.
• Troubleshooting and resolving database performance and integrity issues and resolving session locks, database locks, connection issues and assigning of users’ rights and privileges and revoking those rights
• Using Oracle SQL Developer tool and TOAD tools
• Good working knowledge of Oracle Data Integrator (ODI) ETL tool
• Data Guard implementation to ensure high availability and disaster recovery
• Experience in working and communicating with senior client stakeholders, project managers, team leads, developers and other team members
• Experience of working in Agile/Scrum environment and other methodologies
• A team player, skilled in multi - tasking, time management, documentation
• Knowledge about Big Data, Hadoop, Spark, HIVE, Pig, NIFi, Sqoop, R, Talend, Tableau
• Good knowledge of MySQL database

AREAS OF EXPERTISE:

• Database/System Administration
• Backups and Upgrades
• Problem Solving & Analysis
• Test Plan/ Scripts Development
• Data Scripting & Transfer
• Network Security Systems
• Requirements Gathering
• SDLC Proficiency
• Performance Monitoring
• Project Management
• GUI Design & Development
• Time Management

PROFESSIONAL EXPERIENCE:

Confidential, Fairfax

Systems & Operations DBA

Responsibilities:

• Conducted troubleshooting and diagnostics on multiple data sets and was the primary lead for optimization and performance tuning.
• Worked closely with VA production help desk team to resolve the Veterans issues or and database changes during code migration from DEV/TEST environment all the way to Production.
• Developed PL/SQL scripts, triggers, functions and packages as per the application specifications.
• As a co-lead, coordinated with stake-holders, business analysts, developers and testers of EVSS team and interfaced with VBA Corp database and VBMS database and built the integration touch points and script for correcting data integrity issues.
• As AWS database technical lead, I was involved in setting up the databases, schemas in Dev, QA and UAT environments.
• Involved in export/import of data between non production environments using data pump.
• Responsible for coordinating all the requests to Database Shared Services for the Dev, QA and UAT environments.
• Lead Responsibility to Design AWS infrastructure to move our local applications to hybrid cloud, as an intermediate stage and then it will all public cloud. Established standards of operating procedures to migrate, and manage applications to cloud.
• Created partitions for audit log tables and worked closely with AITC DBA team to archive the data. Created scripts to backup and drop the old partitions.
• Worked with CORP database team to correct the zip code data erroneously routed when 686 FORMS are submitted through EVSS portal.
• As an EVSS DBA lead worked closely with AITC Unix and DBA team to decommission RHEL5 and upgrade to RHEL7 database servers and migration of data to new DB servers.
• Expertise in gathering and analyzing data and problem solving in data quality, accuracy and integrity issues.
• Responsible for Query Optimization and Performance Tuning for the databases in all environments.
• Worked closely with the Testing teams to resolve/analyze data issues.
• Solid experience translating business requirements into conceptual, logical, and physical data models.
• Provide guidance and work leadership to less-experienced staff members.
• Excellent teamwork skills, good oral, written communication and presentation skills.
• Analyzed data source and created data load scripts, executed processes in SQL stored procedures /functions/packages, database job, materialized view, view, synonyms, and DB link.
• Helped set and documented standards for use of databases with objectives of data integrity, data security, efficient operation, audit requirements.
• Responsible for standard procedures for periodic database backup.
• Prepared appropriate dimensional data structures and provided logical interfaces for the extract/ transform/ load process.
• Interacted regularly with program office subject matter experts, technical experts, other database administrators/developers, and SharePoint administrators.
• Experience of working in Agile/Scrum environments and Agile Teams.

Confidential, Bethesda, MD

Oracle DBA

Responsibilities:

• Maintained complete responsibility for the company’s IT operations, involving application development, database administration, and network administration, and including hardware maintenance, system procurement, system configuration operations.
• Performed Oracle 11g/10g/9i/8i software and database installation and upgraded/applied patches to various versions.
• Configured RMAN backup and monitored database growth and alert logs files.
• Performed daily error checks and database health monitoring of physical resources.
• Managed database security by creating and assigning appropriate roles and privileges to users.
• Worked on SQL*Loader as an ETL tool to load data into staging table.
• Managed all production and development databases from planning, testing, implementation and support.
• Developed cost basis reporting for all the customers on FIFO, LIFO, select lot and average basis as per IRS guidelines.
• Performed technical Training/Knowledge transfer to back office staff, brokers and traders.
• Managed Koonce website by making updates and added documents as per management requirements.

Confidential

• Designed, developed, integrated and supported a proprietary application for Confidential (over the past 15 years) using client-side PowerBuilder and server-side Oracle. The application is a data entry and report generator for Koonce customer portfolio administration, double entry accounting system, general ledger, trial balance, open end mutual fund interface, customer transactions and statements.
• Established a methodology for daily money movements with banks and stock movements with DTC (Depository Trust Company).
• Developed an in-house program to submit all the Koonce customers 1099B, 1099DIV, 1099INT and 1099OID to the IRS annually.
• Facilitated the import and export of daily price files and reconciliations between Koonce application and Advent Axys (a portfolio management and accounting system).