Resume

Sign in

Sql Server Data

Location:
Irvine, California, United States
Posted:
February 21, 2018

Contact this candidate

Resume:

Rajitha Yalla

SR Database Administrator

814-***-****

ac4kbf@r.postjobfree.com

IRVINE, CA, 92620

Professional Summary:

Over 10+ years of IT experience on Database Administration and development with MS SQL Server technology.

Hands on experience in Installation, Configuration and up gradation of SQL Server 2000/2005/2008/2012,2014 and 2016 technology, service packs and hot fixes on both physical, virtual and cloud.

Expert in using different recovery models simple, full and bulk-logged depending on availability of database.

Experienced and knowledge of high availability SQL Server solutions with SQL Server Failover Clustering, Database Snapshot, Log shipping, and Database Mirroring.

Expert in Capacity planning, Performance Tuning, Disaster Recovery, Troubleshooting, backup and restore procedures.

Hands on experience on managing sql server databases in Azure.

Solid experience in performance monitoring with Activity monitor, SQL Profiler, Performance monitor, Database Tuning Advisor, DMVs and DMFs, SQL Diagnostic Manager.

Good understanding in implementing different types of Replication Models such as Transactional, Snapshot, Merge and Peer to Peer.

Expert in automating the system by using SCOM and creating alerts, jobs and maintenance plans.

Expert in working in Data Center high availability servers.

Collaborated on numerous management initiatives, including Data Security, Data Management & Data Retention & Resource Tracking, Change Control, and Disaster Recovery Planning, High Availability.

Worked on administration tasks such as Data loading, batch jobs, Data unloading, backup and recovery, user and application table management, upgrades, creating Databases, file groups, files, transaction logs.

Experienced in creating and optimizing tables, indexes, schemas, views.

Extensive experience in managing the Database Security at granular level.

Hand full of experience in using third party tools like idera, Spotlight, Sql tuner, Sqlexpert, etc.

Expert in constructing triggers, stored procedures, user functions, views, indexes, user profiles, data dictionaries, and data integrity using T- SQL.

Worked on SQL 2008 database partitioning for existing large tables, deleting data from partitioning & indexes.

Worked on setting up CDC (Change Data Capture) for both auditing and Change Transfer to other

Database.

Extensive knowledge in developing and deploying ETL packages using, DTS, Informatica, SSIS for accessing heterogeneous data, data cleansing and auditing.

Expert in using MS SQL Server tools SSIS and SSRS.

Hand full of experience with Very Large Databases (VLDB)

Expertise in Data Modeling tools such as ERwin, MS Visio, and ER/ Studio Design Tool.

Expert in logical and physical modeling for OLTP and OLAP applications.

Ample of experience in data warehousing using star schema and snow flex schema.

Excellent verbal and write communication skills.

Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

Able to work independently and collaborate proactively & cross functionally within a team.

Education Qualifications:

BS in Computer Science, 2006

KITS Nagpur, Maharashtra, India

Skill set:

SQL Server 2000/2005/2008/2012,2014,2016, Windows Server 2000/2003/2008\R2/2012,, T-SQL, MS Access, Visual Studio, BIDS, Query Analyzer, CDC(Change Data Capture), Database partitioning, DTS, Erwin, SSIS, SSRS, Idera tools, SCOM, SQL Profiler, Database Tuning Advisor, Performance Monitor, Client Configuration Utility, Server Configuration Utility, MS Visio, MS Access, MS Office, HTML, Lite-speed, GRS (Global Resolution Services), Remedy, ISSAC, DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP), Power Shell, Share point

NCR (National Cash Register) SEP 2015 – Present

SR SQL SERVER DBA

Hardware/software: MS SQL Server 2000,2005, 2008, 2008 R2,2012, 2014 Enterprise Edition, 2016, SCOM, Business Intelligence Development Studio(BIDS) – SQL Server Integrated Services (SSIS), SSRS, SSAS, SQL Agent, SQL Profiler, Database Tuning Advisor, PowerShell, Database Mail, Notification Services, T- SQL, Windows 2003/ 2008/ 2012 server, Idera SQL diagnostic manager, Perfmon, Azure,AWS.

Projects Summary:

