Resume

Sign in

Sr. Database Specialist

Location:
Bowie, Maryland, United States
Posted:
August 30, 2017

Contact this candidate

Huda, Aysha

U.S. Citizen

Active Security Clearance: Public Trust

Bowie MD, 20720

ac120p@r.postjobfree.com Phone:617-***-****

PROFILE:

Skilled Oracle DBA with experience in Database Administration, Unix Administration, project management, and excellent communication skills. Six plus years of active experience, in database design, installation, configuration, system implementation and problem troubleshooting and resolution. Experience cut across different organizations, which include telecommunication, financial, government, healthcare and business systems. Detail oriented professional with extensive customer service experience and able to grasp and assimilate new technologies quickly with virtually little or no external training or support.

TECHNICAL SUMMARY:

Databases:

Oracle (12c/11g/10g/9i)

Cloud Technology

AWS(Amazon Web Services) EC2, RDS Server and S3 storage

Management Tools:

Oracle Enterprise Manager, Oracle Grid Control, Toad for Oracle, ERWIN,SQL Navigator, Oracle SQL Developer, ER Studio

Operating Systems:

Windows, Sun Solaris (9,10), HP-UX, Linux RedHat

Tuning Tools:

AWR, ASH, ADDM, Statspack, TKPROF, DBMS_MONITOR, SQL Analyzer, SQL Profiles, DBMS_STATS, DBMS_SQL TUNE, DBMS_ADVISOR, DBMS_XPLAN, EXPLAIN_PLAN

Languages:

Cron Processes, Unix Shell Script, SQL * Plus, PL/SQL, C, JAVA

High Availability:

Oracle Data Guard/Data Guard Broker, Oracle Real Application Clustering (RAC), Disaster Recovery, Database Mirroring, Replication, Physical/Logical Standby

Web Tools:

HTML, XML, JAVA, Apache, Web Logic

Backup Tools

RMAN, NETBACKUP

Professional Experiences:

Department of Transportation. Washington. DC February 2016 - Present

Title: Sr. Database Specialist

Working with Integrated Systems Group (ISG) to support the Data Management Team with the Department of Transportation as Sr. Database Administrator/Specialist to modernize legacy software systems, and maintenance of databases in the development, test, and production environments in Agile development environment. Responsible for supporting full system development life cycle, including the forward engineering of logical data models, to physical models, and database generation. Database Administration activities include archiving and backup of databases in each environment, performance tuning, support for data migration and systems development, and data integration.

Responsibilities:

Working on overall database architecture, design, installation, configuration, technical support and maintenance of the Oracle 11g and 12c databases.

Responsible for providing application support for Query Optimization, Stored Procedures, Triggers and Indexes for multiple development applications.

Monitoring and troubleshooting databases for optimal performance, resolving issues related to database performance.

Ensuring the on-going operation of databases and related applications by developing, testing and implementing appropriate back-up and recovery procedures.

Performing periodic tuning of the databases, capturing and reporting database usage statistics as required.

Monitoring space usage, allocating disk space and providing technical support to development team as needed.

Administering user accounts, access control and monitoring security requirements of the databases.

Using primarily Oracle RDBMS, supporting migrating the transition of legacy production databases from current operations to an integrated, unified registration processing AWS (Amazon Web Services) EC2 server environment, from 11g to 12c.

Deploying/Implementing physical database changes, reference data changes through ELDM (Enterprise Logical Data Model) change versions to development, BETA, and CIE project databases.

Supporting relational database development including data modeling activities by conversion of logical models to physical models and implementing them at the database level.

Creating database objects such as tables, indexes, synonyms, sequences, entity relationships, tablespace, and schema.

Creating and running ETL/PL SQL scripts in different environments and maintaining documentation records.

Creating and maintaining DDL and DML scripts of the database.

Supporting deployments to project and sustainment release activities.

Extensively working on Export/Import Data Pump for database migration and data replication.

Keeping operations afloat by supporting multiple teams across the program (Development, Data Modeling and Migration team).

ENVIRONMENT: Oracle Server 12c/11g Linux RedHat, AWS EC2 and RDS servers, SQL * PLUS, PL/SQL, Toad for Oracle, SQL Developer, Tortoise SVN Project Monitor, WinSCP, ER Studio.

NII Holdings Inc. Reston, VA. March 2015 – December 2015

Title: Oracle DBA

NII Holdings, Inc. is a provider of fully integrated mobile communication services for businesses and high value consumers in Latin America. With more than 11,000 employees and a subscriber base of 9.1 million, NII operates in America, Argentina, and Brazil, where it offers communication tools with digital cellular voice services, data services, wireless internet access and digital two-way radio features.

Responsibilities:

Created and Administered Oracle databases in 11g/10g/9i production, development, and test environments.

Installed, configured and maintained database instances, created various databases objects, created users with appropriate roles and levels of security.

