JEEVAN KUMAR GUZZARLAMUDI

adldpj@r.postjobfree.com

610-***-**** (cell)

At preset working as Software Engineering Release Coordinator and taking care of Change tickets and Releases of Walgreens. We are supporting Two Scrum Masters following scrum procedures for four applications and managing Change, Incident and JIRA tickets. We also have in-house software tools which we use to manage releases and change processes.

Summary:

Over All 23 years of IT experience, of which and more than 20 years as Sybase DBA in USA, Sybase System administrator, Sybase Replication Server DBA. Have excellent analytical and communication skills to manage projects. I was involved in logical and physical database modeling and performance and tuning skills.

Over 14 years working as Senior Database Specialist at Voya Financial Services (ING Financial) located at West Chester PA. I have migrated Sybase ASE 11.9.2 to 12.5 in Windows environment in 2005, designed replication environment in 2006, Migrated Windows environment to Linux environment in 2009 also migrated version of Sybase ASE from 12.5 to 15.0.3 and in 2015 Migrated Sybase from 15.03 to 15.7 sp139 and Sybase replication 15.7.2, and we have migrated few servers to 16.0. In August 2019. Also worked on Building Oracle Exadata databases on Linux servers.

TECHNICAL SKILLS:

HARDWARE: HP x86_64 GNU/Linux Physical and Virtual servers; Sun Sparc, IBM Server,

Operating System: Red Hat Enterprise Linux Server release 6.9, Sun Solaris 5.8, Windows 2012 Server.

Languages: Dbase IV, FoxPro 2.0/2.6, C, T-SQL and MS Access 2000.

RDBMS

Sybase System 10/11/11.5/11.9.2.2/12.0/12.5.3, 15.0.3, 15.7 sp139, 16.0

Oracle Enterprise Server 7.1, 8.1.6, 8.1.7, 9.2, 12.01

MS SQL Server 6.5/7.0/2000, 2008

Development Tools Sybase, TSQL, Sybase Central, Platinum Desktop DBA (Sybase front end DBA tools), Embarcadero DB Artisan 4.0, 5.1, 5.3,5.4, 9.6.1, Pro Active DBA, Platinum Erwin, Oracle, PL/SQL 3.0, Database Administration Tools, Power Builder 4.0/6.5.

Service now: for creating Incident tickets, Change tickets, internal It Requests and also maintaining CMDB certifications.

Foglight: This is a Quest Tool for server alerts and crating Database server performance reports

Has extensive experience in database design & implementation, development, administration and maintenance of Sybase databases under Unix Platforms (Sun Solaris on Sun Sparc, HP-UX on HP machines, good working knowledge of HP-UX, SCO-Unix, Digital Unix, Windows NT server, Win 2000), Windows 95/98, Windows 2007,Windows 10 . Writing scripts in Korn shell.

Areas of Strength in SAP ASE:

SAP ASE DBA Activities, creating Devices and Databases, performance, Turning of Sybase SQL Server. Used Erwin Data Designer Tool extensively for Logical and Physical data designer, writing stored procedures and triggers, well conversant with all Sybase command language from ISQL prompt, Power Builder Programming, Implementation of Application modules like, Purchase Order Generation, Branch Sales, Raw Material Management System, Financial Accounting, Fixed Deposits, Housing Loans (Mortgage), Real Estate Business, Human Resource Development, Engineering & Sourcing. Also has knowledge of Credit derivatives applications. Most of the applications, which I supported, are based on OO, web based applications like Java, C++.

Excellent knowledge of Sybase architecture including physical and memory structures.

Install and Configure Sybase SQL Server (ASE) on Linux, Sun Solaris.

Installing and configuring Sybase Replication Server 12.6, 15.2, 15.7.1 on Windows 2013 and Linux servers

Sybase Database Server Upgrades with multiple versions. Sybase ASE Migrations.

Can handle independently all the projects and critical server problems.

Can configure and work on Component integration services.

Installing Power Builder 8.0 on NT & 2000 Servers.

Controlling and allocating disk resources, Capacity Planning for Very Large Databases.

24/7 Production Support from Home and Work.

Setting up of Backup Procedures

Monitoring, tuning and trouble shooting,

Manage replication servers in distributed database environment.

Regular backups of Database and Transaction Logs

Disaster Recovery of Production Databases & Logs, Rebuilding of Master Database.

