PROFESSIONAL SUMMARY:

• An accomplished Database Administration with twelve years success in designing, implementing, and managing database solutions that improve business functionality.
• Possess a diversified technical background with Enterprise Systems Solutions.
• Proven ability to implement resources that decrease cost increase performance and consistently exceed targeted goals.
• Extensive experience working with all aspects of in - house developed and COSTS systems.
• Expertise in full system development life cycle development for implementation and integration.
• Understanding of technology with focus on delivering business solutions.

TECHNICAL EXPERTISE:

Oracle 9i, 10g, 11g, 12c

Solaris 8,9,10

Oracle Security Administration

Oracle Enterprise Manager (OEM)

Oracle Database Replication

Unix Shell Scripting

Database Design/Modeling

PL/SQL

SQL Loader

Unix, Solaris, AIX

Recovery Manager (RMAN)

Windows NT, 2000, 2003,2008

Real Application Cluster (RAC)

ESX CLUSTER VMware

GRID Control

SQL Server 2000,2005,2008R2

Lotus Notes Crystal Reports

Oracle Web logic 11g, 12c Oracle 11g Exadata

Greenplum Automated deployment packaging

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Database Architect (Lead)

Responsibilities:

• Provide effective communication of project status and other pertinent information to upper management.
• Conducted periodic security evaluation on application and data system level and developed action plans.
• Installation, upgrades, migrations, performance tuning, backup and recovery, schema management, SQL tuning, proactive monitoring and troubleshooting Oracle databases in a 7x24 environment.
• Implemented and support of 10g and 11g migrations and upgrades from Oracle 9i and 10g databases, including RAC (Real Application Clusters) databases on HP-UX and Linux.
• Participate in the selection process for new IT solutions.
• Evaluate options and design architecture solution for backend database environments and web-based systems in order to support business, technical, and service-level objectives.
• Support the development of strategy, frameworks, best practices and patterns working with architects from other IT functions.
• Implemented, documented and support builds of new clusters to use Oracle 10g/11g RAC on HP-UX and Linux. Including installing clusterware, ASM (and shared disks) and creating new databases.
• Provide support for Oracle Enterprise Manager Grid Control and Agents.
• Designed backup strategies using both Oracle RMAN, Microsoft SQL inbuilt backup and COMMVAULT backup capabilities.
• Developed and implemented a comprehensive Disaster Recovery Plan for the Oracle and Microsoft SQL databases
• Define and communicate the technical roadmap and lifecycle for the components and systems supported by the database administration team.
• Conduct technical reviews of all new projects and enhancements to existing installed base to assess impact to existing and future architecture plans.
• Maintain up-to-date knowledge of technology standards, industry trends, emerging technologies, and software development best practices.
• Perform proof-of-concept evaluations to assess capabilities and appropriate fit within architecture.

Confidential, Lanham, MD

Oracle DBA/SQL admin(Lead)

Responsibilities:

• Responsible for the performance, integrity, backup and security of Greenplum
• Databases.
• Installation and configuration of Greenplum full-rack DCA and database.
• Management of query processes via GP command Center.
• Proficient in use of data domain for backup and recovery of GP databases.
• Heavy experience with Linux and shell scripting for maintaining and administering GP
• DCA.
• Periodic use of vacuum and analyze to optimize psql query and database efficiency.
• Responded to database events including resource management, performance monitoring of cluster administration, managing high-availability, scaling VLDB, database recovery, and distributed partitioned database design.
• Reported of AWR, Alert logs, Oswatch archives and Daily stream lag study and analysis of the electronic filing databases.
• Established Standard Operating Procedures for the Database and application support teams.
• Performed grid control monitoring and maintenance of all 11g databases.
• Oracle Golden Gate implementation and maintenance.
• Implementation of Oracle Exadata database machine X2-2 half rack.
• Installed Oracle Exadata storage server software and higher.
• Install oracle auto service request ASR package for Exadata.
• Configure Fault Telemetry Destination for oracle Exadata.
• Monitoring of Exadata database, storage server, infiniband network, KVM, PDU, ILOM, CISCO SWITCH.
• Validate application performance using SQL performance Analyzer and Database Replay.
• Oracle Exadata performance Diagnostic and tuning.
• Automated Deployment Packaging.
• Rational Clear case.
• Rational Clear Quest.
• Humming bird exceed.
• Kisam help ticket system.
• ITE (DITE) and production Tivoli infrastructure .
• Installation Request Tracking Tool (IRTT).
• Tivoli inventory, software distribution and Desktop

Confidential, Fort Mead, MD

Oracle DBA/SQL Server Admin

Responsibilities:

• Manage development, test and production Oracle Databases on Sun Solaris environment.
• Installing client/server Oracle 11g software application.
• Monitoring database space utilization and performance of the production databases.
• Monitoring, configuring, updating, and optimizing production databases.
• Installing MS SQL Server and maintained multiple Access database.

