Resume

Sign in

Sql Server Data

Location:
Posted:
February 22, 2018

Contact this candidate

Sowjanya.Talasila

732-***-****

ac4klg@r.postjobfree.com

SUMMARY:

Having11+ Years of Database Administration and Development experience on MS SQL SERVER 2014/2012/2008 R2/2008/2005/2000 in OLTP and OLAP environments

Experience in installing MS SQL SERVER 2014, 2012, 2008 R2, 2008, 2005 and updating with hot fix and service packs

Strong understanding of RDBMS concepts as well as Data Modeling Concepts

Extensive experience in implementing HADR solutions likeAOAG,Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines

Implemented In-place and Side by SideMigration of MS SQL SERVER2005 to 2008 R2 and 2008R2 to 2012

Knowledge in writing T-SQL (DDL, DML, and DCL) statements

Migrated DTS 2000 packages to SSIS packages in 2005 using MigrationWizard

Experience using SQL SERVER 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE)

Worked on Data Integrity, Performance Tuning, Query Optimization

Providing on call support 24/7 on rotational basis for production database on mission critical systems

Implementing CR (Change Request)and CA (Change Amendments) requested by users

Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources

Performed SQL Upgrades. SQL 2000 to 2005 and building SQL Clustering

Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects

Extensively used native tools like index tuning wizard, database tuning advisor, profiler, performance monitor, activity monitor, event viewer for performance analysis

Experience in Client/Server Connectivity, Database health Check, Indexing and Updating Statistics

Configured SMTP SERVER for Database Mail setup and received Alerts for the Threshold values

Worked on third party tools like BCP Remedy Tool, Lite Speed, Fog light and Red gate

Experience in creating SQL SERVER Reports using SSRS 2005/2008 and worked on Hyper-V and VMware environments

Implemented change management

24*7 Production support experience.

Performing Root Causal Analysis(RCA) of incidents and adhering to SLA standards

TECHNICAL SKILLS:

Operating System

Windows 7/Vista/XP/2000/NT, Server 2012/2008R2/2003, Exchange 2003, Linux, UNIX

RDBMS

MS SQL SERVER 2005/2008/2008R2/2012/2014, MS Access

Languages

Transact-SQL,SQL and Visual Basic

Database Tools

Enterprise Manager SQL Profiler, I-SQL, T-SQL, PL/SQL, SSIS, SSRS, SSAS, ODBC, OLTP, SQL OLEDB, ERWIN, PSSDIAG, VISIO, IIS,HP SAN SCSI, LITE SPEED, RED GATE, VSS, BMC(MAGIC Help Desk),TFS, Double Take, SQLMON, Quest Lite speed, SQL Safe, Red gate, Tivoli

ETL Tools

SSIS 2005/2008/2008 R2/2012, DTS

OLAP Tools

SSAS 2005/2008/2008 R2/2012

Reporting Tools

SSRS 2005/2008/2012, Crystal Reports, BO-Universe, WebIntelligence, MS Excel.

SAP

Lumira,HANA

Work Experience

GVR April 2017 to Present

SR. SQL Server DBA

Gilbarco Veeder-Root is the global leader of integrated technology solutions in the retail petroleum industry. From our reliable fuel dispensers to intuitive point of sale to revolutionary operation management systems and convenience store equipment, Gilbarco Veeder-Root delivers total integrated solutions from the forecourt to the convenience store. Gilbarco has the proven expertise that our customers around the world have come to depend on.

Worked as a Sr.DBAby providing support inproduction and development environments of data and implemented AOAG.

Responsibilities:

Expert in performing installation, configuration (32bit/64bit), optimization, server builds, patches, service packs, upgrading and troubleshooting of SQL Servers in Clustered and Non-Clustered Environments.

Experience in Migrating from SQL server 2000 to 2005 and 2005 to 2008 and 2008 to 2012 by using In-Place upgrade process as well as side-by-side upgrade process and documented complete Upgrade Process.

Implemented and supported different High Availability & Disaster Recovery scenarios like Always-On Availability Groups(AAG), Clustering (Active/Passive), Replication models (Transactional, Snapshot), Log Shipping (Native and Custom) and Data base Mirroring.

Strong technical background along with the ability to perform business analysis and write effective documentation and specifications

Created effective Backup and Recovery plans by Transactional Log and Full Database Backups and utilized to recover data in 'Point in time' in case of disaster of server based on ERT(Estimated Recovery Time), RTO(Recovery Time Objective), and RPO(Recovery Point Objective) Policies.

Handled with both the Planned Failover and the Unplanned Failover

Backed up Production servers set to outside local (DR site)

Backed up SQL Servers to Local (Live site)

Ensured the systems are functioning optimally and that users are able to upload

Migrated SQL Server 2008R2 to SQL Server 2012, SQL Server 2012 to SQL Server2014

