Effective professional skilled in developing cross-functional relationships and fostering communication between teams to maximize productivity. Leader with first-hand experience in roadmap planning, global resource planning, performance evaluations, and team calibrations. In-depth knowledge and experience in information technology infrastructure planning, capacity analysis, and system implementation. Solid skills in database administration in large-scale enterprise environments. Recognized authority in data analytics and go-to guy for technical expertise. Flexible with change and ready to identify and improve processes to meet new goals and objectives. Detail-oriented with excellent communication and interpersonal skills.

Qualification Highlights

PROFESSIONAL EXPERIENCE

Technical Director, IT Database Operations

Confidential

Directs the Database Operations Team, managing all corporate databases and database-related applications in a 24x7, fast-paced, high transaction volume environment.

Team Lead Senior Oracle Database Administrator

Confidential

• Managed global project resource allocations, participating in yearly roadmap planning and interlock sessions. Developed a project dashboard allowing the DBI DBA team better visibility of the life-cycle of each project and more effective resource planning, reporting status to senior management.
• Led various teams of global DBAs in Austin, India, and Brazil, closely working with DBA managers in EMEA and APJ regions to best utilize remote DBAs. Provided personnel assessments to senior management, participating in reviews and calibrations of Global DBA team members.
• As a member of the GDMS Security Council, worked closely with internal and external SOX auditors to ensure that databases were compliant with Dell's stringent security standards and policies.
• Managed global DBI change ticket resource allocations ensuring DBA staff awareness of and preparedness for upcoming production changes. Led weekly CT reviews and created a dashboard for presentation to senior management.
• n As a hands-on technical lead, duties included daily guidance and mentoring of DBA team members, sharing knowledge and ensuring best practices were followed with balanced sanity checks and ensuring smart use of latest technologies. Orchestrated and led efforts such as quarterly patching sessions, Dataguard switchover testing, and proactive maintenance sessions.
• Led virtualization, consolidation, and ELM efforts for DBI. Released 5TB of storage and numerous successful upgrades, migrations, and decommissions of database server hardware.
• Devised, planned, and led global effort to improve Oracle standards, advocated patching, and security compliance processes. This initiative ensures that global DBAs execute standard methods of implementation, measurement, and reporting of the 1500 production and non-production database servers. As a result of this initiative, advocated patch compliance has improved from 40 to nearly 100 globally across all business segments within a 6-month period.
• Developed methodology for refreshing database relevant data to TROUX for reporting of all database servers globally.
• Led DBI DBA team effort to migrate 8i, 9i, 10gR1 Oracle database systems to new hardware and latest 10g/11g standards.

Consultant Senior Oracle Database Administrator

Confidential

• Ensured data warehouse database availability, data integrity, performance/tuning, and problem troubleshooting and resolution Included 24x7 support including pager duty.
• Installed, configured, and administered Oracle 9i instances including the following: installing Oracle binaries and building initial instances, monitoring table space, backup/recovery, db reorganizations, performance tuning, data modeling, security, plsql, triggers, functions, and stored procedures.
• Cloned production database instances for use by QA and testing teams. Created and monitored logical/physical standby database instances.

Consultant Data Warehouse Architect / Senior Oracle Database Administrator

Confidential

• Led a data warehouse effort to migrate away from DataStage ETL processes which rarely met SLAs. Rewrote code using advanced Oracle PL/SQL programming, designing an entirely new architecture improving ETL processing runtimes by over 400 percent.
• Sanitized and corrected data either missing or incorrectly residing in the data warehouse through specialized PL/SQL scripting.
• Worked directly with data stewards and business managers to determine reporting needs facilitated business users in the migration of home-grown MS-Access databases and Excel spreadsheets to globally shared data stores within the data warehouse.
• Migrated data from a data dump into an enterprise ODS solution tuned for Business Objects.
• Worked with development teams to ensure the inclusion of data warehouse design in planning and implementation of their projects. Analyzed existing systems and new development to determine the use of or the need for new data warehouse data stores.

Team Lead Senior Oracle Database Administrator

Confidential

