SUMMARY:

Seventeen years of extensive knowledge and experience in Enterprise IT Systems, Engineering and Business, focusing on the RDBMSs as well as other Middleware & back - end technologies.A great team player with a fast learning curve, excellent diagnostic and problem solving skills necessary to deliver optimal performant Information Systems.

TECHNICAL SKILLS:

Applications: Pega PRPC, Oracle WebLogic 11gR2, Oracle database server 11gR2

Programming languages: J2EE, Java, SQL, PL/SQL, Unix Script, XML

OS: RHEL6.2

Protocols: SOAP, SSL, HTTP, T3, FTP, SSH

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Sr. Database Infrastructure Lead

Responsibilities:

• Assess, develop and communicate the long-term strategic goals for the database environments to meet existing and future business needs.
• Re-architect/re-design the new database platform for COD 15.0 migration from DB2 on main frame with GreenPlum & IMS to an Oracle 12c ONLY database platform on Exadata X5-2 half rack running RHEL6.x with Oracle v12.1.0.2
• Engage in effective physical data storage allocation using CELLCLI and DCLI commands, and usage to facilitate the data growth as well as resource consumption.
• Install, configure, administer, maintain and secure Oracle 12cR1 database on high availability technologies/tools - RAC on ASM with ASM Libraries, Active Data Guard, OEM, ASM, partitioning, Golden Gate & TDE from Development to Production.
• Install & configure Oracle Enterprise Manager (OEM) 12c Cloud Control for monitoring entire IT infrastructure
• Deployed Exadata Plug-in for OEM for comprehensive monitoring of both Database Servers & Storage servers, as well InfiniBand Network and Cisco Switches, KVM, PDUs & ILOM
• Run periodic Exachk for comprehensive Exadata DB Machine component and proactive monitoring
• Periodically review oswatcher reports for proactive intervention if needed
• Configure OCM (Oracle Configuration Manager) for quick collection of configuration information when needed and propagation to Oracle Support if needed
• Configure ASR (Auto Service Request) for automatic generation of requests with Oracle Support, hence reducing response time to service requests
• Created multiple Oracle databases, both single instance & RAC/RAC one-node (both versions 11gR2 & 12cR1 all EE)
• Develop and design database strategies, database products/tools selection and integration, system monitoring, improving database performance, active capacity planning and management.
• Apply Oracle Exadata quarterly patches & updates to the Exadata Storage Servers, Database Servers, InfiniBand, ILOM & other OS firmware, as well as one-off patches to fix bugs
• Design & implement backup and recovery strategies, policies and procedures
• Support data migration efforts.
• Coordinate with Oracle Support, data center host support team and other Technical Architecture and Operations team to support the smooth migration to the new Oracle platform.
• Support peak production and release testing efforts. Provide on-call support as needed.
• Create models for new Oracle database development and/or changes to existing ones to take advantage of new technologies.
• Develop policies and procedures by utilizing the best practices and technologies to maximize database performance and efficiency.
• Work with application development staff to help develop the policies and standards for database design, access, coding, data and object level changes.
• Increase and enhance existing knowledge base with the database group by conducting researches and training to make recommendations on database products, services, protocols and standards in support of procurement and development efforts.
• Establish appropriate end-user database access control levels and develop routines for end-users to facilitate best practices database use.
• Design and implement redundant systems, policies and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets. Develop efficient data migration processes to meet various business needs for data.
• Conform to database security policies to prevent un-authorized access to business data.

Confidential, Hartford, CT

Sr. Infrastructure Technical Architect

Responsibilities:

