PROFESSIONAL  SUMMARY:

• I have performed duties as a DBA for many years functioning at the highest levels. My responsibilities have included:
• Ensuring availability and performance of the databases that support customers applications.
• Proactively monitoring the database systems and servers to establish secure services, performance tuning and troubleshooting with minimum downtime.
• Gathering technical requirements and SLAs from customers and implement various database updates and patches to support their database environments.
• Assisted in the planning, implementation, integration and maintenance of the hardware and software infrastructure supporting a wide variety of customer applications.
• Responsible for the planning, implementing, and execution of Oracle database backups, high availability planning and implementations, and disaster recovery scenarios.
• Responsible for database patching, upgrades, and support activity including off hour support when required. The ability to schedule multiple assigned tasks efficiently with little assistance from management. Provided on site and remote site support for production and non - production environments. Interface with and support customer refresh requests, restores and database administration functions. Shell scripting in C, Bash, Bourne and Korn.

TECHNICAL SKILLS:

Hardware: Confidential PC and Compatibles, PS/2, Series 1, 30XX, 43XX, 9370, RS/6000; DEC VAX 11/780, 6310, 3600, 3200, 5000, 8250, 4000, 600, VLC,MicroVAX, VAXstation, DECstation; Apollo Workstations, Compaq, Sun/Sparc Workstations and Servers, Burcon, Sytek LAN/PCU, MODCOMP, Apple Macintosh, SynOptics Lattisnet, Modems, Routers, Tranceivers, Concentrators, Intermec 944X Barcode Reader, Scanners

Operating Systems: VM, UNIX, Xenix (System V), SUN OS, Solaris, Ultrix, AIX,Linux, VAX/VMS, OS/2, MS-DOS, Domain/Ix, Aegis, TOS, DOS/VSE, Vollie, VSAM, MVS, System 6; MS Windows (XP, Server, 7)

Networks: Nestar LAN, LAN Manager (3COM & Microsoft), Sytek LAN/PCU,Token Ring, TCP/IP, Internet, NCP, NCS, Multinet, FTP, SFTP, LDAP, Active Directory

Protocols: NFS Server and Client, Excelan, Exos, Telnet, SL/IP, SNMP, UUCP, SMTP, Novell Netware, SQL *NET, DECnet, Vaxcluster, Ethernet, 10base-T, FDDI, VLM, SPX, PPP, SFTP, FTP

Languages: Ansi SQL, PL/SQL, Transact-SQL, Embedded SQL, Java, REXX, C, C++, CSP, Pascal, Cobol, PL/1, ALC, EXEC 2, CMS EXEC, FORTRAN, PDL, (VAX/VMS) DCL, Shell Programming (C, Bourne, Korn, Aegis), IRL, Basic, MS Visual Basic, MS Visual C++, WinBatch, Windows Interface Language (WIL), PERL, IRL, XML

Databases: SQL RDBMS IBM SQL /DS & DB2, Oracle 12c, Oracle 11g, Oracle10g, Oracle9i, Oracle8i, Oracle7 Server ; Informix, Ingres, Integra, R Base, (OS/2) Data Manager, ANSI SQL, SYBASE SQL Server, Sybase SQL Anywhere, Progress, (Gupta) SQLBase, Microsoft SQL Server, MySQL, ODBC, Rdb/VAX, RDBMS Microsoft Access, Lotus Approach, System 2000, C-Tree (Isam), RMS, Access

GUI: (Graphical User Interfaces) Microsoft Windows, Presentation Manager, X-Windows, Motif, GEM, SCO Desktop, HP/Apollo VUE

System Software: SAS, QMF, Oracle Financials, Oracle9iAS & Oracle Application Server, Oracle Designer, Oracle Tools, Oracle Forms(SQL*FORMS), Oracle Portal, WebDB, Oracle Reports (SQL *Reportwriter), Oracle Developer, Oracle JDeveloper, Oracle Developer, Oracle SQL Developer, Tivoli, ADSM, EASY*SQL, MySQL, SQL *QMX, PRO*C, Powerbuilder, S-Designor, Erwin, Oracle Enterprise Manager, Oracle RAC, Oracle DataGuard, Server Manager, Scopus, CSP/AD, Xedit, Kedit, SQL*Loader, SQL *NET, Personal Rexx, Rexx For Windows, Vedit, RXSQL, Dirmaint, Brief, Script/VS, YALE, IIS, RACF, ACF2, JCL, ISPF, FSP, Telegraf, Phoenix, DCF, SMART, RSCS, VM BATCH, Quickgraf, R-Tree, Turbo Pascal, Assembler & Debugger; Quattro Pro, Microsoft Microsoft C, Pacioli 2000, Juris, Term, SQR, SQR for Windows, WinEDIT, e tc.

EXPERIENCE:

Confidential