Technical Analysis, Code Review, Implementation, 24*7 production support

Worked on performance monitoring and health checks for SQL Servers

Executed SQL Server Integration Services packages using SQL Server Agent Job for building high performance data integration

Monitored, scheduled SSIS and changed SSIS Workflows & Configurations

Experienced with optimizing and performance tuning the queries for a large SQL Cube and ETL

Exposure to supporting ETL based applications

Environment: MS SQL Server 2014/2012/2008, Windows Server 2008R2/2012 T-SQL, MS Access, MS Business Intelligence Development Studio 2008.

Medtronic Apr 2015 to Mar2017

SR. SQL Server DBA

Medtronic is a medical device company headquartered in Dublin, Ireland.The operational headquarters is centered in Fridley, Minnesota, USA.Medtronic is the world's largest standalone medical technology development company.

Worked with a four member DBAteam by providing support in mission-critical production, testing and development environments of data and implemented Disaster Recovery Planning (Using Asynchronous (High -Performance) mirroring with manual failover), Testing and analyzing continuous update of documentation.

Responsibilities:

Installed and maintained of SQL Server 2014, 2012 and 2008R2 on Test, Development and Production Environments, Active Directory Administration

Build High availability, Disaster Recovery and Human T-SQL error plans to meet business requirement.

Implemented Disaster Recovery Planning (Using Asynchronous (High-Performance) mirroring with manual failover), Testing and analyzing continuous update of documentation

Created Windows Authentication Logins and SQL Server Authenticated Logins

Created database roles and application roles for security concern

Provided explicit permissions to specific tables to users in databases

Tuned stored procedures and T-SQL for performance using indexes

Prepared databases for Mirroring and Configured the principal Server

Handled with both the Planned Failover and the Unplanned Failover

Backed up Mission Critical Production servers set to outside local (DR site)

Migrated SQL Server 2008R2 to SQL Server 2012, SQL Server 2012 to SQL Server2014

Technical Analysis, Code Review, Implementation, 24*7 production support

Worked on performance monitoring and health checks for SQL Servers

Executed SQL Server Integration Services packages using SQL Server Agent Job for building high performance data integration

Environment: MS SQL Server 2014/2012/2008, Windows Server 2008R2/2012 T-SQL, MS Access, MS Business Intelligence Development Studio 2008.

Toyota Canada Inc Jan 2013 to Mar 2015

Sr.SQL Server DBA

Toyota Canada Inc. (TCI) is the exclusive distributor of Toyota, Lexus and Scion cars and trucks in Canada. Founded in 1964, Toyota has sold more than 4 million vehicles in Canada through a national network of 285 Toyota, Lexus and Scion dealerships. TCI’s head office is located in Toronto, Ontario, with regional offices in Vancouver, Calgary, Montreal and Halifax and parts distribution centers in Toronto and Vancouver.

Responsibilities:

Provided database design support for new system development; set SQL standards for object names and usage.

Developed complex T-SQL code for data retrieval.

Responsible for backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.

Responsible for data retrieval by extensive use of joins normalization and views.

Responsible for developing processes automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.

Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.

Involved in Performance tuning, query-inventory, analysis and optimization.

Created and managed database users, login Ids and security.

Performed Data transfer (Import & Export) using DTS packages.

Responsible for performing complete back-up and restoration, database maintenance

Service pack updates on server and client.

Created crystal reports and hosting it in the web for the users.

Environment: Windows 2012, SQL Server 2012,Crystal Reports.

Conoco Phillips August 2011 to Dec 2012

SQL Server DBA

GE Transportation, formerly known as GE Rail, is a division of General Electric. The organization manufactures equipment for the railroad, marine, mining, drilling and energy generation industries. Was responsible for supplying the real-time data from our main office in Chicago to the other sites in Hong Kong and Beijing for sales team by peer to peer transactional replication. I was also responsible for improving the performance of our reporting process.

Responsibilities:

Installed MS SQL Server 2008, Performed Database Design and created User Databases

Excellent knowledge in Recovering Databases in emergency/data file missing/log space full

Scheduled backups and performed restore operations for system test data depending on developers' requirement

Created maintenance plan and SQL server jobs and scheduling them, setting emails alerts on failure.

Set up Peer to Peer Transactional Replication (international) along the datacenters in Europe, Asia and America.

Synched all the databases participating in PTP replication prior to setup.

Acquired Replication Accounts (including login names and permissions)

Configured Distributor on all Nodes and Publisher and tested live transaction flow

Configured Transaction replication (domestic) for reporting purpose

Created SSIS Packages to upload test data from Text files.

Used DBCC checks and fixed data corruption in Application database

Administered MS SQL Servers by creating User logins and assigned them proper permissions, observing all process running on the server making sure server will run at its best.