Responsibilities:

Installed, upgraded and configured SQL Server 2005, 2008, 2012, 2014 & 2016 including hot fixes.

Installed, configured and Managed Sql server databases in Azure cloud.

Tested new sql server 2016 feature database stretch in cloud to implement in one of the application.

Worked on High Availability and Disaster recovery Technologies

Worked on Performance issues on production servers

Installed virtual Sql server instances in 2 node & 4 node cluster environments.

Supported Critical application services & production database issues.

Performed proactive checks on Production servers during the expected busy days

Attended RCA calls with application owners on global issues to explain the root cause and fix.

Worked on database backups & restore using lite speed and native.

Implemented and maintained Transaction replication for high availability in all Production Servers

Created Log shipping setup for Production servers & also worked on other HA solutions like Mirroring.

Developed multiple stored procedures using T-sql which are used for in house applications.

Created multiple PowerShell scripts for both applications and for team to get critical server and database information quick.

Created SSIS packages to transfer data from different data sources.

Created copies of operational Databases using the Import/Export Wizard.

Migrated DTS packages to SSIS packages using package migration wizard.

Periodically (daily, weekly, or monthly) performed a database reorganization on all the indexes on all the tables in all databases to rebuild the Indexes so that the data is no longer logically fragmented.

Ensured security logins and database access permissions on databases which are with compliance data/red data.

Created and scheduling maintenance jobs in new environment.

Worked on SSIS & SSRS using data tool.

Provided support to numerous applications tuning stored procedures and modify them if necessary.

Provided 7x24 technical supports and on call to the production databases mission critical.

Documented the work and issues for the onsite offshore partners.

WORD AND BROWN, Orange, CA OCT 2014 -- SEP 2015

SR SQL SERVER DBA

The Word & Brown Companies revolutionized the health insurance industry with groundbreaking services and products and is recognized today as the nation’s leader in providing innovations that simplify and streamline an employer’s administration of health care programs. Headquartered in Orange, Calif., The Word & Brown Companies is an expert in all aspects of individual and group benefits distribution and administration.

Hardware/software: MS SQL Server 2005 2008 /2008 R2,2012 Enterprise Edition,SCOM, Business Intelligence Development Studio(BIDS) – SQL Server Integrated Services (SSIS),SSRS,SSAS, Azure, AWS Cloud, SQL Agent, SQL Profiler, Database Tuning Advisor,PowerShell, Database Mail, Notification Services, T- SQL, Windows 2003/ 2008/ 2012 server

Projects Summary:

Responsibilities:

Installed, upgraded and configured SQL Server 2008 & 2012 including hot fixes on both cluster and non-cluster environments.

Worked on query tuning for mission critical applications.

Supported Critical application services & production database issues and capacity planning.

Involved in project meetings during design phase and provided inputs on storage, RAM and CPU and sql versions to be used.

Performed data partitioning with sql technology.

Performed proactive checks on Production servers during the expected busy days

Worked on database backups & restore.

Implemented and maintained Transaction replication for high availability in all Production Servers

Created Log shipping setup for Production servers & also worked on other HA solutions like Mirroring

Created SSIS packages to transfer data from different data sources load it to data warehouse.

Periodically (daily, weekly, or monthly) performed a database reorganization on all the indexes on all the tables in all databases to rebuild the Indexes so that the data is no longer logically fragmented.

Reconfigured Log Shipping and Database Mail after migration.

Ensured security logins and database access permissions

Created and scheduling maintenance jobs in new environment.

Worked on SSIS & SSRS MS SQL Server tools.

Provided support to numerous applications tuning stored procedures and modify them if necessary.

Provided 7x24 technical supports to the production databases mission critical.

Documented the work and issues for the offshore partners.

ACCENTURE, Highlands Ranch, CO OCT 2013 – Sept 2014

SR SQL SERVER DBA

Accenture is one of the world’s leading organizations providing management consulting, technology and outsourcing services, with approximately 275,000 employees; offices and operations in more than 200 cities in 54 countries. Accenture helps organizations assess how to maximize their performance and works with them to achieve their vision.

