Database Administrator Disaster Recovery
Resume:
******.*****.*.****@***.***
Naveen Kumar Reddy Daka
Profile
10+ years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
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.
Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
Skill Set
RDBMS: Sybase ASE 12.5 to 16.0, Sybase Replication 12.6 to 15.7.x, Sybase IQ 15.4, MSSQL Server 2008 to 2017
Tools: Autosys, DBArtisan, Sybase Control Centre (SCC), Proactive DBA, SQL Developer
O/S: Windows,Solaris, Linux
Scripting: T-SQL, Shell, P-Shell
Education:
Bachelor’s in Computer Maintenance and Engineering from Loyola Academy - 2006, Hyderabad, India,
M.Sc. Sikkim Manipal University, India
Professional Experience
Nov 2017 – Till date, Application Database Adinistrator IBM, USA
Project Responsibilities
Supporting production, development and UAT servers, ensure availability of production databases to end-users and development databases to developers in a 24x7 environment.
Wrote scripts in UNIX Shell scripting and Power Shell Script.
Upgrade SQL server from 2008 to 2017.
Monitoring ETL jobs for Sybase ASE and MS Sql.
Deploying new stored procedures to the production environment.
Data extraction and loading from disparate sources into a Sybase ASE and MS Sql database for analytics.
Using load table feature for faster data load in Sybase ASE and MS Sql.
Implemented 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.
Implementation of Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
Feb 2016 – Nov 2017, Database Administrator Meijer, USA
Project Responsibilities
Responsible for defining, creating, implementing, maintaining, and supporting enterprise data models and databases within the RDMS.
Analyzing, testing, and implementing physical database design; supporting various business applications and ensuring data recovery, maintenance, data integrity and space requirements for physical database were being met.
Closely monitored RDBMS performance to identify problems and implement solutions; ensure the database was running at optimum speed and efficiency; responding quickly to refresh data.
Verifying implementation of correct backup strategy; developing recovery procedures, including recovery from loss of data and using tools to reorganize or defragment database table spaces, tables, and indexes.
Providing an efficient database environment to maximize productivity and improve performance.
Monitoring file system space and database allocation.
Creating, developing, and reviewing the physical model created for the logical model, ensuring the detailed physical design of data structures complies with standards, guidelines, and procedures recommended for all aspects of data modeling.
Reviewing overall physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirements.
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.
Jun 2015 – Feb 2016, Sybase Database Administrator VortalSoft, USA
Project Responsibilities
Upgrade Sybase IQ 15.4 to Sybase IQ 16.
Installing ASE and Backup server.
Creating and managing Adaptive server login accounts,
Participating in Disaster Recovery Test.
Upgradation of Sybase ASE server.
Housekeeping Sybase, dump directories.
Deploying new stored procedures to production environment.
Upgrading Sybase Replication servers.
Installation of Replication server.
Applying patches whenever there is a release.
Monitoring Error logs and taking preventive measures there on.
Performing various administrative related activities pertaining to databases and performance.
Managing and monitoring use of disk space and memory.
Maintaining backups and Recovery Strategies.
Sybase Utilities: BCP in/out, defncopy, optdiag, ddlgen.
To perform weekly maintenance DB activities like DBCC, Update Statistics.
March 2012 – May 2015, Senior DBA Specilist WellsFargo, India
Project Responsibilities
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 include 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 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 workload/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.
Feb 2010 – Feb 2012, Database Administrator Society Generale,India
Project Responsibilities
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.
Aug 2009 – Feb 2010, Database Administrator Stride IT,India
Project Responsibilities
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.
Jan 2016 – Aug 2019, Database Administrator Teledata Systems,India
Project Responsibilities
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