• Identify key issues and contributors related to Order-to-Drop applications and infrastructure performance and stability issues that could prevent Client from meeting service level objectives that result in significant financial penalties
• Work with client Infrastructure team to carry out detailed assessment of the current state on all backend infrastructure components & artifacts with focus on the
• Datacenters
• Network
• Midrange AIX, HPUX & Windows servers
• Storage infrastructure
• High Availability & Disaster Recovery capabilities, strategy, policies & procedures
• Oracle & SqlServer databases
• Assess existing performance outages, review the infrastructure, application and data center from a stability point of view, analyze data & carry out a gap analysis
• Understand the current landscape, review incidents and outages: Statistics, Severity, Patterns, variables Identify high level GAPs, Issues & focus areas
• Assess stability related issues including analysis of prior outages and potential contributors to instability
• Assess Performance Monitoring including existing capabilities and areas of improvement to provide proactive application monitoring.
• Assess current Infrastructure as it relates to Datacenter, Network, Storage, Midrange, Wintel, HA/DR and provide recommendations
• Carry out an overall assessment with respect to Application performance monitoring, diagnostics as well as infrastructure stability
• Provide immediate, intermediate & strategic long-term recommendations to the Client to completely so as to completely remediate the current immediate issues & stabilize the current state infrastructure, as well as prevent any long-term or up-coming issues/problems
• Gain agreement between Business and IT on project priorities and roadmap
• Discuss sequencing of the ‘key areas’
• Understanding there are dependencies between the key areas, balance progressing one stream with dependencies within and across streams
• Develop work breakdown and effort estimate
• Implement quick wins for immediate gains
• Implement performance tuning and monitoring recommendations to address specific and impending performance issues as well as provide potential breathing room for already tight application and batch processing windows for Order-to-Drop
• Establish Enterprise-wide Service Management, which is critical to ensure stability of the business processes and underlying systems and infrastructure
• Implement a CMS/CMDB system would initiate the dependencies and identify key assets and their relationships

Confidential, Chicago, IL

Sr. Database Administrator

Responsibilities:

• Sr. Oracle DBA and Linux Administrator
• Supporting mobile web applications, Oracle Databases and ESB technologies.
• Responsible for enhancements, break-fix and data analysis for the SDN and underlying database.
• Responsible for Database and OS level support, investigation, monitor management.
• Responsible for Database performance & SQL tuning
• Configuration of DynaTrace Application Monitoring tool as well as accompanying Oracle DB plugin for proactive monitoring of the backend database

Confidential, Manchester, NH

Sr. Database Infrastructure Lead

Responsibilities:

• Database Infrastructure Lead response for a team of 8 DBAs (Senior & Mid-Level - Oracle & SQLServer), responsible for the following:
• Design, test & implement new infrastructure for both Oracle & SQL Server databases for new & existing projects
• Assess, Test & propose recommendations on improving existing infrastructure
• Lead Capacity Planning & performance Engineering efforts in a bid to fine tune existing databases & application
• Designed, planned & implemented database performance management, including testing & tuning of existing databases
• Lead major migration efforts in a bid to relocate current existing databases to newly designed & provisioned host
• Install & configure Oracle Enterprise Manager (OEM) 12c Cloud Control for monitoring entire IT infrastructure
• Deployed agents on multiple servers for visibility of database instances, ASM & other infrastructure related services on OEM
• Installed & configured Oracle Grid Infrastructure - 11gR2 with RAC & ASM
• Installed & configured Oracle database 11gR2 RAC
• Created multiple Oracle databases, both single instance & RAC with both ASM & filesystem (versions 9i, 10g & 11g)
• Periodic database maintenance activities following tuning recommendations
• Execution of database scripts during periodic deployments
• Troubleshooting and problem resolution

Confidential

Infrastructure Technical Architect

Responsibilities:

• Design and validate the infrastructure necessary for the implementation of the PegaRules Process Commander (PRPC) Application from Development to Production.
• Install and configure the following Pegasystem's frameworks on enterprise platforms (RHEL6.2 with Oracle Database 11gR2 and Oracle WebLogic Server 11gR2) from Dev to Prod env'ts:
• PegaRules Process Commander (PRPC) 6.2 SP2
• Decision Strategy Manager (DSM) both 6.2 SP1 & 6.2 SP2
• Next Best Action Advisor (NBAA) 6.2 SP1
• Design & implement the Integration Architecture
• Support project lead in ensuring a consistent implementation of technical components across the three technical streams: core, data and logic
• Participate in the definition of hardware and software architecture in terms of:
• Validating environment sizing & capacity planning
• Validating Database installation & Application Server installation to meet PRPC, DSM & NBAA requirements.
• Basic and advanced configuration of the above application components
• Execute performance analysis and application tuning
• Manage software releases and deploys ensuring the consistency of all the available environments
• Prepare installation guide for Client
• Monitor and support the operations architecture of hardware and software platform