• Led the installation and configuration of Oracle 9i RAC on an AIX 5L cluster, utilizing EMC CLARiiON 4700 SAN, allowing load balancing and transparent failover of the GlobalAdvantage production apps.
• Led the migration of Oracle 7.3.4/8i databases from HPUX to Oracle 9i on Linux 7.3.
• Installed and configured Oracle Management Service OMS and intelligent agents to monitor Oracle 8i/9i instances. Implemented an OEM Repository to track events and manage alerts.
• Installed, configured, and administered Oracle 8i/9i instances including the following: installing Oracle binaries and building initial instances, monitoring table space, backup/recovery, db reorganizations, performance tuning, data modeling, security, plsql, triggers, functions, and stored procedures.
• Developed and maintained methodologies to support the implementation of client databases. This involved writing specialized SQL scripts to manipulate and cleanse client data prior to loading.
• Wrote and maintained kornshell scripts to automate daily tasks: refreshing daily replicas of production schemas for troubleshooting client issues scanning for errors in trace logs database migrations supporting application builds laptop database loads for client demos
• Monitored production databases ensuring data integrity and 24x7 database availability.

Team Lead Senior Oracle Database

Confidential

• Analyzed and corrected performance related issues pertaining to Warehouse Management System databases and transportation system databases including db reorganizations and SQL tuning.
• Administered Oracle instances including the following: monitoring table space, backup/recovery, performance tuning, security, plsql, and stored procedures.
• Monitored production databases ensuring data integrity and 24x7 database availability.

Oracle Database Administrator

Confidential

• Installed, configured and administered Oracle8i instances in a Sun Solaris environment this included monitoring table space, backup/recovery, performance tuning, data modeling, security, plsql, and stored procedures.
• Developed system to load production audit data into base tables for creation of historical, marketing, and distribution summary tables and reports. Also included archival of data for future processing. This was to be the baseline for a future data warehouse.
• Wrote numerous kornshell scripts to aide in daily price/availability updates for partner merchants, backup/recovery, scheduled reports, staging of production data, and data replication.
• Supported Java, C , sql, and XML developers, testers, quality assurance, and helpdesk personnel ensuring data integrity and availability of Oracle databases through all phases of software development life-cycle.

Database Administrator

onfidential

• Installed, configured, and administered Oracle, Sybase, CA-IDMS, and MS SQL Server databases. Supported COBOL and PowerBuilder developers, testers, helpdesk personnel through all phases of software development life-cycle.
• Led the upgrade of the Greyhound Revenue System CA-IDMS database from V10.2 to V12.0 and then to V14.0. Involved a major cleanup of the database including deletion of over 50 of the logical and physical records and ADS/Online code including maps.
• Ensured year 2000 compliance of all database systems software. Provided technical support for year 2000 remediation efforts and compliance testing including date aging.

Systems Engineer

Confidential

• Led the development, installation, and configuration of Windows NT 4.0 Servers in a heterogeneous Novell 4.11/Windows NT 4.0 Network Operating System to replace legacy AIX systems. This included the implementation of a standard Windows NT 4.0 client configuration to upgrade over 800 Windows 3.11 desktop and mobile client workstations.
• Provided configuration and maintenance of data communications equipment in direct worldwide travel support of the President of the United States, White House, and National Security Council.

Team Lead Database

Confidential

• Led a team of DBAs ensuring the availability and integrity of the War Planning databases IDMS and Sybase valued in excess of 1.2 billion. Upgraded all production and development CA-IDMS databases running on IBM-MVS servers from V10.2 to V12.0.
• Installed, configured, and administered Sybase databases including the management of physical resources, logins, and user permissions. Automated Sybase database backups using SQL-Backtrack and ADSM with legacy system's tape silos.

TECHNICAL SKILLS / KEYWORDS

• RDBMS Oracle, Sybase, MS SQL Server, IDMS, Data Warehousing, ETL, CRS, RAC, ASM, ASSM, OLTP, DSS
• UNIX operating systems Sun, HP-UX, AIX, Linux , Novell NetWare, Windows, IBM-MVS
• LAN, WAN, TCP/IP, HTTP, FTP/SFTP, IPX/SPX
• EMC Clariion, Symmetrix , Equalogic, Legato, Backup-Exec, CA ARCServe
• Tools: Borne/Korn Shell ksh , sh, ssh, sed, awk, tar, SQL, PLSQL, imp/exp, impdp/expdp, lsnrctl, emctl, srvctl, dbca, dbua, dbconsole, dgmgrl Dataguard Broker , rman, sqlloader, smit ty , bcp, dbcc, ispf, clist, ads/o, TOAD, DBArtisan, Citrix, SourceSafe, cvs, pvcs tracker, InfoRouter, SQL Navigator, Power Builder, DataStage, Exceed, WinRunner, Transparent Gateways