Crash recovery management through standby databases.

Deeply involved in Tuning applications for excellent performance.

Daily Monitoring of Sybase SQL server for space usage, integrity, performance.

Creating/Maintaining Indexes

Has very good knowledge of Writing shell scripts korn shell.

Sybase Capacity planning/Management.

Sybase production/release management.

Areas of Strength In Oracle:

Installing oracle software on Windows 2008 servers, Sun Solaris and Linux servers

Updating Oracle Patches,

Installing Oracle cluster servers on NT and Win 2000 Servers (Fail Safe)

Oracle 8.1.7.30, 9i on Sun Solaris systems, maintaining Production, Test and Development applications.

Creating Instances, schemas,

Creating users for better security,

Creating table’s spaces, rollback segments.

Table sizing for accurate storage.

Tuning and monitoring Oracle Server

24/7 production support.

Has excellent knowledge in Configuring Servers for performance issues.

PROFESSIONAL EXPERIENCE:

1. Working as Release Coordinator – for Release Management

Client : Walgreens

Duration : August 20th 2020 till date

Environment : BMC Remedy, Smart IT, JIRA

Production application, Data and infrastructure applications, Development and Sys Test environments

Covering multiple application for 2 Scrum Masters

Scrum Team size: 8, 1 on shore and 1 offshore Release Coordinators

At present working as a Release coordinator covering multiple application and multiple environments. We also have in-house software tools which we use to manage releases and change processes. We process Data changes, Infrastructure changes and Application changes, to make sure all change processes are in place so that Release event won’t bring down applications and Servers.

2. Working as Team lead for Change Management/ Release Management

Client : MetLife

Duration : January 17th 2020 till date

Environment : Service Now, Roster

Production application, Data and infrastructure applications

Covering 64 applications for MetLife.

Release Team size: 6 Release coordinators

At preset working as Software Engineering Release Coordinator and taking care of Change tickets and Releases of MetLife. Working as Team lead and from onshore. We are supporting for 64 MetLife applications and managing change tickets in Service now tool. We also have in-house software tools which we use to manage releases and change processes. We process Data changes, Infrastructure changes and Application changes, to make sure all change processes are in place so that Release event won’t bring down applications and Servers.

3. Senior Database Specialist:

Client: Voya Financial, West Chester, PA.

Duration May 23rd 2005 – October 2019 (14 years 5 months)

Environment: Sybase ASE 12.0/12.5.0.3,15.0.3, 15.7 SP139 Sybase Replication 12.6,15.2, RS 15.7.1 sp202 On HP Itanium 64bit, MS SQL Server 2008 On Windows 2008 Servers. Linux 64 bit Physical Servers and also Virtual Servers

DBA Team Size: Eight

DB Artisan 9.6.1, Sybase Central.

Working as a Sybase ASE and Sybase Replication Server Database Administrator for Installing and Configuring servers, Creating Databases, Segments, upgraded several servers from Sybase ASE 12.5 to 15.0.3 and from Sybase 15.03 to SAP ASE 15.5 and SAP ASE 15.7 sp139 version. At present Migrating from SAP ASE 15.7 to SAP ASE 16.0 Monitoring and performance tuning of servers and databases also tuning stored procedures and triggers, setting up User Security & System standards, extending Databases and writing scripts, participated in Supporting Developers for writing queries.

I designed Replication environment for Voya Financial (former ING retail annuities) and implemented successfully.

Role: Senior Sybase Database admin. As a senior person, I am the first one to be contacted for all Production issues, I am the one to take decisions what needs to be done and suggest other dba’s technical procedures.

Projects handled in Voya Financial

1)Verify DR servers are Valid, and Up and running all the time

This project includes Oracle, Sybase, DB2 and MS SQL server environments

Frame based replication, and Sybase replication for Sybase. Frame based replication, flash copy and Golden gate for oracle

2)Verify net backups are valid or not

This project includes Oracle, Sybase, DB2 and MS SQL server environments

3)Verify Backups are valid or not

This project includes Oracle, Sybase, DB2 and MS SQL server environments

4. Database Administrator:

Client: Reuters America, Saint Louis, MO.

Duration Nov 2005 to March 2005

Environment: Sybase ASE 12.0/12.5.0.3, Sybase Replication 12.0/12.5, On HPUX E 9000, MS SQL Server 7.0,2000 On Windows NT and Windows 2000 servers.

