Sr SQL Server DBA/Developer

SUMMARY OF QUALIFICATIONS:

 Dedicated DBA Manager with 18 years DBA experience on multiple UNIX platforms (AIX, Solaris, Linux, HP-UX), Windows and Open VMS with Oracle 10gR2 RAC, DataGuard, ASM and RMAN.

 Managed a team of 10+ DBAs, and a database development team of 15 developers. Good history of bringing the DBA team, IS team and IT team to enhance the productivity.

 Instrumental for the DBA team to create and follow best practices, database standards and standard operating procures, which in turn reduces the mistakes and conflicts in the team.

 Responsible for managing the DBA team to work effectively in a business-critical production environment and in 7x 24 support.

 Directed the team to implement proactive database monitoring, and automation of database maintenance, daily AWR reports, databases repots & regular database operation tasks.

 Grouped the scattered DBA team into one Operational DBA team and Development DBA team for cost saving and for consistent results.

 Knowledgeable and hands on experience in Oracle 10gR2 RAC implementation, RMAN backup/recovery Strategies, Data Guard implementation, ASM file system, Load Balancing , TAF, Oracle Grid control implementation.

 Steered the DBA team towards optimal logical and physical database design, and effective capacity planning.

 Kept the team on track with regular DBA activities like database upgrades, applying patches, data model changes, new database server setup, backup/recovery, and security administration.

 Mentored the DBA team and database development team in Database tuning, SQL tuning and problem solving using Grid and AWR reports.

 Effective leader in implementing multiple projects on schedule by hiring right resources, allocating the resource, team motivation and accountability.

 Worked well with teams by earning their trust, and appraising the upper management.

 Achieved the SOX/PCI security compliance for all financial databases.

 Worked well with technology partners like Oracle, Hitachi and IBM to understand the new features and made lot of judgment calls on their recommendation.

 Expertise in SAN Disks, Solid State Disks(SSD),OS specifics, Database Servers and Database features to optimize the performance of the Databases and for better utilization of technology.

 Experience includes very large databases (VLDB), AIX CIO file systems, VERITAS file Systems, Veritas Netbackup, IBM Tivoli Storage Manager(TSM), and job scheduling tools like TWS.

 Worked on relational and dimensional modeling and managed OLTP and data warehouse databases.

 Working Knowledge on Oracle database and their various option licensing.

 Not afraid to rollup the sleeves and get hands dirty on DBA side, if needed.

 Strong background in managing a large project with many DBAs and developers in a disciplined software development cycle (SDLC) process.

EDUCATION AND TRAINING:

B.S (Honors) in Computer Science and Engineering.

Trained in Oracle database and application performance tuning.

Went through multiple Franklin Covey Leadership training like Great leaders, Crucial conversations.

RESIDENTIAL STATUS: U.S. Citizen

TECHNICAL EXPERTISE

Hardware:

IBM P-595 Servers, IBM-750s, SUN SPARC/5500/5000/10000, HP DL380 Servers, DEC-ALPHA/2100, DEC-ALPHA/4100 Clusters, HP-9000/V class, WIPRO Super-mini system (UNIX), Pentium PC’s and UNISYS A-series.

Operating Systems:

AIX 5.3/6.1, Solaris 10/8. Red hat Linux 4.0, HP-UX, Digital UNIX (OSF), DG/UX, SCO-UNIX, OPEN VMS, and WINDOWS

Software:

ORACLE 10g/9i/8i/7.x, Real Application Clusters (RAC), PL/SQL, Pro*C, C, Data guard, RMAN, Grid control, ASM, ORACLE Utilities (SQL*Loader, Import/Export), SQL*Net, Oracle Enterprise Manager (OEM), Tivoli Storage Manager(TSM), TWS, VERITAS Net backup, Veritas File System, TOAD, Shell programming (ksh & bsh), VB.Net, Java, Weblogic, Oracle Fusion, Jdeveloper, Developer/2000(Forms 4.0 & 4.5, Reports 2.5), Oracle Financials, Oracle Manufacturing, Perl, MS SQL server 6.5/7.0/2000,and Informatica Power Center