Hardware/software: MS SQL Server 2008 /2008 R2,2012 Enterprise Edition,SCOM, Business Intelligence Development Studio(BIDS) – SQL Server Integrated Services (SSIS),SSRS,SSAS, SQL Agent, SQL Profiler, Database Tuning Advisor,PowerShell, Database Mail, Notification Services, T- SQL, Windows 2003/ 2008/ 2012 server

Projects Summary:

Responsibilities:

Responsible for Production Support DBA & taking care of all production Server issues like Creating & Monitoring backup, Reindex/Rebuild, update Statistics jobs

Worked on SQL Native & Lite speed backups

Supported multiple projects simultaneously suggesting capacity planning, performance strategy etc.

Configured DR on multiple applications based on the project requirement. DR includes mirroring, replication and database backup.

Installed, upgraded and configured SQL Server 2008/R2/2012 in cluster environment and VM server.

Making changes on production, production Servers, Test and DEV servers on Remedy RFC requests.

Generated reports from management data warehouse new feature in sql server 2008 for troubleshoot things.

Supported as SharePoint site databases administrator.

Attended support calls with application owners on global issues to explain the root cause and fix only project related.

All databases are backed up using Perl scripts invoked in sql agent jobs deployed them on new servers.

Worked with application team in finding slow running queries and tuned them.

Ensured security logins and database access permissions

Provided support to application tuning stored procedures and modify them if necessary.

Provided 7x24 technical supports to the production databases mission critical.

Documented the work and issues for the offshore partners.

.

Direct TV, El Segundo, CA NOV 2012---SEP 2013

SR SQL Server DBA

DIRECTV Latin America is a leading provider of satellite television services throughout Latin America. DTVLA is comprised of: Pan Americana, which provides services in Venezuela, Argentina, Chile, Colombia, Puerto Rico and certain other countries in the region through our wholly-owned subsidiary, DIRECTV Latin America, LLC, or DLA LLC; our 93% owned subsidiary Sky Brazil Services Ltda., which we refer to as Sky Brazil; and our 41% equity method investment in Innovate, S. de R.L. de C.V., or Sky Mexico. As of September 30, 2011, Pan Americana had approximately 3.8 million subscribers, Sky Brazil had approximately 3.5 million subscribers and Sky Mexico had approximately 3.8 million subscribers

Hardware/software: MS SQL Server 2008 /2008 R2,2012 Enterprise Edition, SCOM, Business Intelligence Development Studio(BIDS) – SQL Server Integrated Services (SSIS), SSRS, SSAS, DTS, SQL Agent, SQL Profiler, Database Tuning Advisor,PowerShell, Database Mail, Notification Services, T- SQL, Windows 2003/ 2008 server, Lite Speed, GRS(Global Resolution Systems)

Projects Summary:

Responsibilities:

Installed, upgrade and patch Sql servers on 2, 3, 4 node cluster and virtual servers (VMware).

Supported multiple projects simultaneously suggesting capacity planning, performance strategy and helping with project prebuild and pre buy.

Configured DR on multiple applications based on the project requirement. DR includes mirroring, replication and database backup.

Making changes on production, prod like, Test and dev server on HP Service desk.

Supported most critical DIRECTV applications like Order management System, HS, Tealeaf, EPC, CCBI and many other.

Supported SharePoint site databases maintenance and performance.

Attended RCA calls with application owners on global issues to explain the root cause and fix.

Took care of Microsoft Sql server licensing true up by closely working with Asset management team.

All databases are backed up using NetBackup and supported by creating .bch files on servers.

Worked with application team in finding slow running queries and tuned them.

Ensured security logins and database access permissions are optimal.

Provided support to applications by tuning stored procedures and modify them if necessary.

Provided 7x24 technical supports to the project servers and on call rotation.

Medtronic Inc, Mounds View, MN Oct 2010 – Oct 2012

SR SQL Server DBA

Medtronic, Inc. is the world's leading medical technology company, controlling more than half of the $8 billion global heart-pacing market, which includes pacemakers and defibrillators. As a DBA I maintained the databases which collect all the patient health data and device sales data in Care link project.