DBA Team Size: Five

DBArtisan, Sybase Central, SQL Advantage, Vantive, Clear quest ECM Tool

Working as a Sybase ASE & MS SQL Server Database Administrator for Installing and Configuring servers, Creating Databases, Segments, upgraded several servers from 12.0 to 12.5 version, Monitoring and performance tuning of servers and databases also tuning stored procedures and triggers, setting up User Security & System standards, extending Databases, writing scripts. Actively participated in Supporting Developers for writing queries for Vantive, MIS and Work order process applications. Actively involved in Monitoring Replication Severs and Overnight replication process in MS SQL Server. I have installed and configured Sybase 12.5.0.3 ASE servers for Vantive and MIS Applications, supported Development, UAT and Production servers, set up procedures for refreshing databases and database dumps. Frequently providing on call DBA support from Home and working from Office for MIS, Vantive and Work order processing projects which have very tight deadlines

5. Sybase Database Administrator:

Client: Freddie Mac, McLean, VA.

Duration Aug 2003 to Nov 2004

Environment: Sybase ASE 12.0/12.5.0.3, Sybase Replication 12.0/12.5, On Sun Solaris, Sql Backtrack 4.4.

Loan Prospector Team Size: Seven

Close the Books Team size: Ten

DBArtisan 7.0/8.0, Autosys scheduling tool, Vantive, Db server, Clear quest ECM Tool

Working as a Sybase ASE Database Administrator for Installing and Configuring servers, Creating Databases, Segments, upgraded several servers from 12.0 to 12.5 version, Monitoring and performance tuning of servers and databases, setting up User Security & System standards, extending Databases, writing scripts and Jill files for automating jobs in Autosys scheduler. Actively participated in table purge process, since tables are growing at a very large rate in Loan prospector group. Also actively involved in supporting warm standby replication servers. I have installed and configured Sybase 12.5.0.3 ASE servers for close the books group, supported Development, UAT and Production servers, set up procedures for snapshots, logical dumps and loads, and refreshing databases. Frequently providing Oncall DBA support from Home and working at EOC for CTB projects which have very tight deadlines

6. Database Administrator:

Client: G M A, Bethlehem, PA.

Duration January 2002 – July 2002

Environment Oracle 8.1.7.3.0, 9.2.0.1.0 on Windows NT Server

Team Size Seven

DBArtisan 5.4, Oracle 8i, Oracle Enterprise Manager, DBA Studio, PL/SQL,

Worked as a Sybase ASE and Oracle system administrator and DBA for Installing and configuring servers, Creating Databases, Segments, Upgrading Servers, Monitoring and performance tuning of databases, Setting up User Security & System standards, extending Databases, writing scripts for automating jobs in crontab. Out of 22 servers 15 servers were Sybase Servers. I installed Replication 12.0 servers for warm standby applications. I maintained Both Windows NT & Sun Solaris servers. Daily Monitoring Servers for Space usage and Performance. I was supporting application for Developers, Changes in Production OLTP Databases. At this client I have handled up to 25 GB databases. Running queries for Benchmarking to get good performance, Modifying Procedures for better performance, taking show plans for problem queries. Writing C shell and corn shell scripts.

7. Database Administrator:

Client: G E Power Systems, Schenectady, NY.

Duration January 2001 – December 2001

Environment Sybase ASE 11.9.2.2 - 32 bit, Sybase Gateways, Sybase Client, ISQL, TSQL & Oracle 8I & 8.1.6,Windows NT Server, SUN Solaris 5.6, 5.7 (Sun Sparc 4000, 3500 up to 6 processors), Veritas Backup Server. Writing procedures & triggers

Team Size FIFTEEN

Sun Sparc 4000,Sun Sparc E3500, Sun Solaris 5.6,IBM ThinkPad, Windows 98, Sybase ASE 11.5.1, 11.9.2.2, Sybase Direct Connect GATEWAYS, Sybase Central, Sybase SQL Advantage, DBArtisan 5.3, Oracle 8I, PL/Sql., Erwin Designer tool for data modeling. Veritas Backup Server for backups.

