Sql Server Data
Resume:
NIKHIL P
SQL Server DBA
acu4w6@r.postjobfree.com
SUMMARY:
Over 8+ years of IT Experience in SQL Server database administration, System Analysis, Design Development and Support of Microsoft SQL Server 2014/2012/2008R2/2008/2005 in Development, Test, Production and Cluster server Environments.
Experience in working with different domains such as health, insurance and retail domains.
Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2014/2012/2008/2008R2/2005.
Experience in using SQL Server Tools like Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.
Experience in implementing and monitoring different types of Disaster Recovery and High Availability techniques such as Mirroring, Log shipping, Replication (Snapshot, Transactional, Peer to Peer & Merge).
Installed and maintained SQL Server Failover Clustering (active/active and active/passive) in Production, QA and Dev environments for SQL Server 2008, SQL Server 2008 R2 and above versions.
Knowledge on implementing high availability with Always on Availability Groups.
Experience working in VM, ASP Environments.
Worked in OLTP and OLAP environment that includes Production, QA and development databases in SQL Server.
Strong SQL Server Developer Skills including writing Transact-SQL Queries, stored procedures, user defined functions, views and Good understanding of Normalization /De-normalization, Database design and modeling (logical and physical).
Experienced in Administering, configuring and managing SAN, EMC storage for backups and disaster recoveries.
Used Microsoft Azure using PowerShell to generate query results for SQL Server.
Have extensive experience in DBCC and DMV’s to check the health of the server.
Expert in creating Logins and Users as per client’s policy and requirements and in assigning roles as needed according to the project plan.
Expertise in Database Backup and Recovery procedures by using Native, TDP/TSM and Lite Speed to/from Disk /Legato server (Tape).
Experience in PowerShell scripts and PowerShell active directory with SQL server PowerShell extensions.
Very Good Experience working with SCOM Monitoring tool.
Good knowledge in using ticketing tools like BMC Remedy, Service Now (SNOW).
Expert in using third party tools like Lite Speed, Red Gate to speed up backup operations.
Extensively used tools like SSMS, SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
Experience in using Performance Monitor/Profiler to resolve Dead locks/Long running queries, and also good experience in data (table) partitioning
Implemented the SQL Server 2008 concepts like Data partitioning,Snap shot isolation, database mirroring, Default trace, change data capture(CDC), File stream, database snapshot, DDL triggers, try-catch blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA,SQL CMD and dedicated admin connection.
Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC, Re-indexing, Updating Statistics and online indexing.
Knowledge of indexes, index management, and statistics.
Expertise in DBCC Trace Flags and Blocking situations.
Good Knowledge in querying the databases using the PowerShell scripts.
Experience in data modeling like physical data modeling and logical data modeling by using ERWIN tool.
Good experience on physical storage configuration and optimization of SAN with different RAID levels.
Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
Research on extended events subjects to monitor the CPU performance consumption and deadlock information on the servers with disabling trace flags.
Checking the threshold values and baselines and monitoring in performance monitor and SCOM.
Expertise in implementation of security models; Database authentication modes, creation of users, configuring permissions and assigning roles to users.
Expert in Extraction Transformation Loading (ETL), Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
Experience in managing Alerts, Operators and Jobs through SQL Server Agent.
Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
Experience in providing 24X7 on call support on weekly rotation.
TECHNICAL SKILLS:
Databases: MS SQL Server 2005/2008/2008R2/2012/2014, Microsoft Access
Operating Systems: Windows server 2003/2008/2008R2/2012.
Database Tools: SQL Server Management Studio (SSMS), SQL Server Business
Intelligence Studio (BIDS), Enterprise Manager, SQL Profiler, Query Analyzer
ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),
SQL Server Analysis Services (SSAS).
Data modeling Tools: Erwin, MOM, Tivoli.
Backup Tools: Lite Speed, Red gate.
Monitoring Tools: SQL Sentry, Solar winds ignite DPA, SCOM and BMC Remedy.
Programming Languages: SQL, TSQL, HTML, CSS, JavaScript.
EDUCATION:
Bachelors of Technology from SRM University, Chennai, India
WORK EXPERIENCE:
Client: FedEx Corporation, Collierville, TN. Apr 2015- Present
Role: Sr. SQL Server DBA
Description: FedEx Corporation is an American global courier delivery service company headquartered in Memphis, Tennessee. The name "FedEx" is a syllabic abbreviation of the name of the company's original air division, Federal Express, which was used from 1973 until 2000. The company is known for its overnight shipping service, but also for pioneering a system that could track packages and provide real-time updates on package location (to help in finding lost packages), a feature that has now been implemented by most other carrier services.
Responsibilities:
Administrated and Managed SQL Server 2014/2012/2008R2/2008 databases in Production, QA and development environments.
Administrated 106 servers, 900+ databases with 8 Data Domains.
Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
Worked with the Windows, VM and SAN, Networking, Security teams for building new servers and migrating servers.
Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
Installed and configured a SQL Server 2012 clustered environment with availability groups.
Migrated and configured SQL Server 2008 R2 to SQL Server 2012 on a Clustered and Standby Environments.
Handled Responsibilities like installing, configuring and maintaining SQL server 2008 R2 Active/ Passive cluster.
Involved in implementing and monitoring different types of Disaster Recovery and High Availability techniques such as Mirroring, Log shipping, Replication.
Solving Tickets on Daily Basis for Production Issues.
Responsible for Stored Procedures optimization, Performance tuning & index tuning.
Administrator tasks like managing users, roles and permissions. Extensively worked on Replication for synchronization of databases for SQL Server High Availability.
Created Logins and Users as per client’s policy and requirements and assigned roles as needed according to the project plan.
Performed data partitioning for efficient management of database tables and indexes.
Involved in complete database design including conceptual, logical and physical models.
Creating DTS Packages for data import/export, scrubbing and scheduled jobs for backups.
Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
Used third party tools such as Lite Speed to speed up backup operations.
Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages.
Used functions to create predefined conditions and prompts to filter the data and dynamic user selection.
Deployed and Debugged SSIS packages using BIDs 2008R2 and scheduled jobs for these packages.
Implemented security policies for SSRS reports.
Have experience in enabling and disabling TDE encryptions.
Involved in creating Cubes using SQL Server Analysis Services (SSAS).
Created the reports using Business Objects functionality's like Queries, Sub queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc.
Responsible for providing 24X7 on call production support on weekly rotation
ENVIRONMENT: MS SQL Server 2008/2008R2/2012/2014, Windows server 2008/2012, SSIS, SSRS, SCOM, Lite Speed.
Client: American Stock Transfer and Trust Company, Brooklyn, NY Oct 2013 - Mar 2015
Role: SQL Server DBA
Description: American Stock Transfer & Trust Company, LLC provides stock transfer and employee plan services to public companies in the United States and internationally. It offers transfer agent services that include transfer agency and registrar, investment plan, closed-end mutual fund, disbursement agent, initial public offering, and shareholder services, corporate action and reorganization administration services, such as tender, paying agent, exchange agent, subscriptions, divestitures, and trustee services and proxy and annual meeting services. The company also provides employee plan services, including stock option plans, restricted stock awards and units, performance awards, employee stock purchase plans.
Responsibilities:
SQL Server 2005/2008/2008R2/2012 Database Development and Administration.
Responsible for providing 24X7 on call production support on weekly rotation to 30+ Production, development, 20+ Testing and Clustered servers.
Used log shipping, Always on Availability Groups and Replication for synchronization of databases.
Worked with Transactional Replication to achieve Load balancing using network authentication.
Responsible for Performance tuning of SQL servers and application issues related to migration.
Administrated and managed HA- clustering which is two node active-active and active- passive clusters.
Monitoring SQL server performance using SQL Server profiler to find long running queries and dead-locks.
Daily routine Developer/DBA tasks like handling user’s permissions, monitoring Blocking, Deadlocks, Long running jobs, and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
Managing alerts, managing security, Re-indexing/Reorganizing Indexes, performing DBCC checks.
Managing the locking/blocking and space management issues.
Moving/Copying of Databases from one server to another server using Backup-restore, Attach and detach methods.
Solving Tickets on Daily Basis for Production Issues.
Implementation of SQL Logins, roles and Authentication Modes as a part of Security Policies for various categories of users.
Involved in various projects from start to production deployment, guiding development team for efficient performance and planning capacity.
Worked with Partitioning Techniques to allow the SQL Server engine to escalate locks to the partition level before the table level.
Debugged Stored Procedures and (DDL /DML)Triggers, Functions as per client requirements
Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
Extensively used DBCC and DMV’s to check the health of database in regular basis.
Proficient Development skills (SQL, TSQL, Stored Procedures, and Triggers) for the purpose of providing development support and application tuning.
Worked with SQL development team by Designing and creating SQL Database, tables, indexes, and views. Created User Defined Functions, Stored Procedures, and Triggers.
Created jobs on various activities like backup, maintenance.
Developed Backup and Restore scripts for SQL Server 2012
Maintained Production and Test Database Environment in SQL server 2008R2/2008/2005.
Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
Experience with backups, restores and recovery models.
Environment: MS SQL Server 2012/2008 R2/ 2008/2005, T-SQL, Erwin, SSAS, SSIS (ETL), SSRS, Windows 2003, 2008 and 2012 Servers.
Client: United Health Care, Atlanta, GA Jun 2012 – Sep 2013
Role: SQL Server DBA
Description: United HealthCare is an American diversified managed health care company based in Minnetonka, Minnesota. United HealthCare is the largest single health carrier in the United States. It was created in 1977, as United HealthCare Corporation (it was renamed in 1998), but traces its origin to a firm it acquired in 1977, Charter Med Incorporated, which was founded in 1974.
Responsibilities:
Coordinated physical changes and performance monitoring of two replicated production servers, two development servers and one reporting server, all Microsoft SQL Server 2005/2008/2008R2.
Migrated databases from SQL Server 2005 to SQL Server 2008/2008R2 and documented the process during Pre-Migration and Post-Migration steps.
Administrated and managed HA- clustering which is 2 node active-active.
Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic sql queries.
Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.
Configured Security by creating Logins for ACTIVE DIRECTORY and SQL SERVER LEVEL by Creating Principals (logins) and Mapping users to roles. (Securable and Permissions).
Experience in using the DMV’s, DMF’s, SP PROCS, INFORMATION SCHEMA, and SYSTEM VIEWS AND in built GLOBAL VARIABLES for the instant analysis.
Utilized fog light for monitoring the deadlocks, blockings and windows level performance also.
Responsible for all database architecture and program design, including survey systems, report developers, OLAP cubes, and interfaces with clients’ CRM software.
Responsible for backups/restores, monitoring SQL uptime.
Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability.
Debugged triggers and stored procedures to improve the overall efficiency.
Profiled and tuned servers on a monthly basis to ensure fast queries and reports.
Evaluated OLAP tools, and built web-based OLAP cube reporting systems around it.
Created web-based dashboard to show reports produced, average report run time, emails sent, surveys taken, etc.
Wrote, designed and produced customer site allowing customers to view reports, place orders, download newer software versions, and set up their own surveys.
Created company intranet with help desk ticket and order tracking.
Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.
Implemented load balance web servers for high availability.
Evaluated and purchased reporting systems including Actuate, Case Studio, Visual Studio .NET, Net Charts, and UML diagramming.
Wrote installation and procedural manuals for support staff.
Created linked servers between Oracle 10g and MS SQL SERVER 2008 and also deployed SSIS packages for data transfer.
Environment: SQL Server 2005/2008/2008R2, SQL Profiler, T-SQL, SSIS, SSRS, SSAS, ERWIN, MS office
Client: Vision Systems Inc, Bangalore, India Jun 2010 - Apr 2012
Role: Jr. SQL Server DBA/ SQL Developer
Description: Vision Systems is a global information technology (IT) services company providing IT consulting, technology and outsourcing services. Using our enhanced global delivery model, innovative software plat forming approach and industry expertise, we provide high-value IT services that enable our clients to enhance business performance, accelerate time-to-market, increase productivity and improve customer service.
Responsibilities:
Installed and configured edition of SQL Server 2005/2008 like Enterprise edition.
Migration of databases from SQL Server 2000/2005 to SQL Server 2008.
Successfully migrated from SQL Server 2005 to SQL Server 2008 on Development and Testing Environment.
Involved in designing of Conceptual Logical Model and Physical Model.
Worked actively on the Clustered Environment.
Handled up to 500 GB Size databases with clustered and log shipping environment
Migrated new database structures, such as tables, indexes and stored procedures from development to the production environment.
Tuned stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
Monitored database system details within the database, including stored procedures and execution time and implement efficiency improvements.
Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, Mirroring, database integrity verification, indexing and statistics updates.
Redesign of database architecture with help of Microsoft Database development group and internal staff to increase application concurrency and performance.
Implemented transactional replication to enhance the failover capabilities increased over all database manageability and improved performance.
Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated.
Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
Creating logins and roles with the appropriate permissions.
Monitoring & Analysis of SQL Log, Performance counters and Performance Tuning for all development and staging environment.
Responsible for resolving blocking and locking issues.
Successfully implemented database mirroring between Primary server and Mirror Server.
Implemented log shipping in standby mode to support DR servers.
Environment: Windows 2003, MS SQL Server 2005, SSRS, SSIS, SSAS, Erwin, SQL Server Profiler.
Client: TRIPOD SOFTWARE SOLUTIONS, HYDERABAD, INDIA Aug 2008 - May 2010
Role: SQL Server Developer
Description: Tripod Software solutions led by certified professionals with expertise in Research, Design, Development and Delivery of high-end Technology Solutions, has achieved the rank of global thought leaders in IT Services.
Responsibilities:
Studied and understood the requirements of the information required by company’s Procurement Department about the vendors.
Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions
Data migration (import & export – BCP) from Text to SQL Server.
Normalization and De-Normalization of tables.
Developed Backup and Restore scripts.
Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
Worked with developers on how to write better SQL, how to use more powerful features like table variables, how to avoid cursors, etc.
Written T-SQL queries for the retrieval of the data.
Worked with fellow developers in rewriting procedures, functions, triggers, table partitions, views for better functionality.
Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.
Used many transformations like Data Conversion, Derived Column, Conditional split, Multicast, Sort,Merge,Union All, Fuzzy Lookup, Fuzzy Grouping and also used For loop, For each Loop, Sequence container and Execute SQL task etc.. I have hands on experience with BIDS.
Have good experience in SSRS reporting and also generated different kinds of reports like Tabular Reports, Matrix Reports, Parameterized Reports, Ad-hoc Reports, Drill down Reports, Drill through Reports, Sub reports, List & Chart reports as well as interactive reports according to business requirements in time restricted environment.
Created and executed the stored procedures and complex queries for reports.
Environment: SQL Server Enterprise Edition/ SQL Server 2005, Crystal reports, T-SQL & Windows 2K platform.
Contact this candidate