Developer Sql Server

Varsha Jalgaonkar Cell: 949-***-****

DBA / Developer Email: ******.**********@*****.***

Objective:

Certified DBA/Developer professional with over 8 years of experience as database administrator and programmer on Oracle 11G, SAP Sybase ASE, PostGres, SAP Sybase Replication server, Microsoft SQL Servers, IBM DB2 with an urge to learn new technologies through research and learning. Worked on Oracle SQL Developer tool & SQL Server Migration Assistant extensively. Seeking new challenges and opportunity to join a growing organization that has need for a database administrator (DBA). Interested in using my problem solving and technical skills in database management systems.

Able to multitask, strong interpersonal and communication skills, strong commitment to service excellence, meticulous, dedicated, quality driven, result oriented, determined, proactive and hardworking professional, leader and team player.

Work Experience

Employer/Company: mLogica Inc, Orange, California USA

Designation/Role: DBA+Developer Duration: 05/2013 – 10/2015

mLogica is a highly specialized technology and product consulting company. mLogica’s core competencies include Business Intelligence, Enterprise Data Management and Enterprise Application Development.

In mLogica, I have worked on different projects involving Database administration, migration, programming skills. Below are the details about each client and list of specific responsibilities I was assigned to:

**All the below projects were worked on from mLogica’s Orange Office

Client: Esurance, San Francisco, California USA

Designation/Role: Computer Programmer/Migration team Duration: 09/2014 – 10/2015

Migration from SQL Server 2012 to Oracle 11g using Oracle SQL Developer

Determining the Requirements of the Migration Project

Scripts generation using PL/SQL and unix shell scripts,Schema migration, verification and validation,Migrating the Data, Data verification and validation

Data refresh as per the client requirement, Performing various tests to optimize the migration

Issue resolution while migration process

Client: Sempra Utilities, Los Angeles, California USA

Designation/Role: Database Administrator Duration: 06/2014 – 12/2014

Migration from Sybase 15.0.2, Sybase 15.0.3 to SQL Server 2012 using SQL Server Migration Assistant

Support, administer, optimize and maintain development SQL Server 2008/2008R2/2012 database environments running on Windows 2008/2012 platforms, Provide capacity planning

Diagnose SQL Server database issues, including performance, and data integrity issues

Provide high-level instance and statement level tuning, and optimum data loading/ETL techniques, and requests

Determine, implement, and manage database backup and recovery strategies, with focus on PIT recovery, Issue resolution while migration process

Provide database space management and some monitoring chiefly for development database

Migration of applications from test to production environments

Schema migration, verification and validation,Migrating the Data,Data verification and validation

Designing, building, installing, configuring and supporting Database servers.

creating, moving, upgraded, and deleted databases; implementing backup and recovery processes; performing routine maintenance on databases; monitoring and tuning databases using Performance Monitor, SQL Server Profiler and Dynamic Management Views; implementing and maintaining security rules and security audits; maintaining state of audit readiness; problem resolution.

Worked on SQL clustering environment.

Monitoring database system details within the database, including stored procedures and execution time.

Optimizing the performance of Queries and Store Procedures with modification in T-SQL statements

Client: mLogica (Inhouse Project)

Designation/Role: Developer Duration: 11/2014 – 10/2015

Migration from SQL Server 2012 to PostGres 9.4

Determining the Requirements of the Migration Project

Schema migration, verification and validation along with Data Migration

Schema Deployments based on the application needs, Basic Database Administration task

Basic Performance evaluations and changes, Worked with testers

Client: Brown Brothers Harriman, New Jersey, USA

Designation/Role: DBA Migration Team Member Duration: 06/2013 – 06/2014

Migration from DB2 9.5 to Oracle 11g using Oracle SQL Developer

Determining the Requirements of the Migration Project

Scripts generation using PL/SQL and unix shell scripts,Schema migration, verification and validation

Migrating the Data, Data verification and validation,Issue resolution while migration process

