Sql Server Support

Jayaratna Sheela *****@*******.*** HP: +1-610-***-****

Experience Glimpse

•Visionary with 12+ years of highly successful Database Management of very large and mission critical SAP Sybase ASE and SRS environment all phases i.e. Database Design, T-SQL Development, Coding, Database Administration, Server, Database and Object Optimization, Migrations, Upgrades and Fine-Tuning of Transactions to provide optimal performance and minimal downtime for 24x7 BFSI Production Environments.

•Proven experience of Installation, Configuration, Development, Administration, Migration, upgradations and Tuning of versions Sybase ASE 15.x to SAP ASE 16. I have implemented vital features of ASE like Semantic partitioning, #based Update Stats and MSA Replication.

•Managing 10+ DBAs for 24x7 Production support Primarily for Sybase ASE but also includes SRS, MySQL and MS SQL Servers with HA Options and Replication.

•Designing, Administrating, and Supporting Sybase ASE and Replication system.

•Customized T-SQL development including stored procedures, Triggers& Implementing customized password policies. IQ administration using Sybase central.

•Strong SHELL and PERL scripting skills to automate and generate Day-to-Day tasks and reports for the ASE logs, space monitoring, alerts, for the ease of maintenance.

Skill set and Achievements

Project Management

SDLC concepts, Monitoring, Tracking, Release Management, Team Management and Customer Relationship Management.

Operating Systems

Unix, Windows and Linux.

RDBMS

Sybase ASE 12.5.x to 15.7.x, SRS12.6 to 15.7.x.

MS SQL Server 2000-2012, MySQL 5.x and SAP HANA.

Tools

Autosys, FogBugz, DBArtisan, DBErwin, BMC Remedy and Patrol

Scripting Langs

T-SQL, SHELL and PERL scripting.

Certifications

•Sybase Certified Adaptive Server Administrator.

Project Experience

Project 1 ->Williams, Citi and other BFSI Database Support Projects (on rolls of Wipro-H1B)

Duration

Dec 2009 – Till Date

Technology

Sybase ASE/Rep 15.x-16, Oracle 11g, MySQL 5.x and SAP HANA 1.0 SPS 8.

Tools

Sybase central, DB Artisan and Oracle SQL Developer.

Role: Sr. Database Admin for SAP Sybase Primary and MS SQL and MySQL secondary.

Project Abstract:

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 ASE &SRSDB Consultant:

Provide engineering and escalation support for mission-critical SAP Sybase databases in a fast-paced environment for banking, and related financial and other business/enterprise applications.

Monitoring and Maintenance of Development/QA/production Databases of Sybase, Oracle, MS SQL and MySQL Databases (Primary Support for Sybase ASEand 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.

Configuring and Maintaining Sybase Replication Server for Sybase, Oracle and MySQL.

Trouble shooting the daily development/QA/production problems/tickets.

Designing & Modeling the ETL data structure requirements especially with respect to IQ, ASE

Installing IQ Simplex and Multiplex, IQ Database administration

Trouble shooting, Performance tuning, optimization of SRS.

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 15% improvement over ASE 12.5.4 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 Heterogeneous replication among Sybase, Oracle and SAP HANA.

Project 2 -> Cognizant Technology Services for UBS and Informatica inc.

Duration

Oct 2007 to Dec 2009

Technology

Sybase ASE, SybaseRepServer and MS SQL Server.

Tools

Service NOW and REMEDY

Project Abstract:

This Project is to provide the Database Support for the Database Service Delivery at UBS AG..

Responsibilities:

●Providing L1 to L4 Support for the Sybase ASE 15.x, SybaseREP Server 15.x and MS SQL Server 2008-2012 databases requires high availability and optimal performance.

●Managing and Maintaining 1000s of Databases on UNIX, 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 -> Satyam Computer Services for Merrill Lynch of BOA.

Duration

Aug 2005 to Sep 2007.

Technology

Sybase ASE and Rep Server. MS SQL Server 2000-2005.

Tools

Sybase central, BMC Patrol, REMEDY and Autosys.

Project Abstract:

This Projects to provide the Sybase Production Database Support for the Merrill Lynch Database system and fine tuning the Applications and Database objects.

Responsibilities:

•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 -> APTransCo, AndhraPradesh, Visakhapatnam.

Duration

Jul 2002 to Jun 2005.

Technology

MS SQL Server 2000.

Tools

BMC Patrol and REMEDY.

Project Abstract:

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.

Responsibilities:

•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.

Contact this candidate