Sql Server Database Administrator

Rajesh K. Adapa

*******@*****.***

Mobile +1-309-***-****

SUMMARY

Experienced Database Administrator with expertise across multiple platforms including DB2-LUW (UDB), DB2 on z/OS (mainframes), MS SQL Server High Availability, Netezza, Teradata, Sybase, PostgreSQL and PeopleSoft (Oracle). Proficient in managing IBM WebSphere (Portal) and Tivoli Identity Access Management (TIM/TAM). Responsibilities include support for DB2 z/OS-OS/390, DB2 UDB on AIX, and MS SQL Server HA systems. Skilled in designing technical specifications to guide programming teams and ensure a high-quality product.

Proficient in Database Management and Operations across DB2/PeopleSoft for Z Series (formerly MVS/mainframes), DB2 UDB for NT and AIX. Capabilities include database design, data modeling, performance monitoring, installation, migration, and configuration of UDB databases and instances (HADR, Load, Export/Import, DB2 move). Expertise in data replication and performance optimization using DB2 Performance Monitors, System Snapshots, Event Monitors, and Explaining Tools. Demonstrated strength in logical and physical database design.

Strong Background in System Operations on OS/390-z/OS within IBM Mainframe environments, with comprehensive knowledge in JCL.

Lead Conversion Projects involving database transitions from Sybase to DB2, Teradata to Netezza, and within various DB2 configurations. Tasks included creating and altering tablespaces, tables, indexes, and managing Bind Plan/Packages. Proficient in database privileges management, reorganization, repair, recovery, and conducting image copy, Runstats, restore, and backups across all supported database platforms.

Extensive Experience with MS SQL Server—installing, configuring, monitoring, maintaining, backing up, restoring, upgrading, and securing databases. Skilled in managing database clusters, replication, snapshots, mirroring, and log shipping. Responsible for production support and adept at quickly learning new technologies across any platform.

Industries Served:

Insurance, Healthcare, Financial, Consumer Goods, Communications, Hospitality, and Retail.

Functional Areas of Expertise:

Human Resources (HR), Finance (FIN), Customer Relationship Management (CRM), Enterprise Performance Management (EPM), IBM WebSphere Portal, Tivoli Security Systems, and Multi-Platform Database Management Systems (DBMS).

Methodologies:

Proficient in Agile, ITIL, Scrum, and Waterfall project management methodologies.

SKILLS PROFILE

Application Development Tools:

DataStage ETL, IBM WebSphere, C++

Application Packages:

PeopleSoft/Oracle EPM, CRM, FIN, HCM, Portal, People Tools, Tivoli Identity Access Management, IBM WebSphere Portal, STAT Tool

Databases / Database Tools:

DB2-z/OS, IMS, DB2 LUW (UDB), Oracle on Solaris, Teradata, Netezza, MS SQL Server (2000 through 2022HA), Quest/Toad/Spotlight/Fog Light, IBM Data Studio

Desktop Tools:

Microsoft Office Suite, Quest/Toad, Spotlight, Fog Light, WINSQL, Nexus, TSO/ISPF, SQL Sentry

Hardware:

IBM 370, IBM Power 7 (AIX), Netezza, Microsoft Windows Servers (2000 through 2022 HA), VM Servers

Methodologies / Techniques:

Agile, ITIL, Scrum, Waterfall

Network Software / Communications:

FTP, SFTP, TCP/IP

Operating Systems:

DOS, Windows (3.1 through 10), Windows Server (NT, 2000 through 2022), Linux (Red Hat, SUSE), AIX, Unix, z/OS (Mainframes)

Programming Languages:

COBOL, C, C++, Shell scripting, T-SQL, SQL, PowerShell

Testing Tools:

HP LoadRunner, Mercury Interactive

Utilities / Command Languages:

JCL, QUEST/TOAD, IBM Utilities, BMC Utilities, Netezza, SQL Server Management Studio, PowerShell

Project Management Tools:

Microsoft Project

PROFESSIONAL EXPERIENCE

YUM BRANDS INC, 01/2006 - Present

Database Administrator – IT Shared Services (KFC, Pizza Hut, Taco Bell & The Habit Burger Grill)

Support the Microsoft SQL Servers/Databases on Azure and Microsoft Linux LPAR’s (DB2 LUW) on Azure for all Yum! IT Applications and Services

NTT DATA, INC. 08/2013 – 12/2018

Principal Consultant, Database Administration

Worked with two accounts – Yum (Retail/Hospitality) & National Life Group (Insurance Domain)

YUM! BRANDS INC. (PIZZA HUT, KFC, TACO BELL) RETAIL/HOSPITALITY

Supporting Databases for All Yum! IT Applications and Services

Production Database Support: Proficient in supporting critical production databases; extensive experience in 24/7 production support, development, and migration across multiple platforms including PostgreSQL, DB2 on UDB, DB2 on z/OS, and MS SQL Server HA.