Provided technical support to application teams in the form of help desk ticketing with Oracle Finance and EBS applications.

Played a key role in Oracle database migration process from HP-UX to Linux RedHat platform in Amazon EC2 (Virtual Servers in Cloud) and Amazon RDS (Managed Relational Database Serves).

Extensively worked on Export/Import/Data Pump and resolved issues on compiling/ validating invalid objects.

Monitored and tuned databases to optimize the performance of the databases by running AWR, ADDM reports, SQL tuning, statistics, and implementing steps to enhance the overall performance issues.

Created/implemented stored procedures, functions, tables and triggers based on business plans using PL/SQL.

Modified and updated client templates in Oracle Financial EBS application by increasing tablespace size and datafile.

Reduced query processing time from 4/5 minutes to 3 seconds by defragmenting tables to optimize the performance of the queries running against the table in Hyperion Planning database.

Increased the number of process and sessions to enhance number of user access in the database as application has been reaching the maximum number of available processes in Hyperion Financial Management (HFM).

Created scripts and setup automatic startup/shutdown of databases for Oracle 10g/11g in RedHat environment.

Assisted with SOX related auditing controls compliance by providing various documents and information.

ENVIRONMENT: Oracle Server 11g/10g/9i, AWS EC2, RDS servers, S3 storage, ASM, RAC, HP-UX, Linux RedHat, Toad for Oracle, SQL Navigator, JIRA, ASANA

PBGC-Federal Corporation. Washington. DC January 2013 – February 2015

Title: Oracle DBA

Pension Benefit Guaranty Corporation is a federal corporation. It protects the pensions of nearly 44 million American workers and retirees defined benefit pension plans. As a member of production DBA team, I have supported over 2TB production database, over 1TB database in test and development environment.

Responsibilities:

Maintained and migrated 50 databases in development, test, and production environments.

Planned and implemented Oracle software installations, upgrades, patches, built database instances and database objects.

Planned, implemented, and troubleshoot Oracle RMAN backups, restores, and recoveries.

Planned, designed, developed, deployed and supported RAC/ASM environment.

Involved with team for troubleshooting and handling common issues that arise during integration of the whole – bugs, network issues, configuration file issues, de-installation and cleanup of clusterware.

Implemented and maintained Oracle 10g/11g Data Guard/standby databases for fail-over purposes.

Assisted developers and QAs with troubleshooting Oracle database related issues.

Supported more than 20 Oracle 10g/11g databases in development/test environments on Solaris/SPARC and Linux/X64 boxes.

Implemented fail-over test to switch any standby database to the production role, for minimizing the downtime associated with the outage, and preventing any data loss.

Added new nodes to RAC Cluster to distribute the load and configure the Oracle RAC.

Involved with database monitoring and tuning; optimize database performance by analyzing objects, generating statistics, creating indexes and views.

Provided technical assistance and guidance to application support staffs and project teams.

ENVIRONMENT: Oracle 11g/10g, RAC, ASM, Sun Solaris, Linux RedHat, SQL * PLUS, PL/SQL, OEM, TOAD

Providian Financial / Washington Mutual Corp. Oakland, CA September 2010 – December 2012

Title: Oracle DBA

Assisted data warehouse group with developing routines for data extractions, transformation, loading into operational data stores(ODS), data warehouse (DW), data mart (DM). Prepared short and long term plans to address infrastructure projects as well supported to and technical leadership for internally and externally sponsored company projects.

Responsibilities:

Responsible for planning and implementation of production Oracle databases and moving to new servers.

Designed and created database capacity planning, designed and managed database recovery strategies.

Worked on physical/logical design, development, installation, configuration, and administration of Oracle databases.

Responsible for setting up/creating new databases, performance tuning/optimization, application schema design, and partitioning tables.

Monitored and fully analyzed performance issues in production Oracle databases by using AWR/ADDM,EXPLAIN PLAN/STATSPACK/TKPROF tools.

Performed backups and recoveries using RMAN/conventional hot backups.

Installed, configured and maintained Oracle 11g Real Application Cluster (RAC)/ASM on RedHat Linux.

Performed performance monitoring, tuning, and administration24x7 database support.

Provided production support, developed plans to test system, and hot/cold backups.

Designed, documented, implemented and maintained all Disaster Recovery procedures.

Responsible for planning/testing disaster recovery for all production Oracle databases.

Monitoring tablespace issues, managing size, creating tablespaces and adding datafiles.

ENVIRONMENT: Oracle Servers, OEM, SQL*Plus, PL/SQL, Sun Solaris, Linux RedHat, Windows

Education:

Suffolk University, Boston, MA

Bachelor of Science in Business Administration (BSBA)

Major: Finance. Minor: Computer Information System (CIS)

Honors: Cum Laude, Trustees’ Scholarship, Maria Steward Scholarship, Dean’s Scholarship, Dean’s List



Contact this candidate