Confidential

Oracle Exadata DBA

Responsibilities:

• Managing various EXADATA (X2-2, X2-4 & X2-8) machines in three international data centers, all RAC with ASM, running Oracle database 11.2.0.2, supporting Oracle Siebel CRM application
• Work closely with Application/Middleware administrators to manage/maintain a total of 140 CRM databases for the Client from Development to production, via end-to-end testing, UAT & Hotfix.
• Redesigned backup & recovery strategy for the Development & Test environments to resolve prior ever-present archiving issues.
• Redesigned archiving strategy for all Dev & Test environments to mitigate downtime resulting from archiving issues.
• Designed & implemented Advanced partitioning & purging strategies for the various CRM applications' data to handle automated data purging (markedly reducing downtime from DB bounces), as well as simultaneously improving DB performance.
• Fully participated in an overall & holistic performance testing, tuning & engineering effort (using Oracle grid Control - running & interpreting AWR & ASH reports, adjusting DB initialization parameters as needed), in a bid to achieve optimal performance of CRM applications in test & hotfix env'ts prior to deployment to Prod
• Implemented tablespace re-org for better manageability & performance improvement
• Trouble-shoot & resolve DB issues as required in a high-pressure time-sensitive mission critical env’t.

Confidential

Sr. Technical Architect

Responsibilities:

• Providing technical vision, resource direction and thought leadership for application and infrastructure projects through the software development lifecycle for projects initiated for the Client
• Direct technical leadership responsibility for ongoing application performance testing, turning, modeling and performance enhancement recommendation according to business need and defined operational level commitments for each functional project
• Technical direction and delivery of the annual Performance Engineering Technology roadmap, including patching, security vulnerability and new performance testing and performance level commitments for each functional project
• Technical direction and delivery of the annual Performance Engineering Technology roadmap, including patching, security vulnerability and new performance testing and performance diagnosis.

Confidential

Sr. Technical Architect

Responsibilities:

• Assess and Analyze the current Farmers Claims Application & Database Design
• Review business requirements, technical requirements, and existing architectures.
• Assess architecture quality, technology choices, risks, and gaps.
• Gauge current application design solution suitability and compare to industry practices.
• Propose alternate design strategies/solutions to improve performance.

Confidential

Sr. Database Administrator

Responsibilities:

• Work closely with Linux System/Storage Administrators to Configure, Implement & Deploy Oracle Single Instance 11gR2 (11.2.0.1) on RHEL5.x using filesystem from development to QA via TEST environments
• Implement UNIX shell scripts for monitoring/maintaining newly configured databases.
• Administer already existing Oracle databases from DEV to PROD via TEST & QA (supporting five major IT projects for the World Bank Group, Washington, DC).
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control, TOAD for Oracle, Embarcadero DBArtisan for oracle & SQL*Plus.
• Work closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes from DEV to PROD, via TEST & QA following requests/demands from the development team.
• Backup/Recovery Configuration of Oracle 9i/10g/11g single instance/RAC databases using Oracle RMAN.
• Setup daily Datapump exports/imports via crontab in DEV & TEST environments.
• Configure/Implement Oracle Streams Advanced Replication with Oracle10gR2 as source & Oracle 11gR2 as target.
• Migrated over ten of the World Bank's Production databases from lower versions of Oracle (9.2.x to 10.2.0.2) to Oracle 10.2.0.4 on new high availability servers (AIX 5.3 & RHEL5.5, using VERITAS clustering) as a part of the Bank's GSR (Global Strategic Re-alignment) project for the 2010 financial year.
• Upgraded all Oracle databases from versions 10.2.0.x to 11.2.0.2, both single instances and RAC running on AIX 5.3 and RHEL5.x.