Current Lead/Sr. Database Administrator

Responsibilities:

• Unix Shell scripting (Korn, C, Bourne, Bash) for maintenance, initialization, automation and problem resolution.
• Performed database refreshes and Disaster Recovery/Business Continuity drills and documented the results for improvements.
• Performed performance tuning, trouble shooting and problem resolution across production and non-production environments.

Environment: Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle OEM 13c, Oracle Solaris 8/10Linux, MS Windows 7, MS SQL Server 2012, Oracle E-Business Suite R12c, Oracle NetServiceNow, SharePoint, Quest Toad, SQL Developer, Power/shell, Perl 5, PythonOracle Solaris, Oracle Linux, MS Windows Server 2012, Citrix

Confidential

Software and Database Consultant

Responsibilities:

• Modify Turnkey sales and manufacturing software and provide documentation of same.

Environment: MS Windows 10, MS SQL Server 2012, MS Access 2012, MS VBScript, MS VisualBasicMS Powershell

Confidential

Sr. Oracle Consultant and Systems Engineer

Responsibilities:

• Lead Oracle DBA and Linux System Administrator for Infrastructure Team on Confidential project
• Provided database and Linux support for multiple teams and applications
• Performed performance tuning, trouble shooting and problem resolution across production and non-production environments.
• Responsible for developing and documenting standardization policies and procedures to insure proper set up, deployment and validation of servers and databases according to Best Practices and DB Standards as per industry standards.
• Installation of Oracle: Enterprise Manager, Weblogic, Apache Webserver, Middleware Fusion; Linux Gnome Desktop and other software.
• Offshore Coordination with DBA support team and various offshore resources.
• Performed database refreshes and Disaster Recovery/Business Continuity drills and documented the results for improvements.
• Responsible for creation and maintenance of various database and OS scheduled jobs for data migration, updates, data refreshes, etc.
• Performed various Linux System Administration tasks such as adding and modifying users, adding devices, adding storage and filesystems, etc.
• Unix Shell scripting (Korn, C, Bourne, Bash) for maintenance, initialization and problem resolution.

Environment: Oracle OEM 11g, Oracle 11g, ASM, Data Guard, Red Hat Linux 6, Windows 7Windows Server, SQL Server 2012, SQL Developer, Toad for Oracle, Oracle WeblogicOracle Middleware Fusion, ServiceNow, XML.

Confidential

SR. DATABASE CONSULTANT/DBA

Responsibilities:

• Subject Matter Expert (SME) on Oracle Enterprise Manager 10g, 11g, 12c configuration, installation, Agent installs, monitoring, etc.
• Supported various environments as part of GSO Database Services which entailed break-fix containment for Production, QA/UT, SIT and Development environments.
• Performed performance tuning, trouble shooting and problem resolution as part of regular BAU (Business As Usual) activities.
• Administration tools like Enterprise Manager/Grid Control, Genesys, etc..
• Set up and administration of Oracle Data Guard.
• Install, configure, upgrade & patch Oracle RAC and non-RAC databases, listeners and software. Create and configure instances.
• Backup and recovery, configuration and maintenance using RMAN.
• Database and Application SQL Performance Tuning;
• PL/SQL, Stored Procedures, Triggers, Packages expertise
• Database design and logical modeling knowledge
• Knowledge of database creation, log segments, disk initialization, disk mirroring, taking backups of databases and restoration in case of failure.
• Unix scripting (Shell (Korn, C, Bash), Perl, etc.) for maintenance, initialization and problem resolution.
• Monitor databases using provided monitoring tools.
• Developed and enforced database standards with development and project teams.
• Database Auditing - provided comprehensive reporting and accountability to management.
• Setup and configuration of Oracle Fusion middleware components to support OEM: WebLogic, OID, Name Server, OMS, SOA suite/ Oracle BPM Suite
• Strong interpersonal and communication skills and worked in a team as well as independent problem-solving & self-directed.
• Responded and Resolved Help Desk and Incident database support tickets.
• Provided Onsite and Offsite (On Call) support 24x7 in a group rotation.
• Work issues with Vendor support, provide root cause analysis & incident reports.
• Participated in weekend Project / Business as usual (BAU) / Adhoc tasks.

Environment: Oracle OEM 11g, ASM, Golden Gate, Data Guard, RAC, RMAN, TSM, ServiceNow, XMLGenisys, Sun/Solaris, Linux, AIX, Windows, Veritas - Volume ManagerVeritas Cluster, Veritas FS, EXADATA, NAS and SAN storage environment: .

Confidential

SR. DATABASE ANALYST/ADMINISTRATOR

Responsibilities:

• Performed database Backup and Recovery in support of business continuity using RMAN and other means for backup and recovery of databases; remediated older databases to comply with corporate standards.
• Performed performance tuning, trouble shooting and problem resolution as part of regular BAU (Business As Usual) activities.
• Supported high availability database infrastructure including Oracle RAC and Data Guard technology.
• Subject Matter Expert (SME) and Lead DBA on Oracle Enterprise Manager 10g, 11g, 12c configuration, installation, Agent installs, monitoring, etc.
• Handled production and non-production installation, upgrading, patching, maintenance and support activity of Oracle 10g and 11g databases.
• Administration, maintenance and installation of OID (part of Oracle Fusion) for enterprise wide name resolution.
• Participated in successful efforts to set enterprise wide standards for database design, deployment, backups and security and enforcement of Best Practices and DB Standards as per industry standards.
• Lead DBA / Subject Matter Expert (SME) on Oracle database auditing and compliance enterprise wide. Managed the Oracle database compliance for quarterly QAR as part of Compliance and Governance processing. This included development using PL/SQL, Oracle APEX, SQL*Plus and shell and batch scripts.
• Provided problem resolution, installation and integration between MS SQL Server, MS Access and Oracle databases for client’s legacy data.
• Supported client base that included developers, business users, etc. Supported users in EDI, PCI, Web development and applications, MMAS, SMART Systems, etc. Gained understanding of basic operations of client business areas, and basic applications.
• Initiated and authored several policies and informational documents that became part of the Standard Operating Procedure (S.O.P.) for the DBA team. Generally documented procedures or processes that are done on a regular basis to share the knowledge with my team mates.
• Maintained good rapport with users and developers especially when discerning the nature of their problem or request from vague descriptions and their point of view. Often I was able to diffuse a situation before it became an “official” problem or request.
• Worked closely with all functional and development groups to assure a smooth implementation and to ensure compliance with all corporate adopted system standards, policies and directions.
• Applied creative solutions to some problems and situations (thinking outside the box) that were resolved successfully.
• Implemented standard configurations and tools to enable back up operations, analyzing of objects, and cleaning of file systems and logs using PL/SQL, shell scripts, etc.
• Participated in regular 24/7 On Call support duty rotation for production databases and after hours support.
• Continually evaluated the merits/ benefits of available system upgrades and enhancements.
• Participated in the design, testing, and implementing specific database structural changes across all environments.
• Excel at researching solutions to questions, problems, and inexplicable errors.

Environment: Production, development, certification and user acceptance support environments: Oracle10g/11g RAC, Oracle 10g/11g/12c Enterprise Edition, Oracle9i, Oracle Developer, PL/SQL, Oracle JDeveloper; Oracle Enterprise Manager 11g/12c: Oracle Grid Control, Oracle Cloud Control and Administration; TOAD, SQL Developer, SQL Loader, JDBC, Java, Weblogic, ODBC, AIX, Solaris, Linux, Windows, Korn shell, Bash shell, MS SQL Server, MS Access, EXADATA, ServiceNow, XML .

Confidential

INDEPENDENT ORACLE DBA/CONSULTANT

Responsibilities:

• Planned, coordinated and implemented security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
• Implemented backup and recovery strategies and disaster recovery strategies utilizing backup scripts and RMAN.
• Tested programs and databases, corrected errors and made necessary modifications.
• Modified existing databases and database management systems or directed programmers and analysts to make changes.
• Implemented changes to bring databases into audit compliance and company and best practices standards.
• Upgraded and migrated databases from Oracle 9i to 10g.
• Production, Test and Development environment: Oracle9i, Oracle 10g, Oracle Enterprise Management, PL/SQL, MS Windows Server.

Confidential

INDEPENDENT ORACLE DBA/CONSULTANT

Responsibilities:

• Performed installations, upgrades and configurations of Oracle database software, databases, Oracle Enterprise Manager (OEM) Grid Control, etc.
• Tested programs and databases, corrected errors and made necessary modifications.
• Modified existing databases and database management systems or directed programmers and analysts to make changes.
• Planned, coordinated and implemented security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
• Implemented backup and recovery strategies and disaster recovery strategies utilizing backup scripts, RMAN, Tivoli, standby databases and servers, etc.
• Supported high availability database infrastructure including Oracle Data Guard technology.
• Worked with vendor and client staff to improve performance of database and vendor’s turnkey application.
• Setup and configuration of Oracle Fusion middleware components to support OEM: WebLogic, OID, Name Server, OMS, SOA suite/ Oracle BPM Suite
• Managed database performance and capacity, provided plans for increases and/or decreases, ensures improvements were successfully implemented and made tuning adjustments as necessary.
• Initiated scripted maintenance procedures utilizing PL/SQL, SQL*Plus and shell scripting.
• Created and implemented the design and enforcement of Best Practices and DB Standards as per industry standards.
• Production, User Acceptance and DR environments: MS Windows Server, AIX, Oracle 10g, Oracle Enterprise Manager, PL/SQL, XML, DataGuard, Standby Databases.

