Jayaratna Sheela firstname.lastname@example.org HP: +1-727-***-****
•Visionary with a Decade+ successful technical expertise and experience for the planning, analysis, design, development, Administration, implementation, maintenance, Optimization and control of the mission critical Sybase, MS SQL and MySQL database projects.
•Exemplary knowledge in Development, Administering, Production Support and Migrating Databases among Sybase, MS SQL and MySQL using native Replication and GoldenGate.
•Highly successful Database Administrator for large, mission critical database environments primarily for Sybase ASE databases i.e. Database Design, Development, Administration, Migrations, Upgrades and Fine-Tuning/ Optimization to provide optimal performance and minimal downtime besides Managing 10+ DBAs for 24x7 Production support includes MySQL and MS SQL Server with HA Options, Replication and Clustering.
•Migrated Terabytes of Database among Sybase ASE, MS SQL Server, MySQL and Oracle. Optimized Servers, Databases and Fine-tuned T-SQL Queries including Stored Procedures.
•Familiar with SAP HANA, SHELL/PERL scripting and most Ticketing tools.
•Strong T-SQL development knowledge and scripting skills to optimize Databases, Tables, Indexes, Views, Triggers, Cursors and Stored Procedures for the better Performance.
Skill set and Achievements
SDLC concepts, Monitoring, Tracking, Release Management, Team Management and Customer Relationship Management.
Unix, Windows and Linux.
Sybase ASE 12.5.x to 15.7, RepServer 12.6 to 15.7.x, ASIQ 12.x-15.4, MS SQL Server 2000-2012, MySQL 5.x and SAP HANA.
Autosys, FogBugz, DBArtisan, DBErwin, BMC Remedy and Patrol
T-SQL, SHELL and PERL scripting.
MongoDB and Oracle GoldenGate.
•Sybase Certified Adaptive Server Administrator.
Project 1 -> Williams, Citi and other BFSI Database Support Projects (on rolls of an MNC)
Dec 2009 – Till Date
Sybase ASE/Rep 15.x, ASIQ 15.x, Oracle 11g, MySQL 5.x and SAP HANA.
Sybase central, DB Artisan and Oracle SQL Developer.
Role: Sr. Database Admin for SAP Sybase Primary and Oracle, MS SQL and MySQL secondary.
These Projects to provide the Database Support for the production, development and UAT servers, ensure the availability of the production databases to end-users and development database to developers in a 24x7 environment.
Responsibilities as Sybase DB Consultant:
Monitoring and Maintenance of Development/QA/production Databases of Sybase, Oracle, MS SQL and MySQL Databases (Primary Support for Sybase ASE and RepServer)
Jobs scheduling, monitoring and troubleshooting, Resolving issues in daily builds and fixes.
Monitoring and fine-tuning systems (It includes OS Tuning, Network Tuning, Database Tuning, ASE Tuning, Memory Tuning and Query Tuning) to support Online (OLTP) Users, Trading and daily reports for better performance.
Troubleshooting and performance tuning of SAP Sybase IQ systems.
Migrating existing non-Sybase data warehouse systems to SAP Sybase IQ.
Configuring and Maintaining Sybase Replication Server for Sybase, Oracle and DB2.
Trouble shooting the daily development/QA/production problems/tickets.
Worked on Up gradation/Migration of VISA Production database from Sybase ASE 12.5.3 to MS SQL Server 2008. Worked on Tuning Performance i.e. analyze and capture the crucial/critical part of the stored procedure (Which T-SQL is consuming major part of the elapsed time) and optimize the same and leverage it for SQL Server 2008.
Worked on Time Inc. Migrating ASE 12.5.3 databases into ASE 15.0.3. Also verified various new options/ features and implemented most of crucial innovative ideas to reduce the response-time of the processes. Also migrated Rep Server System from 12.6 to 15.
Worked on BNYMellon Performance tuning engagement i.e. fixing issues forced the performance degrade to 50% after upgrading databases into ASE 15.0.3 from 12.5.4. We could tune the database back to previous performance and later for 15% improvement over ASE 12.5.4 database performance.
Optimizing joins and APFs using optimization goals and Buffer configurations.
Handle Level 1\2\3 Production Support activities, along with coordination with offshore-onsite teams for enhancement tasks.
Documentation of production issues, resolution methods and best practices.
Perform Coding, Unit Testing and Integration Testing activities for enhancement requests
Created adhoc reports as per business requirements.
As MS SQL Server and MySQL DB Consultant performed the following Roles:
Installed and configured SQL Servers, Created new Databases, Restored from Database backups, Migrated/Upgraded Databases and Configured SQL Server monitoring utilities.
Administering and Maintaining backups, restores, recovery models, database shrink operations, DBCC commands, especially AlwaysOn Availability Groups.
Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
Have successfully implemented Contained Databases, Columnstore Indexes, User-Defined Server Roles, Pagination and DQS Data quality services.
Deploying database change scripts after thorough Analysis and Validation with tuning tips.
Identify and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention, followed by optimize the resources for optimal performance.
Performed Standalone and Cluster SQL Server Installation and configuration, Up-gradation and Patch management.
Troubleshooting Production/UAT/DEV/TST SQL Server Issues (Job failure,, Login failure, Performance Issues, Blocking, Deadlock, Suspect database etc).
Supporting business user requests (Heath Check Reports, Performance Issue, Access/Permission, Job failures etc).
Developed policy for database decommissions, user decommissions, SQL Server migration and escalation with adhere to SLA and escalation matrix.
Performance and Tuning of SQL Server re-Configuration, Database options, Object optimization and Queries, Stored procedures performance.
Taking care of Capacity Planning (Backup Share, Disk, CPU and Memory)
Provision MySQL instances, both in clustered and non-clustered configurations
Ensure performance, security, and availability of databases
Prepare documentations and specifications
Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
Profile server resource usage, optimize and tweak as necessary
Collaborate with other team members and stakeholders
Performed SQL Server Migration 2005 to 2008 and 2008 to 2012. Also from Sybase ASE 15 to SQL 2008 and later to SQL Server 2012.
Developed, Planned and configured the database maintenance script for all the production and UAT servers.
Maintain the databases by creating the Backup Plan, Disaster Recovery Plan and Maintenance Plan includes DBCC checks, fixes and Update stats and Reorg/Rebuilds.
Automated the Backup and Maintenance plan using third party tools on requirement.
Troubleshooting and resolving SQL alerts and SQL errors arriving into the queue.
Implementation, Configuration and troubleshooting HA Services (Log Shipping, Database Mirroring, Replication and Cluster).
Configured, Implemented and Maintaining the Always On Availability Groups HA option for critical SQL Server 2012 Production Databases.
Project 2 -> BNY Mellon and Informatica Inc for an Indian MNC
Dec 2007 to Dec 2009.
Sybase ASE, RepServer and MS SQL Server.
Service NOW and REMEDY
This Project is to provide the Database Support for the Production Database Service Delivery.
•Providing L1 to L3 Support for the Sybase ASE, REP Servers and databases requires high availability and optimal performance.
•Managing and Maintaining 1000s of Sybase ASE, Replication servers, fixing issues on the fly based on the Service Now (SNOW), Net Cool alerts or chat channels with in 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.
•Setup and manage SQL Backtrack managed database recovery model
•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.
Project 3 -> Indian MNC for Merrill Lynch of BOA.
Aug 2005 to Sep 2007.
Sybase ASE and Rep Server. MS SQL Server 2000-2005.
Sybase central, BMC Patrol, REMEDY and Autosys.
This Projects to provide the Sybase Production Database Support for the Merrill Lynch Database system and fine tuning the Applications and Database objects.
•Responsible for administration and Monitoring Sybase primarily and MS SQL Secondarily for the support of all the Production DB Maintenance and Change controls.
•Assigning and monitoring the work (Issues generated via tickets) among the DBA’s.
•Taking care of Troubleshooting and performance issues (P1 tickets) and documenting the resolutions and sharing the knowledge to the DBA team to resolve recurring issues easily.
•Monitoring the Online dumps, backup jobs and the space management.
•Responsible for Installation and Upgrading Sybase ASE 12.5 servers.
•Performance tuning, troubleshooting, and database administration tasks.
•Developed stored procedures, triggers, views, definitions and subscriptions.
•Responsible for monitoring replication / stand by server activities.
•Developed shell scripts for coding and job scheduling in Cron.
•Fine tuning the configuration parameters and monitoring database performance.
•Installing, Configuring and Maintaining Adaptive Server and Backup Server.
•Planning, Scheduling and Maintaining System/User Database BACKUPs.
•Creating and managing Adaptive Server login accounts and permissions to ASE users.
•Managing and monitoring the use of disk space, memory, and connections.
•Configuring Adaptive Server to achieve the best performance and managing disk storage.
•Worked very closely with developers and testers to resolve all database issues, stored procedures and triggers performance issues in Development, and Prod environments.
•Other Project responsibilities includes Advanced Performance tuning, Subject Matter Expert role, Storage and Capacity management, Security and Audit remediation, Cost efficiency & Service improvement initiatives, Incident Management and RCA.
•Imparted training on ASE 12.5/ASE 15, Transact SQL Programming, Performance and Tuning for over 4 ELTP batches.
•Have Developed, Compiled, optimized and managed 100s of Stored procedures for the Day-to-Day Database Maintaining and Monitoring tasks.
•Implemented recovery procedures including regular Dump's and Load's.
•Created and Shared Knowledge base documents of the Process and Best Practices.
Project 4 -> Indian MNC.
Jul 2002 to Jun 2005.
MS SQL Server 2000.
BMC Patrol and REMEDY.
This project was developed in-house with the support of NIIT and have been using by APTransCo. Finance module has been developed using MS SQL Server 2000 and MS Access/MS-Excel.
•Played very critical Role in building a new DBMS system from scratch i.e. Right from Database design, Installing and Configuring Server Products, Tools, Creating Database Objects, Creating various Triggers, Rules, Views, Procedures and Optimizing the Database objects including sound backup and recovery strategy plus disaster-recovery.
•Create database objects such as tables, views, stored procedures, Triggers etc.
•Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
•Identify columns for Primary Keys in all the tables at the design time and create them.
•Be aware of potential blocking, deadlocking and write code to avoid those situations.
•Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
•Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.
•Responsible for support/administration of MS SQL Server 2000, support of all the implementations and change control on production
•Jobs scheduling, monitoring and troubleshooting.
•Taking Database backups and restoring upon demand.
•Working/debugging and planning of SQL.
•Monitoring Design standards, methods and tools and ensure they are applied effectively.
•Leads development of systems in line with the architecture and design, ensuring consistency with specified requirements agreed with both external and internal customers. Takes full responsibility for ensuring that systems architectures balance functional, service quality and systems management requirements.
•Ensures that appropriate standards (corporate, industry, national and international) are adhered to manage the service's design, policies and standards, working proactively to achieve stable, viable designs, and ensuring consistency of design across the service.
•Advises development teams on the evaluation and impact analysis of change requests.