Confidential, Reston, Virginia

Sr. Database Administrator

Responsibilities:

• Worked closely with Linux/UNIX System/Storage Administrators to Configure, Implement & Deploy Oracle RAC 10g (10.2.0.4) on RHEL4.7 using Automatic Storage Management (ASM) and Oracle Clusterware.
• Configure. Implement & Deploy Oracle 9i (9.2.0.8) & Oracle 10g (10.2.0.4), single instances on SunOS 5.9 & IBM AIX 5.x using filesystems for storage & VERITAS Clustering for high availability using IBM's HACMP
• Create oracle databases (both single instance and RAC) on configured servers using both the DBCA & Database creation scripts.
• Setup advanced database/application auditing, both by use of Oracle SQL & top notch UNIX shell scripts as well as Transparent Data Encryption & Strong Authentication using Oracle Advanced Security.
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.
• Developed UNIX shell scripts for database reporting on daily database activities as well as for monitoring.
• Worked closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes from DEV to PROD, via TST following requests/demands from the development team.
• Backup/Recovery of Oracle 9i/10g single instance/RAC databases using Oracle RMAN.

Confidential, Owings Mills, MD

Oracle Database Administrator

Responsibilities:

• Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10 Oracle databases (8i, 9i & 10g single instances & RAC) running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11.
• Configure and install Oracle 10g (10.2.0.1 and 10.2.0.3), both single instances and RAC on AIX 5.2/5.3 using Automatic Storage Management (ASM) and Oracle Clusterware.
• Configure and install Oracle 9i (9.2.0.1 and 9.2.0.7), both single instances and RAC on AIX 5.2/5.3 using Raw devices and IBM's HACMP.
• Create oracle databases (both single instance and RAC) on configured servers using both the DBCA & Database creation scripts.
• Configure/Implement Oracle DataGuard 10g (both Physical & Logical) for DR purposes.
• Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, Oracle 10g database control, oracle 10g Grid Control as well as other third party tools (TOAD, SQLDeveloper, DBArtisan and dbXpert for Oracle).
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.
• Data migration between databases using both Oracle 9i and 10g export/import utility and Oracle 10g exp/imp data pump.
• Analyzing schema of databases created to collect statistics using the DBMS STATS package.
• Use AWR/ADDM for 10g Statistics management & database tuning following creation of new databases and periodically thereafter.

Confidential, Bowie, MD

Database Administrator

Responsibilities:

• Collaborate with the System Administrators to configure both software and hardware requirements necessary for the proper functioning of the Company's Oracle databases.
• Create and configure Oracle Databases using both the DBCA and manually using database creation scripts (CATALOG.SQL and CATPROC.SQL scripts included).
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement.
• Set up, configure and troubleshoot client-server connectivity using both the Net Manager and the Net Configuration Assistant.
• Install and configure Oracle 9i Client Enterprise Manager (OEM) and 10g Database Control.
• Create database Objects, Tablespaces, Users, Database schemas, profiles, granting privileges and roles.
• Reorganizing and restructuring of existing Databases to meet the OFA standards and for performance optimization.
• Resizing, relocating and duplexing redo logs to either reduce log switching or eliminate contention.
• Analyzing Tables, Indexes and Clusters against chained and migrated rows and providing solutions.
• Providing performance tuning activities to improve performance of the Oracle databases. Tune databases through initialization parameters, SQL statements (using EXPLAIN PLAN), and memory by performing routine checks on the SGA, CPU, logical and physical I/O and contention.
• Conducting disk load balancing procedures to reduce I/O response times and contention.
• Upgrade existing databases by applying Patches.
• Analyze data growth trends for capacity and resource planning.
• Reorganize databases: Defragmenting, rebuilding and/or relocating indexes, and rollback segments, etc.