Data Sql Server
Resume:
Sunil Kumar Janjirala
add2k6@r.postjobfree.com
Professional summary:
8+ years of experience in Administering and Maintaining the MS SQL SERVER in Production, Development and Testing in Clustered and Standalone Server Environment.
Experience in Migrating SQL Server 2008 to 2012/2014/2016.
Experience in Deploying SQL server databases to SQL Azure.
Implemented Side by Side Migration of MS SQL SERVER 2000/2005 to 2008/2008r2/2012/2014.
Experience in SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016 and 2017.
Experience in Analysing monitoring purpose using SolarWinds Database performance analyser and Sentry1
Experience in PowerShell scripts and PowerShell AD with SQL server PowerShell extensions.
Expert in SQL Server S/W installation, applying patches, upgrading, configuring, trouble shooting of SQL SERVER on Windows 98/2000/03/08/12 servers and Clustered VMware Environments.
Experience in implementing DIASTER RECOVERY AND HIGH AVAILABLITY concepts like Native Log Shipping, Custom Log Shipping, Mirroring and Replication (Snapshot and Transactional).
Experience in analyzing and resolving Locks, Dead Locks and handling the Isolation Level and Concurrency Effects.
Good Knowledge in querying the databases using the PowerShell scripts.
Built multiple SSIS packages for data loading from OLTP to OLAP data warehouse
Hands on configuring Temp DB with considerable Memory and Raid Levels for better performance.
Experience setting up Clusters.
Experience with Index Optimization.
Experience in working on Performance tuning and Query Tuning.
Good working knowledge on Always On and T- SQL enhancements of 2012 features.
Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, Performance Monitor, activity monitor, Event viewer for performance analysis.
Experience in working on Core DBA.
Created Linked Servers between SQL Servers and to Oracle Databases, DB2
Experience in administrative activates comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Health Check, Indexing, Updating Statistics.
Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.
Configured Security at ACTIVE DIRECTORY and SQL SERVER LEVEL by Creating Principals (logins) and Mapping users to roles. (Securable and Permissions).
Experience in configuring Replication and troubleshooting the issues with transactional replication.
Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
Expertise in analysing and estimating the Execution Plan for better Query Optimization.
Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
Deployed and Debugged SSIS packages for import, export, and bulk insert data with transformations from various data sources.
Experience in generating Reports (SSRS) in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools.
Explicitly used third party tools like Litespeed, Spotlight, Commvault and Red gate.
Worked with a team of business analysts, data architects, application developers, ETL developers and testers, my objective was to deliver projects within scope, time and costs while following department standards, methodologies, and guidelines
Involved in all phases of the SDLC (software development life cycle).
Strong experience in mentoring with team members, documentation and 24/7 on call production support.
CERTIFICATIONS:
Microsoft Certified Solutions Associate
Certificate Number: G175-5475
TECHNICAL SKILLS
Languages T-SQL, My SQL, C#, ASP. NET, HTML, XML, C/C++, Java Script
Operating Systems Windows 2000/2003/2008/2012, UNIX (Sun Solar), LINUX
Databases MS-SQL Server 2000/2005/2008/2012/2014/2016, MS Access
ETL Tools Data Transformation Services, SSIS, SQL Azure
Reporting Tools SSRS, Business Objects
DB Utilities SQL Server Management Utility, Query Analyser, Profiler
Application Software Visual Studio 2005/2008/2012, Visual Source Safe, TFS, MS Office Suite
Third party Tools Spotlight, CommVault, Red gate, Lite Speed.
PROFESSIONAL EXPERIENCE:
Client: XPO Logistics, Chicago, IL Jan 14, 2019- Present
Sr. SQL Server DBA (Production Support/ Application DBA)
Description: XPO Logistics manages the end-to-end supply chain movement of goods for companies with multinational, national, multiregional, and local markets. It operates in two segments: transportation and contract logistics.
Responsibilities:
To manage and administrate SQL Server 2017/2014/2012/2008R2/2008R2 production /and Non-production servers.
Administer all the SQL Server Builds and Migration Process for the Application end as a team lead.
Working with team members, documentation and 24/7 on call production support.
Analyse for monitoring purpose using SolarWinds Database performance analyser and Sentry1.
Install and configure SQL 2017 servers in clustered and non-clustered environments.
Configure high availability like Always On, Clustering, and transactional replication. Resolve clustering and transactional replication issues.
Upgrade SQL server from SQL 2012 to 2017 using side by side migration techniques.
Create, schedule database maintenance plan using SSIS Maintenance plan task.
Configure and deploy SSIS Packages from Test to Production Environments.
Migrated one of Business unit servers from On Prem to Azure and configured Geo-Replication.
Configuring Elastic pool for Azure SQL databases to share the resources between databases.
Created Runbook for Index maintenance
Responsible for all On Prem and Azure deployments
Maintaining Storage accounts on Azure portal for each environment to store backup files
Write and develop on Stored Procedures, backup and restore data to prevent data loss
Develop and build SSIS packages for data loading from OLTP to OLAP data warehouse, to create incremental packages for loading net changes.
Providing Index recommendations and query recommendations for long running queries.
Implement and Maintain frequent DBA tasks like scheduling jobs, creating maintenance plans and check servers for optimizations and implement them.
Perform daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
Implement SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
Monitor all databases status including CPU, Memory, I/O, Space Management, Backup and Recovery.
Develop Automated Backup jobs and DBCC scripts for databases and transaction logs.
Responsible for Monitoring and Troubleshooting SQL Jobs, Scheduled Tasks, Disk spaces, error logs and making recommendations for performance improvement in hosted databases which involved index creation, index removal, file group modifications, and scheduling jobs to rebuild/reorg indexes and update statistics.
Apply native tools like DATA BASE TUNING ADVISOR, PROFILER, PERFORMANCE MONITOR and ACTIVITY MONITOR for performance tuning and work on Query Tuning.
Implement and execute successful Disaster recovery test for multiple databases to ensure redundancy of databases.
Design and develop SSIS packages using different control flow tasks, Transformations, and dataflow tasks, to schedule database maintenance plan using SSIS Maintenance plan task, to configure and deploy SSIS Packages from Test to Production Environments.
Environment: SQL Server 2008 and 2008 R2, 2012 and 2014, 2017 T-SQL, Access, SSIS, Windows 2005,2008 and 2012/14 Servers, Sentry1, Database performance analyser, Share Point, F5 Load Balance, .NET, VMware.
Client: United Health Group (Optum), Basking Ridge, NJ Jan 2018-Jan 08, 2019
Sr. SQL Server DBA/Programmer
Description: Optum is a health information technology and services firm that is part of UnitedHealth Group. It provides technological, operational, and consulting solutions and services to individuals, healthcare organizations, pharmaceutical companies as well as the federal and state governments.
Responsibilities:
Installation of MSSQL Server 2016, 2014 on Production, UAT and Development environments.
Managed and Administrated SQL Server 2017/2014/2012/2008R2/2008 production and Non-production servers.
Migrating SQL Server Instances using Powershell
Taking backups using Powershell
Generating Reports (SSRS) in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools.
Extracted data from internal data warehouse system to SSRS
Constructing more complex pipeline executions at the CLI (mastering the one-liner.) in Powershell.
Handful of experience in working on XML Data
Created, scheduled database maintenance plan using SSIS Maintenance plan task.
Configured and deployed SSIS Packages from Test to Production Environments.
Handful of experience in working on Stored Procedures
Backup and restore data to prevent data loss
Used DataMasking to mask Customers info.
Configuring high availability like Always On, Clustering, Database mirroring and transactional replication. Worked on resolving clustering, Database mirroring and transactional replication issues
Validation of Datatypes.
Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
Documentation, Training and mentoring the staff.
Actively participated in forums, newsgroups and as a volunteer in Technology Meetings.
Created Triggers for the Application
Handful of experience in working with Audit
Importing XML data by using SSIS
Handful of experience in working with Functions.
Importing XML data from XML file using OPENROWSET
Mirroring experience with both synchronous and Asynchronous and applying service packs.
Handful of experience in configuring Log shipping and troubleshooting the related issues.
Importing data from Excel, Access to SQL Server by using SSIS.
Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
Assigned for Database Optimization that involved re-engineering the databases, data and index organizing, performance tuning and query tuning
Environment: SQL Server 2008 and 2008 R2, 2012 and 2014, 2017 T-SQL, Access, SSIS, Windows 2005,2008 and 2012/14 Servers, Share Point, F5 Load Balance, JDE Application, .NET.
VMware.
Client: IAB (Interactive Advertising Bureau), New York Oct 2017- Dec 2017
Sr. SQL Server DBA/Developer
Description: The Interactive Advertising Bureau (IAB) empowers the media and marketing industries to thrive in the digital economy. Its membership is comprised of more than 650 leading media and technology companies that are responsible for selling, delivering, and optimizing digital advertising or marketing campaigns.
Responsibilities:
Managed and Administrated SQL Server 2014 production and Non-production servers.
Developing Script to find the sensitive Columns and to encrypt those columns.
Supporting Tableau team and Salesforce team.
Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
Working with team members, documentation and 24/7 on call production support.
Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
Analysed SQL Servers and Databases and came up with a plan for consolidation based on usage, performance, and compatibility.
Working on Performance tuning on some Stored Procedures where need.
Configuring high availability like Always On, Clustering, Database mirroring and transactional replication. Worked on resolving clustering, Database mirroring and transactional replication issues
Analyzing and resolving Locks, Dead Locks and handling the Isolation Level and Concurrency Effects.
Validating the Stored Procedures from Tableau and tuning when needed.
Validating the data in Salesforce and modifying the query if needed.
Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
Monitoring SQL server performance using profiler to find performance and deadlocks.
Created Stored Procedures, Triggers, Views and Functions for the Application.
Extensive testing on the Performance of the Stored Procedures.
Used SQL Sentry for Performance tuning.
Environment: SQL Server 2012 and 2014 T-SQL, Access, Windows 2012/14 Servers, Share Point, Tableau, Salesforce, .NET, VMware.
Client: MSU, East Lansing, MI Dec 2016-Sep 2017
Sr. SQL Server DBA
Description: Michigan State University is a public research university in East Lansing, Michigan, United States. MSU was founded in 1855 and served as a model for land-grant universities later created under the Morrill Act of 1862.
Responsibilities:
Implemented Side by Side Migration from 2008 to 2016
Creating and implementing multiple SQL Server Audits for Security.
Creating and implementing DDL triggers to get the notifications of permissions.
Creating and implementing PowerShell script to automate creating Logins and to Clone the permissions.
Developing Script to find the sensitive Columns and to encrypt those columns.
Developing, implementing, and periodically testing a backup and recovery plan for the databases
Extensively used Repositories like Team Foundation Server (TFS) and Visual Source Safe.
Installs revised or new systems by proposing specifications and flowcharts; recommending optimum access techniques; coordinating installation requirements
Make and test modifications to the database structure as needed
Maintain the database and update permissions
Worked on DataMasking for masking the Account information and Student Personal information.
Backup and restore data to prevent data loss
Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products
Ensure that builds are properly deployed in development, system, acceptance, and production environments.
Supports database functions by designing and coding utilities
Prepare test cases and strategies for unit testing and integration testing
Provide technical and functional support to testing teams
Assist Technical Writers in preparing project documentation
Follow best practices to perform application coding.
Environment: SQL Server 2008 and 2008 R2, 2012 and 2014 T-SQL, Access, Windows 2005,2008 and 2012/14 Servers, Share Point, F5 Load Balance, JDE Application, .NET.
VMware.
Client: Well Care Health Plans, Tampa, FL Jan 15 – Sep16
Sr. SQL Server DBA
Description: Well Care Health Plans focuses exclusively on providing government-sponsored managed care services, primarily through Medicaid, Medicare Advantage and Medicare Prescription Drug Plans, to families, children, seniors and individuals with complex medical needs.
Responsibilities:
Managed and Administrated SQL Server 2014/2012/2008R2/2008/2005 production and Non-production servers.
Used Red gate tools for data integration project, tools like Data Compare and SQL Compare to do a comparison of large schema and data sources and destinations. Also, bought and used whole Red gate SQL-Tool belt.
Created automation jobs using PowerShell scripts
Moving data between On-Premises to Cloud and vice Versa.
Worked in Fast-paced Agile Environments where we did lot of code deployments and code reviews.
Worked on Schema Designing.
Migrated Multiple Oracle databases to SQL Server Database using SSMA.
Working as a Team Lead in Handling all the SQL Server Builds and Migration Process for the Application end.
Real time trouble shooting production issues during on call schedule with minimum timelines in resolving issues.
Built multiple SSIS packages for data loading from OLTP to OLAP data warehouse.
Created Incremental packages for loading net changes only.
Administered and maintained Hr/Payroll s/w.
VMware administration (building new VMs, taking snapshots, and manage resources.
Configured and maintained network Load Balance for share point environment.
Worked on setting up active-active Clusters.
Worked as a team to maintain 100 percent up time to keep the environment running irrespective of any infrastructural changes in the environment.
Installed and configured SQL 2014/2008R2 and 2012 servers in clustered and non-clustered environments.
Worked on configuring high availability like Always On, Clustering, and Database mirroring and transactional replication. Worked on resolving clustering, Database mirroring and transactional replication issues.
Analysed SQL Servers and Databases and came up with a plan for consolidation based on usage, performance, and compatibility.
Upgraded SQL server from SQL 2005/2008 to 2008R2/2012/2014 using side by side migration techniques.
Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
Monitored all databases status including CPU, Memory, I/O, Space Management, Backup and Recovery.
Metasolv application support with back end SQL server.
Developed Automated Backup jobs and DBCC scripts for databases and transaction logs.
Responsible for Monitoring and Troubleshooting SQL Jobs, Scheduled Tasks, Disk spaces, error logs and making recommendations for performance improvement in hosted databases which involved index creation, index removal, file group modifications, and scheduling jobs to rebuild/reorg indexes and update statistics.
Used native tools like DATA BASE TUNING ADVISOR, PROFILER, PERFORMANCE MONITOR and ACTIVITY MONITOR for performance tuning and working on Query Tuning.
Configured the Report Server. Created, deployed, and managed reports using SQL Server Reporting Services (SSRS). Created Ad-hoc reports using SSRS.
Implemented and executed successful Disaster recovery test for multiple databases to ensure redundancy of databases.
Successfully participated in planning strategy for physical relocation of Datacentre
Designed and developed SSIS packages using different control flow tasks, Transformations, and dataflow tasks.
Created, scheduled database maintenance plan using SSIS Maintenance plan task.
Configured and deployed SSIS Packages from Test to Production Environments.
Environment: SQL Server 2005, 2008 and 2008 R2, 2012 and 2014 T-SQL, Access, Windows 2003 2005,2008 and 2012/14 Servers, Share Point, F5 Load Balance, JDE Application, .NET.
VMware.
Client: Social Interests, Sacramento, CA Jan'14 – Dec'14
Sr. SQL Server DBA
Description: Social Interest Solutions (SIS) is dedicated to improving access to quality health and social services through technology and policy solutions. SIS is a mission-driven, non-profit organization that puts the needs of clients and the populations we serve at the centre of our solutions.
Responsibilities:
Installation of MSSQL Server 2012, 2008R2 on Production, UAT and Development environments.
Code-reviews and performance tuning queries
Working on tickets\incidents within the SLA’s, as a part of operations support DBA.
Administered and maintained SSRS and Business Objects Environments for Reports.
Using ETL Tools like SSIS for the data Transformation.
Maintaining the database consistency with DBCC at regular intervals, Managed Disk space and memory and User connections and Monitored SQL server performance using profiler to find performance and deadlocks.
Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
Strong knowledge in working on Very Large databases (OLTP) and involved in troubleshooting the problems and dealing with complex databases.
Implemented & managed database clustering, failover as per client requirement Active/Passive & executed of any upgrade such as Service Pack, Hot fixes in Active/Passive clustering.
Mirroring experience with both synchronous and Asynchronous and applying service packs.
Handful of experience in configuring Log shipping and troubleshooting the related issues.
Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
Assigned for Database Optimization that involved re-engineering the databases, data and index organizing, performance tuning and query tuning.
As a part of the team, configured Transactional Replication with multiple publishers and centralized subscriber for real time reporting.
Also implemented Mirroring for DR Plan.
Good knowledge and handful of experience in configuring and working with Always on Availability Groups.
Created numerous reports using reporting services SSRS and deploying them on SharePoint.
Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments.
Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
Handful of experience in PowerShell Scripting.
Creating Logins and Roles with appropriate permissions. Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
Resolving blocking and deadlocks using DMVs, Profiler and killing respective SPIDs and optimizing the queries, which are involved in blocking and deadlock issues.
Good knowledge and handful of experience on implementing Always on High availability starting from SQL 2012.
Scheduling SQL Server Agent Jobs for updating statistics, checking fragmentation, checking database integrity and backup plans.
Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
Involved in capacity planning, sizing, and database growth projections.
Monitor and modify performance using execution plans and Index tuning.
Optimize the performance of queries with modifications in T-SQL queries, remove unnecessary columns, eliminate redundant and inconsistent data, and normalize tables.
Interacting with development team in writing good standard TSQL queries.
Applied patches, hot fixes, cleared .NET framework corruption errors.
Documentation, Training and mentoring the staff.
Actively participated in forums, newsgroups and as a volunteer in Technology Meetings.
Good Knowledge in implementing SQL database in SQL Azure cloud computing platform.
Extensively worked on Active-Active and Active-Passive Clustering
As a part of the team, was always involved in production deployment or production release.
Technical Analysis, Code Review, Implementation, 24 x 7 production support.
Environment: MS SQL Server 2005, 2008R2, 2012, TSQL, OLTP, OLAP, Windows 2008, Spotlight, Lite Speed, Fog light, SSIS, SSRS, SSAS, Visio 2007.
Client: Selective Insurance, Branchville NJ Oct'11- Dec'13
SQL Server DBA
Description: Selective is a customer focused, regional company providing a broad range of insurance and alternative risk management products and services. Selective offers commercial insurance for small and medium sized business, light industry, and public entities represent 85% of company's insurance options.
Responsibilities:
Implemented SIDE BY SIDE Migration of MS SQL SERVER 2000 to 2005/2008 on Windows
Migrated DTS 2000 PACAKGES to SSIS packages and maintained the archival data using Control flow task.
Configured the AWE and /3 GB switch for the 32-bit 2005 server.
SQL Server 2005 x64-bit Failover Cluster Installation on Windows Server 2008 x64-bit.
Experience with Cluster Configuration in SAN environment.
Applied Patches and Service packs to update different versions of MS SQL SERVER.
Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
Implemented native log shipping on MS SQL SERVER 2005.
Scheduled regular BACKUP JOBS and kept track of DATABASE by receiving the emails on Alerts.
Implemented the new concepts like Data partitioning, Snapshot Isolation, Database Snapshot, DDL triggers, Try-Cache blocks, Online Indexing, DMV’s, DMF’s, DTA, SQLCMD and dedicated admin connection, Common table Expression (CTE).
Implemented DATABASE MIRRORING ON MS SQL SERVER 2005.
Moved files between the File Groups and partitioned the tables to improve the performance.
Extensively used LiteSpeed backup with MS SQL SERVER 2005.
Used Spotlight from quest to perform data base health checks.
Utilized the new features of 2008 like TCE, EKM, MERGE STATEMENT and Compressed Backups.
Documented and performed the data base health checks regularly.
Created new tables, stored procedures, and triggers IN T-SQL.
Refactored and fine-tuned the queries and stored procedures in T-Sql.
Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
Implemented log shipping for Production server data base as part of the disaster recovery.
Created baseline and sampling intervals in the perfmon considering threshold values of the counters.
Rebuilding indexes with different fill factors and update statistics manually.
Implemented native log shipping for HIGH AVALIBLITY of the Production Server DATA BASE.
Generated reports in SSRS using BIDS (Business Intelligence Development Studio).
Rendered DRILL DOWN, STATIC reports in MATRIX form in SSRS.
Used SSIS packages to move data from dev to QA and QA to Production.
Deployed maintenance plans for regular DBA activities in SSIS.
Scheduled night jobs for importing large amount of data using SSIS Packages.
Deployed SSIS package for bulk insert and maintained archival data with file system task.
Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
Environment: TSQL, MS SQL SERVER 2000/2005/2008/2008R2, SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET, C#, WINOWS SERVER 2008.
EDUCATION:
B.S in Computers, Kakatiya University, India. 2011
Masters in Informational Technology, Schiller International University, USA.
Contact this candidate