Client: AIM Specialty Health, Illinois, Chicago USA

Designation/Role: Database Administrator Duration: 01/2014 - 07/2014

Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.

Responsible for routine DBA jobs like Backups and Restores.

To analyze long running queries and tune the same to optimize application and system performance.

Maintaining the database consistency with DBCC at regular intervals. Server Builds, instance creation

Creation of databases, monitoring scripts

Support client databases and systems 24/7Database support involves Sybase ASE, Sybase Replication, MSSQL Servers

Used DBCC commands to troubleshoot issues related to database consistency.

Performance monitoring, tuning through programming and shell scripts

Resource use and physical implementations of databases

Weekend maintenance involving reorg, update statistics

Monitoring memory, CPU utilization, disk utilization, locks, deadlocks and runtime of queries

Design and create servers for sybase

Execute various checks for database system corruptions

Upgrade and migration of systems and servers

Resynchronization of database involved in replication

Deployment of codes in production, uat and development environment

Troubleshooting database related problems as and when required & maintaining backup, recovery policies.

Fine-tuning and managing the database, monitoring memory, disk i/o, user connections, locks etc. Setting of configuration parameters as on required basis. resolving tempdb full, log suspend issues, Performing the releases on prod server after getting it signed off from application team.

Maintaining the integrity and consistency of database by using DBCC, Update Statistics & REORG rebuild commands.

Configuring the Replication Databases and Tables using Replication Definitions and subscriptions.

Identifying the Duplicate rows which made the DSI thread down and communicating with the client in order to bring it up.

Creation of Warm Standby setup, checking for latency of replicated databases.

On-call support for critical business activities

Client: Daylight Transport, Long Beach, California USA

Designation/Role: Database Administrator Duration: 05/2013 - 08/2015

Resynching Of Databases Involved In Replication Of Data Across Regions

Create Flow Deployment Of Codes In Production Servers, Uat

First and mid-level support in analyzing and troubleshooting the problem and discuss with Senior DBAs for a resolution and implement the changes; also document the problem and resolution for any future occurrence of the same problem

Installation and configuration of ASE servers,Server Migration from Linux to Sun Solaris and vice versa, Re-synch of databases in Warm standby Environment

Monitoring Dev, Test Server, Prod and COB databases; Monitoring involves disk space, device & database size growth, errorlogs, maintenance jobs, backups, dbcc and update stats maintenance, tempdb full, log suspend issues, minor performance issues, blockings etc

Supporting development activities by completing the requests for the development and UAT servers, Various DB Maintenance operations (DBCC, Reindex, Reorg, Update Statistics)

Configuring the Replication Databases and Tables using Replication Definitions and subscriptions.

Identifying the Duplicate rows which made the DSI thread down and communicating with the client in order to bring it up. Resuming the Rep Agents and DSI threads.

Starting and shutting down the replication Server.

Creating of Warm Standby setup, Checking for latency of replicated databases

Employer/Company: Optimum Solutions (Singapore) Pte Ltd, Singapore, Singapore

Designation/Role: Database Administrator Duration: 04/2012 - 12/2012

Client: Credit Suisse, Singapore

Designation/Role: Database Administrator Duration: 04/2012 - 12/2012

Performance monitoring, tuning through programming and shell scripts

Monitor the databases to optimize database performance in MS SQL, Sybase servers

Resource use and physical implementations of databases, Checking for database consistency

Monitoring memory, CPU utilization, disk utilization, locks, deadlocks and runtime of queries

Design and create servers for Sybase,Execute various checks for database system corruptions

Upgrade and migration of systems and servers, Resynchronization of database involved in replication, Deployment of codes in production, uat and development environment

Troubleshooting database related problems as and when required & maintaining backup, recovery policies. Fine-tuning and managing the database, monitoring memory, disk i/o, user connections, locks etc. Setting of configuration parameters as on required basis. Resolving tempdb full, log suspend issues.

