Sql Server Manager
Resume:
Chandra Challa
*******.*****@*****.***
Professional Summary:
Performed migrations from SQL Server 2000 to 2005 and 2008 R2, SQL Server 2005, SQL Server 2008 to SQL Server 2012 and Expertise in installation, migration, applying Service Packs, Hotfixes and Critical Security Updates released by Microsoft.
Installed and maintained SQL Server failover clustering (active/active and active/passive) for SQL Server 2005 and SQL Server 2008R2, SQL Server 2012 versions and have a good understanding of SQL Server 2014 features always ON, user defined server roles.
Strong experience in monitoring database performance and tuning using various native tools namely Extended Events, Performance Monitor, Activity Monitor, SQL Profiler and Third Party Tools.
Experience in Query Optimization techniques using DMV’s and DMF’s, DBCC commands, Index Rebuild / Reorganising and also used tools to identify slow running queries using Server-side tracing.
Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting.
Experience on Database Mirroring and Log shipping, SQL Server Replication that is Snapshot, Transactional and SQL Server failover cluster installation.
Expertise in Business Intelligence including SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
Extensive experience in generating different type of reports including: parameterized reports, formatted reports, tabular forms, matrix forms, cached reports, drill-down reports, drill through reports, charts and sub reports using SSRS 2008/2008R2/2012.
Generated daily and weekly monthly reports involving customized and on- demand reports using SSRS and also involved in analyzing multi-dimensional reports in SSRS
Integrated and transformed data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 by creating SSIS packages.
Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Index, Views, User Functions, SQL joins, Relational Database Systems following Data Integrity and normalization.
Filtered bad and inconsistent data using complex T-SQL statements and implemented various constraints and triggers to maintain data consistency and to handle complex business rules, history data and audit analysis.
Created stored procedures and used Common Table Expressions (CTE) and various kinds of User Defined Functions (UDF) in the stored procedures to make the code easy to understand and reliable.
Configured Security at Active Directory and SQL Server by Mapping users to roles. (Securable and Permissions).
Experience in Production Support for very large (VLDB) and Complex Databases.
Provided Disaster Recovery through Replicated SAN and Multi Subnet Clustering.
Implemented SQL Server Failover Cluster Installation.
Has experience in using SCOM (System Center Operations Managers) for monitoring performance.
Has experience in 24*7 Production Support and in mentoring junior SQL developers.
Experience in analyzing blocking issues, concurrency and locking.
Have experience in all phases of software development life cycle including project management, functional requirements definition, technical design, development, testing, quality assurance, system certification, systems implementation and system validation.
Develop or modify SQL queries and stored procedures to meet business requirements and achieve desired performance
Worked in VB.NET, C#.NET environments.
Handled multiple SQL Instances on Cluster environment for Server Consolidation.
Performed Hardening of servers after migration of data.
Expertise in designing solutions using SSIS, SSRS and created Database Management warehouse, management data warehousing.
Strong working knowledge of IIS7.0 and Windows Server Administration.
Experience in working with ITIL Methodolodgies,Agile/SCRUM based product development teams, collect database requirements and provide solutions and recommendations for new schema, infrastructure or architecture.
TECHNICAL SKILLS
Languages
C, C++, DDL, DML, T-SQL,SQL, PL/SQL
RDBMS
MS SQL Server 2014, 2012, 2008R2, 2008, 2005, 2000, SSAS, SSIS, SSRS, MS Access.
Front End
HTML 3/5, CSS, MS Visual Basics 6.0, SharePoint 2010,2013
Middle Tier
Servlets, JSP, JAAS, JTA, JSTL, JTA, EJB 2.0/3.0,MSMQ, Microsoft .Net Technology.
Tool
Technologies
JIIRA, TFS, SSIS, SSAS, BCP, Red Gate, Lite Speed
IIS 7.0, MTS, ERWIN 4.0, VISIO 2007
Education:
Bachelor of computers science from Nagpur University, Nagpur, India
Certifications:
MCTS – Microsoft Certified Technology Specialist.
70-462: Microsoft SQL Server 2012 – Administrating Microsoft SQL Server
PROFESSIONAL EXPERIENCE
California Correctional HealthCare Services (CCHCS), Elk Grove, CA Feb 15 – present
MS SQL Server DBA/Dev.
Responsibilities:
Prepared Documentation for the Disaster Recovery plan.
Designed Data Integrator jobs with Error Handling and email notifications.
Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
Generated periodic reports based on the statistical analysis of the data using SQL Server Re-porting Services (SSRS).
Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
Managing alerts and security, Re-indexing/Reorganizing Indexes, performing DBCC checks.
Performed troubleshooting and fine-tuning of databases for its performance and concurrency.
Performed Scheduling jobs and monitoring and troubleshooting them.
Upgraded Instances to SQL Server 2014.
Performing query optimization and performance tuning using native tools like performance monitor, resource monitor, profiler, DMV’S and built in performance reports.
Resolving blocking and deadlock issues using activity monitor and system stored procedures.
Moving/Copying of Databases from one server to another server using Backup-restore, Attach and detach methods and refreshing databases in development, QA and stage environments using production backup.
Generated daily and weekly monthly reports involving customized and on-demand reports using SSRS and also involved in analyzing multi-dimensional reports in SSRS.
Worked on Subscriptions of Reports and automated the Jobs for Running the Reports.
Designed and Implemented ETL processes based on T-SQL, stored procedures, triggers, views, tables, indexes, constraints, user-defined functions and SSIS.
Performed Multi Server administration.
Setting up Clustered environment for SQL Server Administration.
Used Microsoft Technical Implementation Guide (STIG) to improve security.
Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, Index rebuild, reorg, horizontal and vertical partitioning.
Configured ALWAYS ON setup between different Data Centres and on Multi Subnet Cluster.
Created linked servers between SQL Server & Oracle 11g.
Used BCP utility to publish table output to text files.
Migrated VLDB’s from SQL Server 2008 R2 to SQL Server 2014 and SQL Server 2012.
Environment: SQL Server 2008R2/2012/2014, Windows Server 2008(x64), SQL Server Management Studio, Visual Studio 2013,T-SQL,VB Script, PowerShell, SQL Profiler, Hadoop, Big Data, No SQL databases,C#.NET, VB.NET.
American Driving Records, Rancho Cordova, CA Jun 14 – Jan 15
MS SQL Server DBA/ Dev.
Responsibilities:
Performed migrations from SQL server 2008R2 to SQL server 2012
Implemented and Maintained Clustering (active/active, active/passive) as a high availability procedure.
Implemented and Maintained Transactional and Snapshot Replication and Performed troubleshooting and fine-tuning of databases for its performance and concurrency.
Performing query optimization and performance tuning using native tools like performance monitor, resource monitor, profiler, DMV’S and performance reports.
Applying required Service Packs, Hotfixes and any Critical Security Updates in clustered and standalone servers and managing SQL server using PowerShell scripts
Creating logins and database users, roles and providing permissions to users and roles according to the requirement and security policy.
Has implemented TDE (Transparent Data Encryption) and column level encryption.
Deploying reports in reporting server and Creating and providing permissions to users on reports in a reporting server.
Configured report manager for creating report subscriptions, snapshots, and caching.
Uploaded Reports on to Report manager and Organized them based on Business Rules.
Integrated and transformed data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 using OLE DB connection providers by creating various SSIS packages.
Performed several transformations and data cleansing on data including fuzzy lookup, slowly changing dimension, union all, merge join and check points/break points.
Created SSIS packages to load data into staging table and data mart and also Performed logging in SSIS packages to capture error data and for error handling.
Performed Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
Created maintenance plans for Re-indexing/Reorganizing Indexes and for performing DBCC checks on databases and updating statistics for smooth execution of queries and purging old files for preventing space issue.
Designed scripts using T-SQL for getting information about history of backups and restoration, database space utilization, alert for critical errors or events, resource intensive queries and general monitoring and maintenance tasks.
Environment: SQL Server 2005/2008R2/2012, Windows Server 2008(x64), SQL Server Management Studio, Visual Studio 2013, T-SQL,VB Script, PowerShell, SQL Profiler, Activity Monitor, Data Collector,Performance Monitor, Database Tuning Advisor,C#.NET, VB.NET.
Chevron Corporation, Concord, CA Mar 13 – Jun 14
MS SQL Server DBA\SQL Developer
Responsibilities:
Responsible for installing and maintaining SQL 2008 R2 Cluster environment and Performed migrations from SQL server 2005 to SQL server 2008R2/2012.
Applying existing servers with relevant Service Packs, Hotfixes and any Critical Security Updates released by Microsoft.
Implemented High availability & Disaster Recovery procedures, Cluster (active/active, active/ passive), DB Mirror, Replication and implemented log shipping using Litespeed.
Used BCP utility to publish table output to text files and created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.
Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
Experience in configuring report manager for creating report subscriptions, snapshots, and caching and optimized Performance and Capacity planning of Various Data processes related to Reports.
Created Database Management Warehouse.
Uploaded Reports on to Report manager and Organized them based on Business Rules.
Environment: SQL Server 2005/2008/2008R2/2012, Windows 2008 server, Windows Server 2008(x64), SQL Server Management Studio, Visual Studio 2010, T-SQL,VB Script, PowerShell,SSRS, Crystal Reports, SSIS,SQL Profiler, Activity Monitor, Data Collector,Performance Monitor, Database Tuning Advisor,Tivoli storage manager, lite speed tool, C#.NET, VB.NET.
Standard Bank of South Africa, New York Dec 10 – Mar 13
SQL Server DBA
Responsibilities:
Managed and Administrated the SQL Server 2008/2008R2/2005/2000 production and Non-production servers.
Administered and maintained production/Development servers with more than 6 TB of database size with complex structures.
Performance metrics reports daily, weekly and monthly.
Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
Installed couple of SQL Server 2005/2008 on cluster environment.
Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
Rebuilding the indexes at regular intervals for better performance based on level of fragmentation.
Extensively worked on performance issues like update statistics, Auto Stats.
24/7 on call support.
Tuned servers to the peak for maximum performance by configuring memory and various server level parameters.
Extensively worked on extraction, transformation and loading of data from various data sources to SQL Server.
Environment: SQL Server 2008R2
Comprehensive Health Insurance Services, Inc. Reston, VA Sep 09 – Nov 10
MS SQL Server DBA
Responsibilities
Monitor Server capacity and Daily health checks for the Database servers.
General Maintenance i.e. Re-indexing/Reorganizing Indexes, Monitor and support client server databases on Windows 2003 server.
Used SQL script to find heavily fragmented indexes and have re-organized the indexes accordingly to get desired performance from the tables.
Created insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
Checking backups and making sure enough space on the disks and resolving space management issues and Troubleshooting failed jobs and Locking/Blocking issues.
Checking SQL Logs and Event Viewers for any errors.
Environment: SQL Server 2000/2005/2008, Windows Server 2003(x64),SQL Server Management Studio, T-SQL, Query Analyser, SQL Profiler, Performance Monitor, Resource,VB.NET
ICICI Lombard General Insurance, Bangalore, India Jan 07 – Aug 08
SQL Server Developer/Jr. DBA
Responsibilities:
Involved in the Migration of Databases from SQL Server 2000 to SQL Server 2005.
Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2005 database.
Created and optimized SSIS packages for data flow between SQL Servers.
Extensively used SSIS and DTS packages for Data Archiving.
Extensively worked on Extracting, Transforming and Loading (ETL) of Data from Excel, Flat file, Oracle to MS SQL Server using DTS Import/Export utility, BCP, DTS and SSIS Packages.
Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
Provide 24 X 7 dedicated support to all Production, QA & Development MS SQL Server Environments.
Automated and enhanced daily administrative tasks, including space management, backup& Recovery and performance monitoring.
Created alerts and notifications for system errors, insufficient resources, and fatal database errors.
Environment:
SQL Server 2000/2005, T-SQL, Excel, Advanced Windows 2003 Server & PVCS Version Control Management.
Contact this candidate