Worked as Sybase and Oracle DBA support for production and Test Applications. Worked on Loading databases from prod to test, extending segments. Writing shell scripts for putting in cron jobs. Daily Monitoring Sql servers for Space usage and Performance. Testing Queries for benching marking. Supporting application Developers, Changes in Production Databases, Disaster recovery of production databases, giving gateway connections and managing Sybase Direct Connect server. I was involved in Setting up backup procedure for Hot and cold backups. At this client I handled up to 16 GB databases, each server has more than 20 databases.

Migrating data and procedures from Test to QA and QA to Production servers, Sybase servers Migration and Installations. Whenever we change OS up gradations we also migrated Sybase several times.

8. Database Administrator:

Client: Thomson Financial Services. Boston, MA.

Duration: July 2000 – October 2000

Environment: Sybase ASE 11.5, 11.9.2, 12.0, TSQL, ISQL, MS- Windows NT, SUN Solaris 5.7 (Sun Sparc up to 6), Power Builder 6.0,

Team Size: Five

Responsible for the maintenance of 10 servers, 34 Databases including Production, Warehousing, Ftp server, Site servers, maintaining Replication Server 12.0. Responsible for updating Archive database through stored procedures, Sybase Migration, maintained up to 2500 users, writing Unix shell scripts and keeping them in Cron jobs, tuning & monitoring SQL servers, creating, loading & extending databases, creating segments and placing objects on segments & data migration. I was involved in Maintaining Brokerage applications and Credit derivative applications.

9. Database Administrator:

Client: Aetna Inc., Hartford, CT.

Duration March 2000 - June 2000

Environment Sybase System 11.5.1.1, ISQL, TSQL, Sybase Omni Connect, Sybase open client, MS- Windows NT, SUN, Korn shell scripts Solaris 5.6 (Sun Sparc up to 14 processors),

Team Size SIX

I was Responsible for the maintenance of 10 Servers 30 databases including Test, QA and production. At this client I handled up to 37 GB production databases. I installed 3 production databases, including Pension New Business, Massachusetts Payroll, and Omni Plan Install. Primarily responsible for creating databases, tuning the database, monitoring the servers, extending databases, data migration, stored procedures, Wrote several shell korn scripts, Perl scripts for Mellon data application, tuning and users’ creation. Also maintained one replicated database for Remote enrollment project. I wrote several triggers to maintain History database.

10. Database Administrator

Client AT & T Prepaid Technology, Dublin, OH

Duration October 1999 – Jan 2000

Environment: Sybase ASE 11.5, TSQL, ISQL, MSSQL SERVER 7.0, Windows NT, Dec 4.0, Platinum Desktop DBA tool, Sybase Central.

Team Size Three

Responsible for maintenance of 3 servers 10 databases including development, Test, Production and Data warehouse databases. I was maintaining 225 GB database on Data Warehouse server, and up to 172 GB databases on production server. Includes production changes, Tuning and Monitoring of SQL Servers, extending databases, data migration, migrating databases from test to QA and QA to Production, performance turning of sql servers. Writing procedures & triggers, Modifying queries for production updates.

11. Programmer - Database Administrator:

Fixed Deposits - Financial Accounting - Branch Sales Computerization - Raw Material Management System, Bills discounting & H R Management. Recurring Deposits and Fixed Deposits Branch Modules

Client: Pennar Group of industries, Hyderabad, India.

Duration Oct 95 - Aug.99

Environment MS- Windows 95, LAN Work Place v-5, SCO UNIX 3.5

Sybase System 10.0, Replication Server 10, TSQL, ISQL, Power Builder 4.0/5.0/6.0 Enterprise Version, IBM Pc Server 320, HP 9000, Pentium 120

Oracle 7.1, Delphi v 1.0, Windows 3.11

Team Size FOUR

Installing Unix & Sybase Database Server, creating raw partitions, creation devices, creating databases, creating segments for placing specific objects, involved in designing of this application in power designer, tuning server for this application, memory allocations. Installing Power Builder, Sybase Client, LAN Work Place, and setting up ODBC Drivers for connectivity, setting up backup procedures for this application. Converting data from fox pro to Sybase through bcp tool. I wrote several shell scripts to monitor the servers, and also to monitor databases and segments.

I was fully involved in Migrating Sight Draft application (Database) from Sybase 11.0 to Oracle 7.3, I migrated all tables using BCP tool in Sybase and SQL Loader in Oracle. All other objected I created manually.

Education:

M.A. - Public Administration.

Post Graduate Diploma in Software Technology & Certificate in Computing

Contact this candidate