Confidential

SR. DATABASE ADMINISTRATOR/ANALYST

Responsibilities:

• Insourced back from Confidential to Confidential on 1 JAN 2005.
• Database support for Treasury and Security Services Line of Business.
• Duties similar to before, including setting up server and database monitoring and participating in remediation of existing servers and databases; worked with Oracle 10g RAC, VCS clusters and standby databases. Implemented RMAN backups.
• Handled team administrative duties for obtaining userids for new DBAs, access to servers, etc.
• Participated in the design, testing, and implementing specific database structural changes across all environments.
• Led team efforts for ESM (Enterprise Security Management ) audit and remediation setup and reporting.
• Participated in successful efforts to set enterprise wide standards for database design, deployment, backups, security and enforcement of Best Practices and DB Standards as per industry standards.
• Lead DBA for implementing and configuring databases on standardized CUE (Common Utility Environment) platforms for data center.
• Set up standby databases for Disaster Recovery requirements for business continuity; participated in regular disaster recovery exercises.
• Setup backup and recovery of databases utilizing RMAN and other methods; remediated older databases to comply with corporate standards.
• Performed performance tuning, trouble shooting and problem resolution as part of regular BAU.
• Performed basic installations on 11g database: Setting Up, Configuring Grid Control.
• Setup and configuration of Oracle Fusion middleware components to support OEM: WebLogic, OID, Name Server, OMS, SOA suite/ Oracle BPM Suite
• Maintenance and performance tuning using tools (OEM, Toad, Oracle Developer) as well as scripted methods (PL/SQL, shell scripts, SQL*Plus)
• Installation, maintenance and troubleshooting for MS SQL Server databases that interfaced with Oracle clients or servers.
• Production, development, certification and support environment: Oracle10g RAC, Oracle9i,Oracle8i, Oracle7, Oracle9iAS, Oracle Designer, Oracle EBS, Oracle Jdeveloper, Oracle Enterprise Manager, Oracle Grid Control, JDBC, Java, Websphere, ODBC, AIX, Solaris, Korn shell, REXX, XML, MS SQL Server, WebLogic, TSM, EXADATA, SDLC .

Confidential

SR. ORACLE DBA/ANALYST

Responsibilities:

• Technology division of Confidential outsourced to IBM. Same duties as before with Confidential .
• Database Administrator for production, certification and development databases; duties included monitoring, backup and recovery, performance tuning, trouble shooting, database design and implementation, Oracle product installation, user and developer support, connectivity resolution, Oracle upgrades, patching, and configuration.
• Development and Application support for OLTP, web based, OLAP applications including stock brokerage management systems, loan reporting systems, check imaging and archiving, lockbox operations, fraud management, Seibel, international check collections, escheats, mortgage analysis, investment management, dashboard applications, CRM applications, Websphere, Vignette Server, Pega Systems.
• Developed enterprise wide database security architecture consisting of modules and protocols to enforce IT standards for password management, role-based security and privileges, programmatic access (via PL/SQL packages, functions and procedures) to database meta data via common API.
• Helped maintain and implement Oracle Names Server for Oracle database naming resolution and database connectivity trouble shooting.
• One of the principal authors of many utility SQL and shell programs for use by DBA staff; principal author of majority of Treasury ISS department documentation.
• Installation, configuration and management of system based monitoring tools: Oracle OEM, Tivoli (Tivoli Storage Manager), various Quest products ( I-Watch, Navigator, etc.) and application and web servers:Websphere, Oracle9iAS, Story Server, Vignette, Netscape Server, iPlanet and database software.
• Data modeling and design of databases using Erwin and Oracle Designer; databases included OLTP and data warehouses.
• Production, development, certification and support environment: Oracle9i,Oracle8i, Oracle7, Oracle9iAS, Oracle10g, Oracle Designer, Oracle Jdeveloper, Oracle Enterprise Manager, JDBC, Java, SDLC, WebSphere, ODBC, AIX, Solaris 2.8, Korn shell, REXX, MS SQL Server, Sybase Server and Sybase Watcom, XML, EXADATA.

Confidential

SR. DATABASE CONSULTANT

Responsibilities:

• Analysis, design and implementation of a distributed database for a network service provider to improve global network management and reporting.
• Analysis, requirements gathering, data modeling, database design and implementation.
• Development and support environment: Client/Server architecture; Oracle8 (Parallel, Distributed And Enterprise Edition) Server Rdbms, Oracle Tools, Oracle Enterprise Manager, SQL*Loader, SQL*Plus, Pl/SQL, Server Manager, Oracle Oci, Pro*C, Developer 2000, Discoverer 2000, Designer 2000, Erwin Erx, Net 8 (SQL*Net), Windows 95/Nt, Solaris 2.6