Data Center Migration: Administered DBA activities associated with relocating hardware within the data center from Dallas to Louisville, covering all platforms.

System Updates: Applied fix packs on DB2 LUW on both AIX P5-P7 and Linux & AIX Servers, as well as service packs on SQL Server HA and APARs on DB2 – z/OS.

Database Migration: Spearheaded the migration from Teradata to Netezza DBMS, assuming the role of interim Netezza DBMS Administrator to support operations until a permanent DBA was onboarded.

Team Collaboration and Independence: Demonstrated capability to work effectively as both an independent contributor and a collaborative team member.

Security and Maintenance: Responsible for granting various authorizations and privileges to users, alongside proactive monitoring, and daily maintenance across diverse platforms.

Backup and Recovery Management: Ensured the maintenance of efficient and reliable backup and recovery routines; performed testing for daily, weekly, and monthly batch cycles across all platforms.

Database Design and Implementation: Actively involved in the design and implementation of database objects across multiple platforms.

SOA and IAM Support: Supported Service-Oriented Architecture (SOA), Tivoli Identity Access Management, IBM WebSphere Portal, and SQL Server HA residing ETL instances, databases, and applications.

Issue Resolution and Batch Job Management: Investigated and resolved complex technical issues, designed, tested, and scheduled batch jobs on all supported platforms.

Test Environment and Data Management: Created and managed test environments for new databases, populated these databases with data sourced from various production files, and resolved space-related issues.

Environment: DB2 LUW 8.2,9.7, DB2 9.1 Z/OS, Netezza, Teradata, MS SQL Server 2000 /2005 /2008 /2008R2 /2012 /2014 /2016 /2019 /2022 HA – SQL Century for MS SQL Server Instances, AIX 5.1,6.1, 7.1, z/OS 1.4, JCL, Quest/Toad/Spotlight/Fog light, Peoplesoft EPM, CRM, Portal, FIN & HCM

Shands @ University of Florida & Nextel/Sprint Reston Virginia – Clients - 06/1998 – 12/2005

Database Administrator /PeopleSoft Admin

Supporting PeopleSoft Environments for HCM, FIN, CRM, and Portal Modules

Database Cloning: Regularly cloned databases from Production to Development and Testing environments to ensure consistent, up-to-date test conditions.

Patch Management: Conducted patch analysis for database and application updates, including family packs and one-off patches. This included handling patches with extensive prerequisites.

Code Migration: Utilized the Quest STAT migration tool for efficient and reliable code migration across different environments.

Database Administration: Performed routine database administration tasks, monitored alert logs, and addressed space and object growth-related issues.

Oracle Applications System Administration: Managed concurrent programs and requests, application security, user registration, and the assignment of responsibilities within Oracle Applications.

Backup Management: Planned and managed database backups to ensure data integrity and availability.

Performance Monitoring and Troubleshooting: Analyzed trace and log files to identify and resolve potential problem areas. Continuously monitored and diagnosed database performance using alert and trace files.

Environment: People Tools 8.45, Fin 8.8, Data Mover, Web Logic 8.1, Application Engine, Integration Broker, SQR, Crystal, Oracle 9i on Sun

VARA TECHNOLOGIES INC

CONSULTANT FOR INSURANCE COMPANIES & FINANCIAL 07/1994 - 05/1998

Database Administrator /PeopleSoft Admin

PeopleSoft Module Installation and Support: Involved in the installation and support of PeopleSoft modules on various backend DBMS for multiple clients.

Module Configuration and Customization: Configured and customized PeopleSoft HRMS, Base Benefits, and Payroll modules. Successfully customized and tested records, panels, and menus to meet specific business requirements.

Report Development: Participated in the development and modification of custom PeopleSoft SQR reports. Utilized PS/Tools to execute new reports using the Process Scheduler.

System Configuration: Configured systems using Configuration Manager and set up client stations to ensure seamless operations.

Development and Security Management: Extensively used SQL, PeopleTools, Operator Security, and Tree Manager to develop new records, panels, menus, and process definitions. Wrote PeopleCode and utilized debugging techniques, including trace options, to troubleshoot and resolve errors.

Process Scheduler Management: Worked with the Process Scheduler to define and enable processes, allowing programs to run effectively within PeopleSoft.

Scripting and Automation: Developed scripts for data collection, FTP data transfer, disk space cleanup, and cron jobs, complete with detailed documentation.

Environment: People Tools 7.5 HRMS, FIN, DB2 6.1 on MVS(Mainframes), JCL, BMC/CA Utilities

Grade: A+Grade: Honors Diploma in Systems Management 1992-1994

Activities and societies: NIIT, Vijayawada, Andhra Pradesh, India.

Acharya Nagarjuna University - Bachelor’s Degree in science, The Hindu College bachelor’s degree in science, The Hindu college1988 - 1991

Contact this candidate