EXPERIENCE SUMMARY:

• Around 8 years of experience working with Financial and Banking clients.
• Certified Senior DBA with 8 years of experience in Confidential Database Administration of which 8 years is on Confidential Database Administration and around 2 years on MSSQL server Databases. Supported huge databases on UNIX flavors, Windows environment in multiple locations. Supported multiple servers and databases with 24 X 7 production support environments. Actively worked on user requests and developers issues.
• Successfully Installed and upgraded Confidential 15.x versions with various financial clients which includes in - place upgrades, new installations, replication setup, migrations and DR setup.
• Provided senior level Confidential, Replication, MSSQL consulting services focusing on database administration, performance tuning, data warehousing, e-commerce, systems migration, enterprise infrastructure and standard, and web based server administration in 24x7 enterprise environments.
• Worked on complex Heterogeneous and Homogeneous Replication environments which comprises of multiple database products and third party tools, Supporting 24/7 production support and handling weekend On Call.
• Monitored the databases to optimize database performance, resource use and physical implementations of databases. Checking for database consistency, fixing DBCC errors, monitoring of error logs regularly, monitoring of database space allocations, transaction log space allocations .I was responsible for Creating and testing of Database Backup Procedures, Disaster Recovery procedures.
• Continuously worked on improving the performance of databases by coordinating with the development teams, helping them with their queries, releases and actively participated in technical discussions suggesting them with the new features of the database.
• Built latest version Confidential ASE-15.x, Replication servers from scratch. Configuring and implementing new features like multiple tempdbs, semantic partitioning of large tables to name few. Involved in every phase of server deployment and support.
• Extensively worked on managing SybaseIQ-12.6 data warehouse simplex and multiplex architecture, performing database restore, loading data, taking backups and troubleshooting errors.
• Created shell scripts for multiple database tasks like Monitoring error logs, space management, maintenance tasks, health checks, automated Database processes, table migrations, Health checks, Replication queues, Replication Threads, FTP, timely backups and Housekeeping the backup directories.
• Documented key procedures for Replication setup, disaster recovery, configuring database consistency checks, Replication switchover incase of disaster and key troubleshooting techniques of runtime errors specific to the environments.

TECHNICAL EXPERTISE:

Platforms: Windows. UNIX, AIX-5.2, Solaris, HP UX, Linux

Tools: Tidal, Confidential Central,FogLight, BMC Remedy, Autosys

Version Control: PVCS

Database: ASE 12.5.x,15.x, MSSQL server 2008 r2

Data warehouse: Confidential IQ.

Replication: Confidential Replication Server 12.5,12.6,15.5,Repagent

Middleware: Enterprise Data connect,DirectConnect

Languages: c, c#.

Web technologies: ASP.NET.

Development tools: Visual Studio.NET 1.1.

Markup languages: HTML

EMPLOYMENT:

Confidential, Reston, Virginia

Responsibilities:

• Provide senior level Confidential and MSSQL server 2008 r2 database administration.
• Confidential installation, configuration, tuning, backup and recovery, Add and Configure Confidential Servers.
• Managing and monitoring the use of disk space, memory, and connections.
• Performing database code releases and assisting developers to promote their code into production from test servers.
• Assisting Unix team with their patch upgrades.
• Working on DR project, Analyzing the existing setup and plan for DR setup in a new location.
• Planning, implementing timely maintenance scripts like DBCC’s, Reorg’s, Table fragmentation, Analyzing statistics and troubleshooting errors reported.
• Working on replication issues like thread down, disk space monitoring, dealing with Repagent.
• Talk to various Business Units within organization for functional as well as technical discussions for new enhancements, understanding their requirements and suggesting suitable solutions.

Environment: Operating systems: Windows, UNIX, Solaris, Linux.

Database: ASE 12.5, ASE 15

RepServer: Confidential Replication Server 12.6, 15.x.

Ticketing Tool: BMC Remedy

Tools: Fog Light, Autosys

Confidentia, Irvine, California

Responsibilities:

• Provide senior level Confidential and MSSQL server 2008 r2 database administration.
• Confidential installation, configuration, tuning, backup and recovery, Add and Configure Confidential Servers.
• Involved in upgrade of production servers till Go Live.
• Worked on migration of Disaster Recovery site.
• Managing and monitoring the use of disk space, memory, and connections.
• Performing monthly database code releases and assisting developers to promote their code into production from test servers.
• Assisting Unix team with their patch upgrades.
• Responding timely to user requests and assisting them on their releases, Performing Table Migration and requested data restoration.
• Planning, implementing timely maintenance scripts like DBCC’s, Reorg’s, Table fragmentation, Analyzing statistics and troubleshooting errors reported.
• Built a new DR site complete end to end with Confidential and Replication.
• Working on replication issues like thread down, disk space monitoring, dealing with Repagent.
• Talk to various Business Units within organization for functional as well as technical discussions for new enhancements, understanding their requirements and suggesting suitable solutions.

Environment: Operating systems: Windows, UNIX, Solaris

Database: ASE 12.5, ASE 15

RepServer: Confidential Replication Server 12.6, 15.x.

Ticketing System: HP-Open view V7

Confidential

Senior Database Administrator

Responsibilities:

• Provide senior level Confidential and Oracle database administration which involves hundreds of servers.
• Confidential installation, configuration, tuning, backup and recovery, Add and Configure Confidential Servers.
• Create and Restore System database backups.
• Creating/Modifying/Locking Logins and Users in Confidential, Oracle Databases. Granting Roles and Permissions to users.
• Managing and monitoring the use of disk space, memory, and connection.
• Creating/Modifying/Locking Logins and Users in Confidential Database.
• Responding timely to user requests and assisting them on their releases, Performing Table Migration and requested data restoration.
• Planning, implementing timely maintenance scripts like DBCC’s, Reorg’s, Table fragmentation, Analyzing statistics and troubleshooting errors reported.
• Working on replication issues like thread down, disk space monitoring, dealing with Repagent.
• Working on user requests,changes,releases on HP-OpenView
• Talk to various Business Units within organization for functional as well as technical discussions for new enhancements, understanding their requirements and suggesting suitable solutions.

Environment: Operating systems: Windows, UNIX, AIX-5.2, Solaris, HP UX.

Database: ASE 12.5, ASE 15, Oracle 10g, 11g

RepServer: Confidential Replication Server 12.6, 15.x.

Ticketing System: HP-Open view V7

Confidential

Responsibilities:

• 24/7 support for all the customers of REMO and ensuring servers are up and running fine.
• Monitoring and Troubleshooting issues that are encountered on daily basis with Replication server and ASE.
• Working on Issues filed with CTS.
• Installed, Configured and upgraded servers based on clients requests.
• Working with day-to-day Data server, Database issues in a production environment like log segment filling up, taking backups and refreshes.
• Performing Table Migration on user requests.
• Provided support on Confidential IQ data warehouse which includes simplex and multiplex architecture.
• Provided timely, reliable status reports of the servers to clients for their analysis.
• Worked on heterogeneous replication environments troubleshooting issues with RepAgents, Enterprise data connect software’s.
• Working on replication issues like thread down, disk space monitoring, dealing with Repagent.
• Visited onsite for domestic customers, studied the environments, worked on stabilizing the environment and training their staff.
• Worked on weekend support maintenance for customers, which include running diagnosis jobs, fixing errors reported, defragmenting tables, purging data and reclaiming space.
• Prepared documentation on key troubleshooting tips and tricks.

Environment: Operating systems: Windows, UNIX, AIX-5.2, Solaris, HP UX.

Database: ASE 12.5,15.

Data warehouse: Confidential IQ 12.6.

Replication: Confidential Replication Server 12.5,12.6,15.5,Repagent

Middleware: Enterprise Data connect,DirectConnect

Confidential

Responsibilities:

• Performed early morning Health checks for all the critical servers within timeframe provided and hence ensuring the business for a hassle free BOD process by the application teams.
• Monitoring and Troubleshooting issues that are encountered in production hours with Replication server, ASE, Repagent and Direct Connect.
• Worked with departments that are associated with data servers and responding to their adhoc requests.
• Worked with day-to-day Data server, Database issues in a production environment like log segment filling up, taking backups and recovery.
• Worked on BOD and EOD activities performing various tasks like capturing selected data and transferring to various departments within stock exchange.
• Performing daily backups at close of business hours which includes file system backups and backups on tapes.
• Working on replication issues like thread down, disk space monitoring, dealing with Repagent.
• Worked on weekend maintenance activities and mock testing with the development team.
• Installed and configured servers as requested by development teams and encouraging them to use the new features.
• Trained in house staff associated with the project.

Environment: Operating system: HP UX UNIX.

Database: ASE 12.5.

RepServer: ASE Repserver 12.5, 12.6

Data warehouse: Confidential IQ 12.6.

RepAgent: Confidential Replication agent 12.5

Middleware: Confidential Direct connect

Confidential

Responsibilities:

• 24/7 support for all the production servers and ensuring servers are up and running fine.
• Monitoring and logging long running user transactions, blockings in production hours.
• Monitoring and troubleshooting busy production hours which comprises of users connecting from all the branches throughout the country.
• Scheduling and running maintenance activities on production server like update statistics, REORG REBUILD.
• Improving performance of large database tables by partitioning them and reducing fragmentation.
• Upgrading the server with latest EBF’s and patches.
• Providing support to SA’s on their scheduled maintenance and patch application.
• Managing database growth and handling large database tables by partitioning them.
• Working on user requests.

Environment: Operating system: UNIX, AIX-5.2.

Database: ASE 15.0.2 HA.

Confidential

Responsibilities:

• Monitoring and troubleshooting Jobs that are running on TIDAL Scheduling Software.
• Monitoring and Troubleshooting issues that are encountered on daily basis with Replication server and ASE.
• Working on ONYX tickets and STARS assigned by Onsite team
• Working with day-to-day Data server, Database issues in a production environment like log segment filling up, taking backups and recovery.
• Performing Table Migration on user requests
• Working on replication issues like thread down, disk space monitoring, dealing with Repagent.
• Documented key troubleshooting tips and tricks.

Environment: Operating system: UNIX, AIX-5.2, Solaris.

Database: ASE 12.5

RepServer: ASE Repserver 12.5

Monitoring Tool: Tidal Scheduler

Ticketing System: ONYX, Stars, HP Openview