Performing the releases on prod server after getting it signed off from application team.

Maintaining the integrity and consistency of database by using DBCC, Update Statistics & REORG rebuild commands.

SQL Server Index and Lock management, Primary & Foreign Key monitoring & verification. Evaluate query execution plan, use DBCC OPENTRAN to locate long-running transactions, use SQL Profiler to monitor table and index scans.

Configuring the Replication Databases and Tables using Replication Definitions and subscriptions.

Identifying the Duplicate rows which made the DSI thread down and communicating with the client in order to bring it up.

Creation of Warm Standby setup, Checking for latency of replicated databases.

Oncall support for critical business activities

Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs, Backups and Restores.

To analyze long running queries and tune the same to optimize application and system performance.

Maintaining the database consistency with DBCC at regular intervals.

Employer/Company : Mlogica Computech (India) Pvt Ltd, Pune, Pune, Maharashtra India

Designation/Role: Database Administrator Duration: 01/2010 - 03/2012

Clients: Day Light Transport, Long Beach; FHLB Bank, USA; Dexia Financial products, USA

Deployment Of Codes In Production Servers, Uat of MS SQL and Sybase databases

Installation And Creation Of Servers, Backup And Recovery Procedures

Apply Patches, Bug Fixes As Per The Requirements

Server Migration from Linux to Sun Solaris and vice versa.

Monitoring Dev, Test Server, Prod and COB databases; Monitoring involves disk space, device & database size growth, errorlogs, maintenance jobs, backups, dbcc and update stats maintenance, tempdb full, log suspend issues, minor performance issues, blockings etc

Installation and configuration of ASE servers, Server configuration and tuning.

Supporting development activities by completing the requests for the dev and UAT servers

Various DB Maintenance operations (DBCC, Reindex, Reorg, Update Statistics)

Configuring the Replication Databases and Tables using Replication Definitions and subscriptions.

Identifying the Duplicate rows which made the DSI thread down and communicating with the client in order to bring it up, Resuming the Rep Agents and DSI threads, Starting and shutting down the replication Server.

Creating of Warm Standby setup, Checking for latency of replicated databases, Re-synch of databases in Warm standby Environment

Employer/Company: Maersk Global Service Centres, Pune, Maharashtra India

Designation/Role: Officer Duration: 10/2008 - 11/2009

Monitoring Development, UAT and production domains round the clock

Database space Monitoring involves disk space, device & database size growth as per space management policies, Creating replication definition, subscriptions, DB backup, restore

Troubleshooting errors in replication server involving queues, connections, Warm standby setup, table level, Technical support including server support and user support

Monitoring error log & backup server files for any errors. If found any error resolved them

Employer/Company : WNS Services, Pune, Maharashtra India

Designation/Role: System Administrator Duration: 09/2007 - 10/2008

Manage logins and security across all the regions

Installation And Creation Of Servers, Backup And Recovery Procedures

Apply Patches, Bug Fixes As Per The Requirements, Testing Of Business Programs In Uat

Auto Programs For Resynching Of Databases Involved In Replication Of Data Across Regions

Database creation and set configuration values after extensive testing, Database Backup/Recovery

Monitoring involves disk space, device & database size growth, errorlogs, maintenance jobs, backups, dbcc and update stats maintenance, etc

EDUCATION

Institution: Dr. Vikhe Patil Foundations’s CMRD, Pune University Pune, Maharashtra India

Course: Masters in Computer Management in Computer Management Duration: 2005 - 2007

Institution: SP College Pune, Maharashtra India

Course: Bachelor of Science in Electronics Duration: 2003 - 2005

SKILLS

Microsoft SQL server 2008, 2012

SAP Sybase ASE, Replication Server 12.5, 15

Oracle 11G

DB2 9

Oracle SQL Developer, SQL Server Migration Assistant

Linux, Windows

Shell Scripts

Transact SQL

Cassandra

PostgreSQL

Contact this candidate