Sql Server Manager
Resume:
Sunil B Krishnappa
*******.******@*****.***
SUMMARY:
IT Professional with 4 years of experience in SQL server Database Administration and SQL Server development
Experience in installation, maintenance of different versions of SQL Servers (2016, 2014, 2012, 2008R2/2008/2005/2000) in both OLTP and OLAP lower regions and Production environments
Implemented High Availability & Disaster Recovery techniques like Always-ON Availability Groups, Clustering (Active-Active and Active--Passive), Database Mirroring, Transactional Replication and Log Shipping.
Upgraded SQL Server databases from SQL Server 2000/2005 to SQL Server 2008R2/2012/2014/2016.
Hands on experience in working with MSSQL SERVER 2005, 2008 and 2008R2 features and extensive knowledge on SQL 2012/2014/2016 new features.
Expertise in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, and databases Maintenance.
Expert in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon.
Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks.
Experience in Physical and logical data modeling using ERWIN & VISIO.
Experience in developing and tuning SQL Server Integration Services (SSIS) packages and SSRS reports.
Configuring and maintaining Report Manager and Report Server for reporting services.
Experience in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions according to the requirement.
Handled numerous Change Management requests on production servers and Supported 24 X 7 Production on Call.
Learnt and working knowledge on Cloud based environment for SQL Server (AWS).
Documenting procedures in run books.
TECHNICAL SKILLS:
Operating Systems:
Windows Vista/XP/2000/NT, Server 2003, Server 2008/2008 R2, Server 2012, Server 2012 R2, Exchange 2003, Linux, Unix.
Databases:
MS SQL Server 2014/2012/2008 R2/2008/2005/2000/7.0, MS Office Access 97/2000/2003.
ETL & REPORTING Tools:
SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)
Database Tools:
SQL Server profiler, SQL Query Analyzer, Database Engine Tuning Advisor, Data Index Analyzer, SQL Server Management Studio.
Third Party Tools:
Idera V5.2\7.1\7.2.2, Companion,lite speed, Red gate, VERITAS NetBackup, Erwin r7, TSM\TDP
Languages:
T-SQL, PowerShell, C/C++, Java, PERL, Visual Studio2005/2003, Python
Applications:
Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer.
EDUCATION:
Bachelor of Engineering in Electronics and Communication Engineering, SVCE, India
PROFFESSIONAL EXPERIENCE
XO Group Inc. Jan 2017 – till Date
Austin, Texas
Sr. MSSQL Server DBA
The knot, The Nest, The Bump: Inspire, inform, cheer community as they move towards their life amazing milestone. From proposals to creating home and starting a family together, to be there for every moment of journey.
Responsibilities:
●Managed users and permissions for both SOX-compliant and non-audited database instances.
●Provision of support for developers and end-users when faced with performance issues
●Managed backups and ensured recoverability by testing the restore process periodically
●Performed regular maintenance to ensure reliability and performance for database instances
●Installed and configured new SQL Servers as needed to support business purpose
●Installed, Manage and troubleshoot multi node multi-site SQL Server clusters
●Configuration and troubleshoot Always on involved SQL Server replicas
●Migrated company SharePoint 2010 farm to SharePoint 2013 farm where content databases were stored on Availability databases with secondary allowed to be read
●Deployed database change scripts provided by third party vendors as well as internal support/developers requested through JIRA ticket tool
●Automated Import and export of data via SSIS packages with Data to be filtered as parameters
●Dealt with huge dataset involved data retrieval Performance issue after analyzing database objects like Views, stored procedure and long running queries to go with deep analysis for execution plan of the query and to support with hints to suffice the optimizer to pick the best plan to execute query under concern.
●Troubleshoot of DTS packages and SSIS packages with few tweaks that would enhance the credibility of SSIS packages used
●Suggested huge data set to be queried after partitioning with creating a partition function on period of data for DataMart and Data warehouse (as there would be archived data as well) so they reduce difficulties of dealing with huge data being retrieved for cache by optimizer to hold on usage of server resources for processing the query
●Deployment performed on relational database systems (RDS) of SQL server on AWS environments and maintenance of those SQL Server instances as well
●Audit of dormant account was created as a report to track unused account logins to be removed there by reducing security risk across servers
●Experience with supporting related SQL Server Features (Reporting, Integration, and Analysis Services) and developed solutions as necessary for Reporting and Integration Services
●Provide on-call operational support for database systems via PagerDuty to log critical incidents to have record of audit and log issues faced as Primary contact
●Worked with team for VMWare experience, including building VMs as well as supporting the VM and add storage space
●Learning prospect for MongoDB was provisioned
Environment: MS SQL Server 2005, 2008 R2, 2012,2014, 2016, Windows 2003 Server, Windows 2008/2008 R2, Windows 2012/2012R2 Server, Linux, MS Visual Studio 2010, SSIS Packages, Excel, HTML, Idera SQL Secure, SQL diagnostic manager, JIRA, PagerDuty, PasswordState.
PepsiCo Inc. [HCL America Inc.] Sep 2016 –Dec 2017
Plano, Texas
MS SQL DBA
Branded with thoughts to build entrepreneurs with the ideas within themselves a team of HCL came forward to support infrastructure of PepsiCo Inc. to support and HCL is one of the Top notch company in the field of IT infrastructure globally. This is inclusive of marketing sectors India, North America, Russia, Europe, and Middle-East Asian Countries.
Environment: MS SQL Server 2005, 2008 R2, 2012,2014,2016, Windows 2003 Server, Windows 2008/2008 R2, Windows 2012/2012R2 Server, Linux, Unix, Oracle, SQL Toad MS Visual Studio 2010, SSIS Packages, Excel, HTML, NetBackup tool, Guardium tool, Nimsoft Tool, HP Service Manager, Informix, IBM DB2.
Responsibilities:
●Our inventory is huge consisting of more than 3500 MS SQL servers globally
●Installed, managed and administrated the MS SQL Server 2016/2014/2012/2008/2005 Production and Non Production Servers
●The Customer Loyalty program is developed for Retail Industry. This system automates Customer enrollment, Partner Management, Customer transactions, their Points management, Shipping, Points Bonus and Campaign Management. This system involves an OLTP system and Data Warehouse system for Campaigns
●Extensively worked on Migration of 72 legacy SQL Server Inplace migrations after application compatibility check with one step MSSQL server 2005 with sp4 to MSSQL 2014 migration, Also side by side migration for few applications.
●Worked with DTS packages to load the massaged data into Data warehousing system.
●The project involved Manufacturing and Logistics solutions with planning and scheduling for stuffing, destuffing, Billing, vendor-managed inventory and warehouse management
●Handled up to 2.5 TB size database in Active Passive clustered Environment.
● Used NetBackup Tool for backups and maintenance jobs which includes updating statistics, database integrity checks
●Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases.
●Created Logins for the users and manage their permissions.
●Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
●Used Bulk insert to load huge tables.
●Worked in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options
●Implemented partitioning on large table to get the performance.
●Created missing indexes on the tables by running Data Base Engine Tuning Adviser.
●Finding and solving locks and Deadlocks by using DMV’s and DBCC commands.
●Performed Migrations for almost about 80 PEPSICO Inc. legacy database SQL Server migration from SQL 2000/2005 to SQL Server 2012/2014 databases, after running the server side trace to know about the depreciation factors and announcements
●Extracted data from various sources like SQL Server 2008/2012/2014, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
●Created SSIS packages for File Transfer from one location to the other using FTP task.
●Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
●Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
●The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
●Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.
●Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
●Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
●Involved in performing Audits and recovery operations of SSAS objects.
●Assess the risks and recommend/ install service packs or hot fixes when needed.
●Guardium Tool for Auditing and security Purpose across the servers in the inventory.
● Configured Transactional Log Shipping between Primary and Secondary Servers depending on the business requirements.
●Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
●Configured Bi –directional transactional replication and have resolved many of the issues related to replication
●Created Numerous known error records to problem tickets
●Nimsoft tool used to alert as a ticket for all the parameters set to look after the MSSQL server in organized way
●Faster Delivery rate of the resolution and critical thinking was also as a part of Experience as part of the project.
●ITIL Tool HP Service Manager was used to create Incident, Service and Change-Requests for all the issues and they would be updated with the solutions respectively and resolved.
Cambridge Associates LLc. Jan 2016 – Aug 2016
Arlington, VA
MSSQL Server DBA
A stock market enterprise with various potential clients and various markets as well across world, share\stock data were residing in place to build Portfolios in business market and there were many applications that were in house to maintain this data and impart needable on application front end website for client users.
Environment: MSSQL Servers 2012, windows Server 2012/2012R2, Spotlight, SQL Data Compare, SQL Compare, Report Sync., PowerShell ISE, Microsoft Visual Studio, Amazon Web Services (knowledge)
Responsibilities:
●Always-On High availability environment with three clusters of two nodes, with two clustered nodes in one domain and rest in another domain.
●Design and implemented automated restore using SSIS in this environment.
●The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
●Completely redesigned the SSIS package that will influence the capital’s market Database.
●Designed many queries and stored procedures, corrected to work according to desired objective.
● Used Red Gate for backups and maintenance jobs which includes updating statistics, database integrity checks
●Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and also updated statistics
●Day-to-day activities were to serve requests from users and to work on the improvement tasks for SQL server to automate manual works that were in place.
●Replication is massive in this environment, as there are many servers that are connected with the databases that are linked by replication. As the data needs to be same across the testing servers and application.
●Various deployment methods were in place for application process.
●Framed out working on automating the restore process for the databases that are involved in
Availability group and replication to get rid of licensing on ready only availability replica.
●Created SSIS packages for File Transfer from one location to the other using FTP task
●Service Now is the ITIL tool used to record the incidents, JIRA tool was used to maintain the internal work process.
●Worked on troubleshooting application related performance issues, like oscillating CPU, extensive memory usage.
●Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
●Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
●Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
●Involved in performing Audits and recovery operations of SSAS objects.
●SSRS
●Faster Delivery rate of the resolution and critical thinking was also as a part of Experience as part of the project.
●Learning and working knowledge on Amazon Web Services (AWS). As SQL Servers were being moved to cloud.
●Monitor network communication.
●Update systems as new version of OS and application software comes out
●Implement the policies for the use of the computer system and network
●Documentation in form of internal Knowledge Base
PepsiCo Inc. [HCL America Inc.] May 2014 – Dec 2015
Plano, Texas
MS SQL DBA
Branded with thoughts to build entrepreneurs with the ideas within themselves a team of HCL came forward to support infrastructure of PepsiCo Inc. to support and HCL is one of the Top notch company in the field of IT infrastructure globally. This is inclusive of marketing sectors India, North America, Russia, Europe, and Middle-East Asian Countries.
Environment: MS SQL Server 2005, 2008 R2, 2012,2014, Windows 2003 Server, Windows 2008/2008 R2, Windows 2012/2012R2 Server, Linux, Unix, Oracle, SQL Toad MS Visual Studio 2010, SSIS Packages, Excel, HTML, NetBackup tool, Guardium tool, Nimsoft Tool, HP Service Manager, Informix, IBM DB2.
Responsibilities:
●Our inventory is huge consisting of more than 3500 MS SQL servers globally
●Installed, managed and administrated the MS SQL Server 2014/12/08/05 Production and Non Production Servers
●The Customer Loyalty program is developed for Retail Industry. This system automates Customer enrollment, Partner Management, Customer transactions, their Points management, Shipping, Points Bonus and Campaign Management. This system involves an OLTP system and Data Warehouse system for Campaigns
●Worked with DTS packages to load the massaged data into Data warehousing system.
●The project involved Manufacturing and Logistics solutions with planning and scheduling for stuffing, destuffing, Billing, vendor-managed inventory and warehouse management
●Handled up to 2.5 TB size database in Active Passive clustered Environment.
● Used NetBackup Tool for backups and maintenance jobs which includes updating statistics, database integrity checks
●Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases.
●Created Logins for the users and manage their permissions.
●Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
●Used Bulk insert to load huge tables.
●Worked in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options
●Implemented partitioning on large table to get the performance.
●Created missing indexes on the tables by running Data Base Engine Tuning Adviser.
●Finding and solving locks and Deadlocks by using DMV’s and DBCC commands.
●Performed Migrations for almost about 80 PEPSICO Inc. legacy database SQL Server migration from SQL 2000/2005 to SQL Server 2012/2014 databases, after running the server side trace to know about the depreciation factors and announcements
●Extracted data from various sources like SQL Server 2008/2012/2014, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
●Created SSIS packages for File Transfer from one location to the other using FTP task.
●Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
●Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
●The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
●Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.
●Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
●Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
●Involved in performing Audits and recovery operations of SSAS objects.
●Assess the risks and recommend/ install service packs or hot fixes when needed.
●Guardium Tool for Auditing and security Purpose across the servers in the inventory.
● Configured Transactional Log Shipping between Primary and Secondary Servers depending on the business requirements.
●Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
●Configured Bi –directional transactional replication and have resolved many of the issues related to replication
●Created Numerous known error records to problem tickets
●Nimsoft tool used to alert as a ticket for all the parameters set to look after the MSSQL server in organized way
●Faster Delivery rate of the resolution and critical thinking was also as a part of Experience as part of the project.
●ITIL Tool HP Service Manager was used to create Incident, Service and Change-Requests for all the issues and they would be updated with the solutions respectively and resolved.
Contact this candidate