Support Management
Resume:
Naveen Kumar Reddy Daka
E-mail:******.********@*****.*** Mobile:908-***-****
Experience Summary
Total Exp: 11
Sybase: 11+
Replication: 9+ yrs
Sybase IQ: 3+ yrs
Sybase Database Administrator with rich experience of Database Administration, Database Upgrades, patching, Migrations, Tuning performance and HA/ Replication support. Proficient in SHELL scripts to write various wrapper scripts to automate DBA tasks and cater day-to-day requirements according to the Database/Application needs.
As a DBA, Involved, and Proficient and can be Responsible for:
-Production support for Day to Day issues like database backups/recovery, users/logins control, space management, auditing/security management, database consistency and performance tuning.
-Writing various Queries using T-SQL for Data Fixes, Checking Server/Database health/metrics.
-Provide recommendations and solutions on database and application performance, integrity, security and availability to management, development and production support teams.
Key Strengths:
Highly proficient Sybase ASE and RepServer Database Administrator for Installing, Upgrading and Configuring Sybase Server Products and documenting/updating the RUN-BOOKS.
An exemplary DB Professional experience in Tuning Performance which includes procedures and dynamic re-configuration for Server, Database and Memory.
Very proficient in Installing, Configuring, Maintaining and Monitoring Various Sybase DB products and tools and automate/schedule based on requirements.
Writing shell scripting knowledge.
Creating new indexes and altering existing indexes based on the requirement and metrics;
Monitors and manages database backups and logs; installs, maintains, and upgrades database software; restores and/or recovers data as required.
Database backup and recovery, precautionary tasks and plans for the disaster recovery.
Worked on Table level migrations using BCP and Sybase Replication Server.
Having good communication and interpersonal skills.
Having good problem solving skills, eager in learning and understanding new concepts.
R & D on various critical Issues to find best feasible solution and document the resolution.
Education Qualification
M.Sc IT from Sikkim Manipal University.
B.Sc in Computer Maintenance and Engineering from Loyola Academy with first division.
Intermediate from Sri Chaitanya Jr College with first division.
10th from Kendriya Vidyalaya Begumpet.
Skill set and Achievements
Database
Sybase ASE 12.5.x to 16.0 SP1, Sybase RepServer 12.6 to 15.7.x SP1, Sybase IQ 15.4, Expositor to Microsoft SQL
Operating Systems
Sun Solaris, Linux, Windows
Tools
Autosys, DBArtisan, Sybase Control Centre (SCC), Proactive DBA, SQL Developer
Scripting
T-SQL, SHELL
Certification
Certified in SAFe 4 Certified Practitioner
Spot Award for Taking ownership & solving issues on Asia PAC servers.
Spot Award for Good work done on Asia PAC and AMER (New York) servers.
Spot Award for providing assistance in fixing Singapore PRIV Project and resolving MS-SQL issues.
Professional – Project Experience
Meijer - IBM, Grand Rapids, MI
Duration Feb 2016 to till date
Technology Sybase ASE 16.0, 15.7, 15.5, Sybase Replication 15.7
Project Abstract
Supporting production, development and Test servers, ensure availability of production databases to end-users and development database to developers in a 24x7 environment.
Very proficient in UNIX Shell scripting. Wrote shell scripts for Database refresh and maintenance (reorg and update statistics). Improved lot of scripts to use latest features of Sybase 16 version.
Upgrade 20+ Sybase ASE 15.0 and 15.7 to Sybase ASE 16 SP01
Provided 24x7 production support via callout pager rotation.
Monitored the progress of DBA projects and resolved issues as needed.
Provided direction and coordination between the Production projects for all aspects of Database Operations.
Provided cost-effective database solutions to upper management, and was able to reduce costs considerably. Which include reviews licensing cost.
Mentored junior DBAs of the team for support functions such as documentation, validation, loading, administration, support and reporting.
Reverse engineered MS SQL database, and tuned performance and worked with developers to tune the code and managed the day-to-day operations, backup and recovery, DR exercises, Annual Audits, patches etc.,
Monitoring Server using SolarWind’s Database Performance Analyzer.
VortalSoft, (McKesson)
Duration Jun 2015 to Feb 2016
Technology Sybase ASE 15.7, 15.5, Sybase Replication & Sybase IQ 15.4
Project Abstract
Supporting production, development and UAT servers, ensure availability of production databases to end-users and development database to developers in a 24x7 environment.
Very proficient in UNIX Shell scripting.
Upgrade Sybase IQ 15.4 to Sybase IQ 16.
Monitoring ETL jobs for Sybase IQ.
Deploying new stored procedures to production environment.
Data extraction and loading from disparate sources into a Sybase IQ database for analytics.
Using load table feature for faster data load in Sybase IQ
Implemented IQ specific indexes and code optimizations(like bulk inserts and updates) for faster performance
Disaster recovery tests every quarter record the timelines and document the results, familiar with backup strategy and management of backup’s trouble shooting backup failures, familiar with taking backups to tapes.
User management, grant/revoke permissions to application users, password resets, account management, help installation of stored procs.
Database Refresh from Prod to Test and Prod to Dev.
Responsible for DB refreshing and recycle databases as per client request.
Monitored the database servers using Solarwinds Patrol on various aspects of database administration including disk space, availability, performance, and blocking etc.,
Implementation of Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
Wells Fargo, North Carolina, USA & India
Duration
March’ 2012 to May 2015
Technology
Sybase ASE 15.0.x to 15.7, Sybase Replication & Sybase IQ on Solaris and Linux.
As a Technical Lead for Sybase responsible for :-
Project Abstract
Supporting production, development and UAT servers, ensure availability of production databases to end-users and development database to developers in a 24x7 environment.
Monitoring and fine-tuning systems (It includes Database Tuning, ASE Tuning, Memory Tuning and Query Tuning) to support Online (OLTP) Users, Trading and daily reports for better performance.
Very proficient in UNIX Shell scripting.
Proficient in scheduling Jobs using UNIX cron.
The major responsibilities includes Advanced Performance tuning, Subject Matter Expert role, High Availability/Disaster Recovery selection and setup, Storage and Capacity management, Security and Audit remediation, Cost efficiency & Service improvement initiatives, Incident Management and RCA.
Migrating database into higher versions and tables into other servers.
Performance tuning of newly migrated/upgraded databases to utilize new features of the ASE 15.x effectively.
Proficient in automating all the Day-to-Day monitoring tasks.
Data extraction and loading from disparate sources into a Sybase IQ database for trade analytics.
Actively involved as one of the two member team who successfully delivered right from server building, data loading and table space design in Sybase IQ.
Using load table and insert location features for faster data load in Sybase IQ
Implemented IQ specific indexes and code optimizations(like bulk inserts and updates) for faster performance
Worked with SAP for a seamless up gradation of Sybase IQ 15.4 from Sybase IQ 15.0.
Proficient in Automating Database maintenance tasks and scripts.
In-depth knowledge of Sybase ASE architecture and internals, to understand the work load/environment and Fine-tune the Applications, Servers and Databases.
Disaster recovery tests every quarter record the timelines and document the results, familiar with backup strategy and management of backup’s trouble shooting backup failures, familiar with taking backups to tapes and TSM Backup.
User management, grant/revoke permissions to application users, password resets, account management, help installation of stored procs.
Automate jobs in cron by using shell scripts, debugging shells as per the changes from time to time.
To address the blockings on production servers by notifying application support team, help resolving deadlocks.
Management of space threshold on application databases, adding space to database backups, cache binding of tempdb.
Database Refresh from Prod to Test and Prod to Dev.
Responsible for DB refreshing and recycle databases as per client request.
Implementation of Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
Maintaining the database consistency with DBCC at regular intervals.
Rebuilding the indexes at regular intervals for better performance
Designed and implemented comprehensive Backup plan and disaster recovery.
Monitored and modified Performance using execution plans and Index tuning.
Expertise in Backup and Restoration of Database
Recovering the databases from backup in disasters
To analyze long running slow queries and tune the same to optimize application and system performance.
Involved in trouble shooting of database and application problems.
Performance tuning of server and application.
Monitoring replication to maintain database consistency between servers.
Worked on SYBASE to Oracle Migration using SQL Developer and prepared a POC for the same.
Society Generale Global Solution, India
Duration
Feb’ 2010 to Feb’ 2012
Technology
Sybase ASE 12.5.x to 15.x on Solaris and Linux.
Project Abstract
Sybase consultant providing migration support from ASE 12.5.x to ASE 15.x.
Providing L1 to L4 Support for the Sybase ASE, REP Servers and databases requires high availability and optimal performance.
Managing and maintaining for around 2000s of Sybase ASE, Replication servers, fixing issues on the fly based on the SLA.
Provide core database administration support in all aspects as relevant to production / development / UAT areas.
Monitoring work delivery mechanisms (chat channels, change systems and request systems) for incoming work.
Support alert/fault monitoring system and remediate the issues.
Provide early warning of impending capacity, availability & stability issues.
Building/upgrading Sybase / Sybase Replication servers, adhering to bank deployment and security standards.
Highly Proficient in Analyzing and implementing the new features, options and tools provided by Sybase Products latest versions while keeping the OLD functionality.
Coordinating & executing database outages/upgrades/migration as per planned/requested timelines.
Setup, maintain and execute disaster recovery solutions like physical standby database with/without data guard broker.
Assisting application teams to resolve performance issues when they arise, coordinating with cross-functional teams where appropriate.
Debugging infrastructure support scripts in case of issues or / for better management.
Positively contribute to meet team goals & exhibit ownership of deliverables.
Propose and/or participate in ongoing process improvement programs, automation projects.
Execute week-end planned tasks, coordinate global projects in functional domain.
Support, provide input to incident & problem management areas.
Support and Admin MSSQL servers too besides Sybase Servers.
Managing the jobs running on the various servers.
Vendor management to ensure the support for database related issues.
Optimizing the Servers, Databases and processes.
Documenting the Best practices and optimization techniques.
Stride IT Client
Duration Aug 2009 till Feb 2010
Client Societe Generale Global Solution, India
Technology
Sybase ASE 12.5.x to 15.x on Solaris and Linux.
Project Abstract
Worked with Stride IT for 6 months. My client was Societie Generale (As contract Employee) Paris.
Server level and query level performance & tuning for Sybase 12.5 and 15.5.
Automating the batch processes using UNIX shell scripting. Saved 10 BD manual work per month.
Doing analysis of sysmon and MDA tables to find the performance bottleneck and providing solutions.
Performed Perl scripting to create new logins from all Sybase Servers in Asia PAC servers.
Coordinating with offshore team for task assigned and providing deployment support during US working hours.
Creating and modifying the stored procedures as per the requirement.
Work with DBArtisan for various database related tasks.
CA scripting to scheduled job for the automation.
Sybase consultant providing migration support from ASE 12.5.x to ASE 15.x.
Successfully executed upgrade activity from ASE 12.5 to ASE 15.5 for all Sybase servers (Including production) used dump and load method for the same.
Successfully executed upgrade for 5 Sybase servers which are having 15 databases including UAT, QA, CAT and Prod.
Did performance and tuning at server level like suggesting the changes in configuration parameters and also did testing & implementation for the same.
Involved in Pre and Post upgrade plans and implementation of the plans for each Production, UAT, and DEV environment.
Analyzing the Sybase 12.5 T-SQL code modifications and server changes before doing upgrade.
Involved planning and implementation of back out plan compatibility mode bcp out from 15.5 and do bcp in 12.5
Involved back out plan (bcp out from 15.5 and bcp in 12.5) and prepared the shell scripts for the same. Also did testing for the back out plan.
Providing suggestion on the database level configuration parameters, creating named cache based on the Sysmon report analysis.
Suggesting indexes for the tables which are involved in long running transactions as well as testing for the same.
Teledata Systems
Duration Jan 2006 till Aug 2009
Technology
Sybase ASE 12.5.x to 15.x on Solaris and Linux.
Project Abstract
Creating databases, devices, database Objects, setting up data base options Managing Performance & tuning
Responsible for Tuning the Sybase Configuration parameters
Automated Backup, recovery plan and disaster recovery plan for all the Database servers.
Automated daily backup procedures through cron jobs.
Database weekly maintenance run DBCC, Update Statistics, Recompile the Stored Procedure, Rebuild etc.
Responsible for creating users, logins, administrating Sybase roles, managing objects and granting permissions.
Created many triggers, stored procedures and reports for time to time requirement.
Installing/upgrade the SYBASE ASE, Sybase Replication servers.
Monitoring :Space Utilization, Performance, Dead locks
Unix Shell scripts for different cron jobs.
Critical Projects Handled
1.
DOMIN Server upgrade
Role
Sybase DBA
Duration
4 Days
Team Size
1
Tools Used
Sybase ASE 12.5.3, Replication Server 12.6, Sybase ASE 15.5
Project Description:
Upgrading Sybase ASE 12.5.3 servers to Sybase ASE 15.5 and setup replication between Prod and DR servers.
As a Sybase DBA, I was responsible for
Upgrading Sybase Servers on Linux Platform.
Creating & Restoring Sybase Databases.
Creation of Login ID’s On Sybase Servers.
Setup bidirectional replication between Prod and DR server using warm standby and MSA.
Working With Developers to Solve User Problems.
Modifying maintenance script so that it works with the recent changes.
Scheduling maintenance jobs on weekly and daily bases.
2.
TRADE database Migration.
Role
Sybase DBA
Duration
3 Days
Team Size
1
Tools Used
Sybase ASE 12.5.3, Replication Server 12.6, sybmigrate
Project Description:
Migration of TRADE application database from 2K to 8K page size using sybmigration tool. Data is replicated from Paris database to Singapore database which will again replicated to DR database in Singapore.
As a Sybase DBA, I was responsible for
Installing Sybase ASE 12.5.3 server on Linux Platform.
Creating & Restoring Sybase Databases.
Creation of Login ID’s On Sybase Servers.
Data migration from 2K page size server to 8K page size server. Max database size was 60 GB.
Setup replication between Prod and DR server using warm standby.
Working With Developers to Solve User Problems.
Modifying maintenance script so that it works with the recent changes.
Scheduling maintenance jobs on weekly and daily bases.
Diligence, sincerity and hard work have been instrumental in shaping my life so far. I have guided by a firm belief in the importance of integrity and self-respect. A strong aspect of my personality is perseverance, ability to take on responsibilities and work with efficiency and involvement. I love to adapt myself to new situations and work as a team.
I hereby assure you that all the information provided above are true to my knowledge and belief.
Signature
Naveen Kumar Reddy
Contact this candidate