Hardware/software: MS SQL Server 2008 /2008 R2,2012 Enterprise Edition, SCOM, Business Intelligence Development Studio(BIDS) – SQL Server Integrated Services (SSIS),SSRS,SSAS, DTS, SQL Agent, SQL Profiler, Database Tuning Advisor,PowerShell, Database Mail, Notification Services, T- SQL, Windows 2003/ 2008 server, Idera Sql safe backup, Lite Speed, GRS(Global Resolution Systems)

Responsibilities:

Installed, upgraded and configured SQL Server 2008/R2/2012 in cluster environment and VM server.

Configured Log Shipping setup for production servers using third party tool Lite Speed & Native.

Backup and restore the Very Large Databases (VLDB) up to 3.9TB from old environment to new environment using Lite Speed & Native SQL server where ever there are new releases.

Worked on SQL 2008 database partitioning for existing large tables, deleting data from partitioning & indexes.

Implemented and maintained Transaction replication for high availability and worked on Replication related issues.

Created Notifications and alerts for replication jobs and out of sync issues.

Daily periodically monitored maintenance jobs from the mails setup.

Provided On call support switching between team members.

Configured Log Shipping using Native SQL server in production environment. Whereas standby server is used as reporting server.

Worked on SSIS & SSRS MS SQL Server tools and supported the developers.

Worked on setting up CDC (Change Data Capture) for both auditing and Change Transfer to other

Database.

Worked with Development & application teams in the time of Project releases.

Performed work through Remedy incident management tool based on the severity of the issues.

Ensured security logins and database access permissions to the users on time.

Created and scheduling maintenance jobs in new environments.

Configured SQL Mail and Database Mail to get automated Alerts in the production Servers.

Wrote and edited stored procedures, functions and triggers required for Sql agent jobs.

Using Power shell scripting to automate Replication, Log Shipping & some of the maintenance jobs.

Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.

We are using HIPPA (Health Insurance Portability and Accountability Act) to protect patients' privacy expectations under the policies and procedures.

Target Corp, Minneapolis, MN Aug 2007- Oct 2010

SQL Server DBA

Target crop is one of the biggest retail store business in USA. It had 1780 stores overall USA. All the stores and POS registers use SQL Server databases to ring the sales and update. The project is to support all the issues in store server, HQ server and DC servers installed with SQL Server 2000, 2005 and 2008.

Hardware/Software:

MS SQL Server 2000,2005,2008, SQL Agent, SQL Profiler, Database Tuning Advisor, Database Mail, System Center Operational Manager (SCOM)2007, T- SQL, Windows2003,2008 server, HPSD Incident management tool.

Responsibilities:

Installed, upgraded and configured SQL Server 2008.Suported store server refresh rollout including hot fixes.

Installed virtual Sql server instances in cluster environment.

Worked on incidents and WO’s from HPSD incident management tool through SCOM tool based on Priority of issue.

Supported stores and HQ application developers with production database issues.

Performed proactive checks on store servers during the expected busy days like Thanks giving Day and Christmas days.

Target has two datacenters with multiple application and database servers supported by our team.

Attended RCA calls with application owners on global issues to explain the root cause and fix.

All databases are backed up in to the legato servers tape drives.

Worked on data partitioning & CDC (Change Data Capture).

Supported cluster environment in Data center level. Two data centers with clustered.

Maintained all the maintenance jobs in all the servers.

Configured and altered alert configuration settings for the jobs and issues.

Backup and restore the databases from old environment to new environment.

Periodically (daily, weekly, or monthly) performed a database reorganization on all the indexes on all the tables in all databases to rebuild the Indexes so that the data is no longer logically fragmented.

Reconfigured Log Shipping and Database Mail after migration.

Ensured security logins and database access permissions

Created and scheduling maintenance jobs in new environment.

Worked on SSIS & SSRS MS SQL Server tools.

Working with Very Large Databases (VLDB) up to 2.9TB.

Provided support to numerous applications tuning stored procedures and modify them if necessary.

Provided 7x24 technical supports to the production databases mission critical.

Implemented and maintained Transaction replication for high availability in all stores.

Documented the work and issues for the offshore partners.

Provided support to replication environment to stores from enterprise server.

Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor for individual application developers.

Scheduled meeting with team lead and provided the reporting data like issues of the week.



Contact this candidate