Responsible for Stored Procedures optimization, Performance tuning & index tuning.

Environment: MS SQL Server 2008, 2008R2 and 2012, Windows 2008R2 Advanced Server

Baxter Oct 2010 to Jun 2011

SQL Server DBA

Our global presence, strong portfolio, and near-term pipeline all serve as long-term sources of growth for Baxter as a focused medical products company. What hasn't changed is our unwavering commitment to saving and sustaining lives. Millions of patients and healthcare professionals rely on Baxter every day. Our products are essential building blocks of care and in delivering cost-effective healthcare solutions.

Responsibilities:

Administrated and supported on large number of SQL Server instances in multiple data centers including Production, Test and Development Environment.

Supported 24*7 for production systems

Managed logins and user accounts, including assigning database object permissions and ancillary privileges

Migrated databases and configured database Recovery if necessary

Performed backups and restores on large-scale SQL Server databases

Implemented Log shipping on a few databases for off site reporting purpose

Moved the Log Shipping secondary databases to different drive due to disk space issue

Provided explicit permissions to specify tables to users in databases

Moved the Log Shipping secondary databases to different drive due to disk space issue.

Performed redirected restores of databases to Test, QA and development system

Supported and Clearing the database logs everyday

Performed monitoring and tuning T-SQL and database engines

Developed all the required stored procedures, user defined functions, and triggers using T-SQL

Maintained documents and implement Disaster recovery models

Built scheduled-jobs to migrate data from flat files to database

Environment: SQL Server 2008R2, Windows 2003 Advanced Server,SQL Profiler.

Bank of Oklahoma Tulsa, OK Nov 2008 to Sep 2010

Jr.SQL Server DBA

Bank of Oklahoma is financial services holding company in the West South Central region of the United States with more than 4700 employees and operations in ten states. BOK Financials holdings include BOKF, NA, BOSC, Inc. and the Milestone Group. BOKF, NA operates TransFund, Cavanal Hill Investment Management, MBM Advisors and seven banking divisions: Bank of Albuquerque, Bank of Arizona, Bank of Arkansas, Bank of Kansas City, Bank of Oklahoma, Bank of Texas and Colorado State Bank and Trust. BOKF, NA has full-service banks located in eight states offers consumer, mortgage, and commercial financial products

Responsibilities:

Administration and support on large number of SQL Server instances in multiple data centers including Production, Validation, QA, Staging, Test and Development Environment.

Installed MS SQL Server Performed Database Design and created User Databases

Worked mostly on Windows servers

Centralized the environment by fixing the issues with their necessary maintenance plans and service accounts.

Worked with Application System Managers directly and provide suggestions under database side

Involved in Planning/Implementation/Support for database migration from SQL Server 2005 to SQl Server 2008R2

Implemented Mirroring for critical operational databases to provide no data loss

Successful in implementing and setting up the replication (Snapshot/Transactional/Merge/Peer-Peer)

Implemented Log shipping by placing the secondary database in Read-only mode.

Configured and Implemented Active/Passive and Active/Active clustering for large size databases

Performed Monitoring with SQL Profiler and Windows System Monitor

Moved System databases to different drives for data security and availability

Available production support for 24*7 whenever required

Environment: SQL Server 2005/2008 R2, T-SQL, EXCEL, Power point, Windows 2008 Server, Visual Source Sate 6.0, ITSM, Foglight, Scom, Net App Snap manager, DB Monitoring Software Imperva

Bristol Myers Squibb Nov 2006 to Oct 2008

SQL Server Developer/DBA

BMS is a global pharmaceutical company with offices, research and development labs, manufacturing plants and distribution facilities located in almost every country around the world. The project was for the Sales department of BMS. Reports are created to provide Sales analysts with “Trend analysis” and “Benchmark with competitors” related data.

Responsibilities:

Developed backup restore scripts for MS SQL Server as needed.

Upgraded to latest version from MS SQL server 2000 to 2005.

Planned, defined and designed data flow processes for data migration to the Data Warehouse using DTS.

Created Database Objects – Tables, Indexes, Views, Triggers and Constraints.

Wrote various stored procedures for the purpose of application development.

Tuned SQL statements using Indexes and Stored Procedures.

Responsible for Disaster recovery and database maintenance plan.

Designed and implemented data access stored procedures and automating tasks.

Performed Job scheduling and alerts.

Optimized queries and performances using varies MS SQL Server tools such as SQL Profiler, SQL Performance Monitor, Execution plan and Index tuning wizard.

Created many complex Stored Procedures and used them in Crystal Reports directly to generate reports on the fly.

Created crystal reports and hosting it in the web for the users.

Environment: SQL Server 2000/2005 Enterprise Manager, SQL Query Analyzer, SQL Profiler, SSIS, MS ACCESS, Crystal Reports.



Contact this candidate