PROFESSIONAL EXPERIENCE

Alliance Data Systems, Irving TX Jul 2003 – Jul 2010

Loyalty Marketing Systems(Citi/Wachovia/Hilton/La Quinta/NMSS)

Technical Director/DBA Manager

• Effetely managed the multiple DBA resources and Database resources for various projects in Loyalty business of Alliance data to implement multiple projects on time.

• Instrumental in directing the DBA team in setting up and managing RAC databases and Data Guard instances to increase high availability and scalability. Eliminating IBM tru-copy and HACMP attributed to cost saving.

• Bridged IT Infrastructure team , IS and DBA team to work together for better results on multiple project implementations.

• Helped the DBA team on optimal Physical Database disk layout, I/O balancing, OS striping (RAID 5, 10), SAN,SSD, database partition strategy, etc for better Database solutions.

• Mentored and worked with the team on Database tuning, SQL tuning, OS tuning and IO tuning for better performance on the system.

• Instrumental in creating the backup/recovery and Disaster recovery strategies and helped the DBA team to follow them.

• Managed the DBA team to adhere the standard operating procedures, database standards best practices and published them in SharePoint location, which in turn produced consistent results.

• Keep updating the knowledge in latest technologies of Database Servers, SAN arrays, Database features and provided the right direction for better cost effective solutions.

• Tracked the team on regular DBA activities like database upgrades, applying patches, data model changes, new database server setup, backup/recovery, 7 x 24 support, on-call rotation and security administration.

• Hands on experience in Oracle RAC, OLTP, Data warehouse, Very large Databases(VLDB), Data Guard, RMAN backup/Recovery, Grid Control, SQL tuning, PL/SQL, and Shell scripts.

• DBA team implemented proactive database monitoring, daily database reports, AWR reports, database maintenance jobs under my supervision.

• Responsible for the DBA team to get Sarbanes-Oxley (SOX) and PCI compliance, and for satisfying SLAs.

• Involved in hiring/firing, identifying the leaders and grooming them, providing training to the individuals in technology and Management, conflict management, maintain the morale of the team and keeping the accountably on each individual in the team.

• Managed multiple OLTP and Data warehouse databases of size range from 1 TB to 5TB.

Environment:

IBM P-595/P750 AIX servers, HP DL380 Linux Servers SUN SPARC/6500/V880, Hitachi AMS2500/V9960 SAN Arrays, Oracle 8i/9i/10gR2 RAC, Oracle Grid Control, Data Guard, Ab Initio, SQL*Loader, PL/SQL, SQL, Java, J2EE, Weblogic, Oracle Fusion, VB.Net, ASP.Net, ASM/CIO/Veritas File systems, RMAN, Toad, Cognos, Unica Affinium Campaigns, Oracle Data encryption(Crypto), SSL, and XML web services.

OTHER PROFESSIONAL EXPERIENCE

1. Arch Wireless, Inc. Plano, TX Dec 2002 – Jun 2003

Site Information and Licensing System

Lead Oracle DBA/Database Architect

2. TXU, Inc. Dallas, TX Sep 2002 – Nov 2002

Customer Billing System/ (CRM)/Data warehouse Management Systems

Senior Oracle DB/Performance tuning Consultant

3. The Container Store Inc, Dallas, TX Sep1998 – Sep 2002

Merchandise Management System / Warehouse Management System/

Points of Sale System/Web Store system

Lead Oracle DBA

4. SABRE Group, inc. Dallas, TX Aug 1997 - Aug 1998

Forecasting System

Senior Oracle DBA/Consultant

5. Ameritech Communications, Inc, Chicago, IL Mar 1997 - Jul 1997

Cost and Revenue Analysis System

Senior oracle DBA/Consultant

6. Caterpillar, Inc Peoria , IL Jul 1994 - Feb 1997

New Authoring Systems

Oracle DBA/Consultant

7. Commonwealth of Pennsylvania, Harrisburg, PA May 1992 - Jun 1994

Land Use Management System

Oracle Developer

REFERENCES

Available upon request

Contact this candidate