SUMMARY:

• 22 years of in - depth information technology experience in design, development, installation, implementation, customization, upgrade and support of databases and operating systems.
• 22 years of experience with Oracle technologies as Oracle DBA in production, development and test environments.
• Having solid foundation of database management, administration, backup and disaster recovery.
• In-depth knowledge and hands on experience in the Oracle upgrade, implementation and installation spanning on various versions and different platforms.
• Accustomed to software version control, implementation, quality assurance, space allocation and management, migration, backup and recovery, data guard instance performance monitoring and tuning, application tuning, capacity planning, standards identification and compliance, problem resolution, and new product/release evaluation.
• Defined database organization, standards, controls, procedures, and documentation.
• Provided experienced technical consulting in the definition, design, and creation of database environments.
• Advised developers and end users with database solutions to business problems, database management system facilities and capabilities, and the operation and tuning of databases.
• Designed, implemented and maintained databases with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation and statistical methods.
• Automated tools expertise and implementation for database maintenance and notification.
• Created logical data models based on customer requirements and implemented the physical model in database environment.
• Oracle database upgrade 12C/11gR2/10g DBA with extensive hands on experience with Oracle 11gR2 and 12C new features.
• Enjoy working in software/IT industry and performed various roles on the logical and physical side of Database Administration.

TECHNICAL SKILLS:

• Exadata
• Microsoft SQL Server
• OEM
• Toad
• Oracle Grid Control
• Visio
• Oracle WebLogic
• PostgreSQL.
• Oracle forms
• MS- Access
• SAP Business Objects
• Crystal Reports. Quest Software
• Stat pack.
• Load Runner
• Embarcadero DB Artisan
• Select- Design
• DB2

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Specialist

Responsibilities:

• Set up PostgreSQL (Open Source Database) and administering the data migration from Oracle
• Provided all activities related to the administration of computerized databases, including cloud-based databases
• Provided all activities related to the administration of computerized databases, including cloud-based databases
• Projected long-range requirements for database administration and design in conjunction with other managers in the information systems function
• Designed, created, and maintained databases in a client/server environment
• Conducted quality control and auditing of databases in a client/server environment and assure accurate and appropriate use of data
• Advised users on access to various client/server databases
• Designed, implemented, and maintained complex databases with respect to access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical method
• Applied knowledge and experienced with database technologies, development methodologies, and front-end /back-end programming languages (e.g., SQL). Performed database programming and supports systems design
• Conducted ETL (Extract, Transform, and Load) of data from various sources both automated and manually with the appropriate quality assurance techniques
• Performed ad-hoc queries and use common data tools including, but not limited to MS SSAS, MS SSRS, etc.
• Performed maintenance of database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems through database design

Technologies Used: PostgreSQL 9.5, Windows 7 Client Server, pgAdmin III.

Confidential, Washington DC.

Oracle Database Administrator

Responsibilities:

• Install and / or clone Oracle databases to create/refresh development and test environments
• Perform scheduled backups.
• Perform database patching for bug fixes, and mitigate security vulnerabilities
• Test recovery and support continuity of operations procedures (COOP)
• Perform user administration
• Automate / maintain and monitor logs
• Document / enhance backup and recovery procedures
• Support deployment of Documentum enhancements and bug fixes to the test and production environments
• Document deployment procedures
• Perform database upgrades as needed
• Index and Data partitioning Strategies
• Database performance tuning

Technologies Used: Oracle Enterprise edition, Linux, OEM, Toad, Business Objects.

Confidential

Sr. Oracle DBA / DB2 and SQL Server DBA

Responsibilities:

• Performed Oracle 11.2.0.1, 11.2.0.2, 11.2.0.3,11.2.0.4 and 12c upgrade for several PeopleSoft databases and respective physical standby databases also in physical and Virtual Machines for production environment. Performed various production performances testing in order to tune maintenance, business and batch processes. Utilized Oracle RAT for tuning processes and utilized Oracle Application Testing Suite (OAT) for simulating user load during load testing cycle.
• Performed Oracle 10.2.0.4 to 11.2.0.1 upgrade for several PeopleSoft databases and respective physical standby databases for production environment. Performed various production performance testing in order to tune maintenance, business and batch processes. Utilized Oracle RAT for tuning processes and utilized Oracle Application Testing Suite (OAT) for simulating user load during load testing cycle. Incorporated several Oracle 11g New Features when applicable to the environment.
• Performed Oracle 10.2.0.4 to 11.1.0.7 upgrade for 5 PeopleSoft databases with respective physical standby databases. Performed various production performance testing to tune maintenance, business and batch processes. Utilized Oracle RAT for tuning processes and utilized Oracle Application Testing Suite (OAT) for simulating user load during load testing cycle.

Technologies Used: Oracle 11.2.0.1 to 11.2.0.2 and 11.2.0.3, 11.2.0.4, 12c RHEL 5.5, LINUX, Oracle Grid Control, Oracle Exadata, PeopleSoft, Toad, SharePoint, SqlServer, Oracle WebLogic,Dekker, GovWin

Confidential

Sr. Oracle DBA 

Responsibilities:

• Perform database, design, modification, development, security, backup, tuning, and maintenance activities in support of computing systems for the Wave project Group.
• Analyze and resolve application performance issues in coordination with customers and other Database Administrators (DBA).
• Ensure integration of upgraded databases requirements and project plans between major project activities using Database tools.
• Document processes and procedures and ensure compliance of organization's database standards, practices and methodologies inclusive of security, hardware, software and configuration management.
• Design and develop custom interfaces, and performed Databases migration including RAC, created standby database for fail over purposes and relocated to a new operation center location.
• Available for periodic unscheduled (on-call) support outside normal business hours.

Technologies Used: Oracle 10gR2, 9i, 8i, Sun Solaris, HP, UNIX, PL/SQL, Spotlight and Toad.

Confidential

Sr. Oracle DBA / DB2 and SQL Server DBA 

Responsibilities:

• Assisting with the administration of development, test and production instances of the Oracle, DB2, and SQLServer Databases. Installation and maintenance of Oracle software within a UNIX environment with a strong focus on data warehousing environments; providing highest level troubleshooting on unique problems; serving as highest level technical resource for a database technology; serving as an expert consultant to developers and customers to provide expertise on database product capabilities and constraints; working outside immediate discipline to coordinate a group of people in troubleshooting a wide-scale problem; serving as point-of-contact across several areas or disciplines to solve major systems outages with high impact or visibility

Technologies Used: Oracle, DB2, and SQLServer, UNIX

Confidential

Sr. Oracle DBA 

Responsibilities:

• Responsible for tuning and configuration of customer service and billing application Oracle databases from the conversion process through the move to production. Database configuration was largely untested in production trim. The application supports about 1000 concurrent users and 3.5 TB total database size.
• Responsible for 20 Oracle production, Development, and Test databases and 17 SQLServer 2000 and 2005 databases for (Alltel.com, Web Content Mgmt, Billing Adjustment, Corporate Tax, Check Image, Unity point of Sales) environments.
• Developed strategic direction for database implementation. RAC (Real Application Cluster) for 10gR2 databases (3 separate nodes running in on single server plus failover servers)
• Developed and implemented database standards and procedures for application databases including third party vendor databases.
• Performed trend analysis for capacity planning of future storage requirements.
• Installed and upgraded database server applications and tools.
• Database architect responsible for database objects (tables, views, indexes, etc.) in support of the application installation/development process.
• Designed and maintained system security.
• Performance tuning including SGA, SQL statements and physical architecture.
• Planned and implemented backup and recovery procedures. (RMAN specifics)
• Coordinated team activities related to the administration of databases, including organization, Documentation, long term requirements planning and operational guidelines.
• Coordinated software evaluation and installation. Considering UNIX and LINIX OS platforms analysis for new hardware and software configuration.
• Mentored programming groups concerning impact of application architecture on the database.