Oracle DBA

Responsibilities:

• Responded to database events including resource management, performance monitoring of cluster administration, managing high-availability, scaling VLDB, database recovery, and distributed partitioned database design.
• Reported of AWR, Alert logs, Oswatch archives and Daily stream lag study and analysis of the electronic filing databases.
• Established Standard Operating Procedures for the Database and application support teams.
• Performed grid control monitoring and maintenance of all 11g databases.
• Executed Oracle database conversion to Green plum EMC database.
• Created and managed scripts for internal and external table creation in Green plum database.

Confidential, Reston, VA

Oracle DBA/SQL Server Admin

Responsibilities:

• Strong knowledge of Oracle data warehouse designing.
• Excellent Oracle data modeling ability.
• Developed the Oracle data warehousing and reporting scheme currently in use within the HR system.
• Provide operational support in scheduling the ETL jobs for Oracle data extraction from source systems to the Operational data warehouse.
• Installed and configured Oracle Web Logic Server 11g.
• Created and configured domain on Oracle Web Logic Server.
• Created and configured Oracle Managed Server.
• Created Oracle Web Logic Server Cluster on Solaris 10.
• Used WLST to deploy applications.
• Configure JDBC Data Source on Web Logic Server 11g.
• Implemented Oracle grid control and Real Application Cluster.
• Built Sun Solaris servers using Jump starter.
• Built and administered SQL server on windows.
• Monitor Nagios, Red alert, and Raritan systems.
• Responded to hardware problems and system outages.
• Designed solutions for new business initiatives (Deltek, Cognos).
• Provide software and hardware support for a very diverse datacenter.
• Implemented new projects within the data center.
• Built Linux servers using Jump starter.

Confidential, Lanham, MD

Oracle DBA

Responsibilities:

• Migrated Our Oracle DB server from Solaris 8 to 10, worked with the Unix Admin team to accomplish this task.
• Modified Oracle grid Control installation to configure options and add multiple databases onto the grid for global management.
• Installed Oracle Grid control agents on both UNIX and window servers for Database global management purpose.
• Troubleshot Oracle database connection issues, performance issue and all day to day ticket issues reported by the customers.
• Monitored a large number of Oracle production databases in a fast paste environment, for databases sizing over 200GB.
• Maintained daily Oracle database backup, troubleshoot failed backups and manually executed failed backups as required.

Confidential, Alexandria, VA

Oracle DBA

Responsibilities:

• Provided technical services in motoring and maintaining the production and test databasesmanaged on INTEL, UNIX, and LINUX servers.
• Installation of Real Application Cluster.
• Managed Oracle Enterprise Manager and 10g grid control.
• Managed backup disk space and allocation and database backup execution.
• Installed, integrated and tested new versions of database software and server scripts required for automation backup and security checks and modification (upgrading database software, installing software patches, patchsets and security fixes).
• Administered enterprise-wide passwords, recovering from media; software and database failures; documentation of procedures; and automation of regularly scheduled tasks.
• Monitored VCS and ASM environment with scripts.

Confidential, Lanham, MD

Database Engineer

Responsibilities:

• Managed development, test and production Oracle Databases on Sun Solaris environment.
• Performed Hot and Cold backups using both RMAN and Oracle exp utility.
• Installed and patched Oracle software on both UNIX and Windows environment.
• Loaded Oracle data using SQL Loader and non Oracle data using ODBC.
• Upgraded Oracle 9i Database from 9.2.0.1 to 9.2.0.7 on both Unix & Windows
• Provided remote technical support for clients using SSH and terminal services.
• Implemented Oracle password authentication, Data integrity and Role creation to control database access and modification.
• Implemented a Disaster Recovery Facility (DRF) plan according to policies.

Confidential, Beltsville, MD

Data Analyst/SQL Server Admin

Responsibilities:

• Installed client/server Oracle 9i, 10g software application.
• Monitored database space utilization and performance of the production databases.
• Oracle's Enterprise Manager (OEM), Statistic Package Reports, Explain Plans, SQL Trace and TKPROF.
• Monitored, configuring, updating, and optimizing production databases.
• Created SQL scripts to create tables, keys, views, indexes and synonyms required to meet developer needs.
• Produced physical databases with multiple table spaces from logical data model.
• Performed cold and hot backup of databases using Oracle's export utility.
• Implemented database securities using roles and profiles.
• Prepared scripts to tune developer SQL codes to maximize result return time.
• Installed MS SQL Server and maintained multiple Access database.
• Installed, configured Oracle 9i and created databases sizes up to 80GB on Solaris 2.8.
• Troubleshoot database connectivity problems and other related problems
• Implemented database securities using roles and profiles.
• Performed database migration from 8.1.6 to 8.1.7
• Created backup scripts for logical backups and automated the scripts.