Sql Server Management

Mallikarjuna Karnatakapu

SQL Server DBA/Data Analyst/Solution Architect / Cassandra DBA

Email: ************@*****.***

Phone: 301-***-****

Technical Experience summary:

IT Professional with 10+ years of IT industry experience. Microsoft certified database administrator. Solution

Architect (Database, Infrastructure), Subject Matter Expert in Database Administration. Enterprise Level SQL

Server Technology Specialist. Expert in Microsoft SQL Server 2014 and earlier versions. End to End understanding

and experience in all layers. Have thorough understanding of SDLC and production environments support, ITIL

standards. Expertise in database migrations, Installations, Database designing, Optimization, Data compression,

Auditing, High availability solutions configuration and maintenance. Well experience on Disaster recovery planning

and implementation, Cluster Setup and managing patches, Database security management, Performance tuning,

Capacity Planning, Backup & Recovery Strategies, trouble shooting, Azure. Also expertise in change management,

release management, incident management, Problem Management and standard operation procedures and

compliance.

Technical Skills:

Operating Systems Windows NT, Windows 95, Windows 2003, Windows 2008, Unix, Linux.

Languages C, ASP. NET, VB 6.0, SQL, Biz talk 2008.

Databases SQL Server 2000,SQL 2005,SQL 2008,SQL 2012, SQL 2014,Oracle 8i,Oracle 10g,

Sybase

No SQL Databases Hbase, MongoDB, Cassandra 2.1.5

Big Data & Eco functional Hadoop, SQOOP, Hive, Pig, Flume

Tools Office 2010, Office 2013 suite, “App detective Pro ”Database server scanning tool,

“Lite speed”, Team Foundation Server

Web Server IIS

Monitoring Tools SCOM, NetIQ, Idera Diagnostic Manager

Practices ITIL

ERP SAP ABAP 4.6 C

Domains Banking,Finance,Manufacturing,Title Insurance, Mortgage

Business Intelligence SSIS, SSRS

Professional Experience:

Nov ’10 April 2015.

Client : First American Corporation, Santana, CA.

Software used : SQL Server 2008, 2008 R2, 2012, 2014, Informatica, .Net, Java, TSQL, VC++, Biz talk 2008,

Unix, FTP, Azure, Power Shell, Cassandra,Team Foundation Server

Title : Lead Database Administrator and Data Analyst.

Achievements:

• Understand “big picture”, focus on customer’s needs, prioritize tasks as per customer’s needs, come up with

solutions, implement and meet or exceed customer’s expectations.

Supporting Microsoft approved SQL technologies like SQL Server 2005, SQL 2008, 2008 R2, 2012 and

•

SQL 2014

Design, implement and maintain 125 critical database servers.

•

Prepared and planned index optimization jobs on non production and production environments.

•

Defined and developed strategies for patch upgrades, rolling patches and rolling upgrades in Clustered

•

Environments.

Worked on Cassandra (for 5 billion image repository) in Installation, designing & data loading into tables

•

and created primary keys and clustered keys per the business requirement.

Have done configuration changes in Cassandra.yaml file according to the requirement.

•

Maintained BizTalk databases and archived messages to reduce burden on live databases.

•

Planned and implemented Data Compression, Transparent Data Encryption (TDE), Resource Governor,

•

Policy Based Management, Backup Compression and Change data capture.

Planned and configured Disaster Recovery between data centers in various locations by Clustering, Log

•

shipping, Mirroring and Replication.

Migrated few databases related to a project to Azure.

•

Understand customer requirements and convert them into schema & security design in database and provide

•

slots to insert data.

Continuous check of databases health and taken necessary steps to fix consistency errors.

•

Prepared backup and restore backup processes using lite speed and scheduled automated jobs.

•

Recovered data for objects using object level recovery of Lite Speed.

•

Used index tuning wizard and profiler extensively to fix performance issues.

•

Troubleshooted job failures and provided permanent fix.

•

Prepared root cause analysis for issues and documented.

•

Documented processes and procedures.

•

Used Power shell scripts for few maintenance activities.

•

Prepared monthly reports of environment and sent to management.

•

Organize daily team meetings and group meetings and review progress.

•

Closely worked with Informatica data migration, App development, QA & Software configuration teams

•

and moved code builds into non production and production environments.

Conduct & participate in meetings with onshore and offshore teams for detailed discussions on business

•

requirements and issues.

Prepared automated job system to shrink log files to release available space to operating system.

•

Troubleshooted slow and performance issues of hardware and SQL by using profiler, perfmon and

•

execution plans.

Configured high availability for databases through replication and log shipping and managed them.

•

Configured “Always on High Availability” concept with Availability Groups in SQL 2012 with combination

•

of Synchronous and Asynchronous Mirroring.

Handled up to 4 TB + databases in Clustered environments with good Physical storage configuration.

•

Configured and maintained Clustering for Active Active and Active Passive nodes.

•

Prepared database optimized files design, secured schemas for business needs.

•

Handled crisis calls during production system failure and fixed with minimal down time.

•

Participated as both a leader and contributor on team assignments while defending resulting database

•

architecture, server optimization for proposed end to end enhancements.

Understand business requirement, Explain and assign to team followed by reviewed.

•

Reviewed and approved database requirements and deployed per business requirement.

•

Created Net Backup policies, setup automated jobs based on net backup policies.

•

Performed server upgrades, patches, database migrations, consolidations, incident tickets.

•

Research on technical innovations and best practices, Implement the same with approval of the business.

•

Continuously be on top of the issues and keep databases and environment at peak performance with

•

effective server and database management practices.

Generate daily database reports and provide builds status to counties.

•

Constantly strive to keep server environment updated, secure, stable, meet SLA’s and keep server up time

•

of 99.99%.

Implemented Back Up, Restore, Recovery, Update statistics, Rebuilding, Reorganizing indexes, and

•

defragging strategies. Used dynamic management views to find and solve Performance Issues of databases.

Created Linked servers between non production to production and vice versa.

•

Maintained database User Permissions, server Logins and Security standards across all databases.

•

Monitored Event Viewer, SQL Error logs and Log Files Viewer for errors and provided fix.

•

Prepared shift rotation of team and allocated shifts.

•

Worked in 24/7 environment to maintain and administer databases also to fulfill user requirements.

•

Mar’08 Oct 2010

Client : HSBC Global Technologies, Hyderabad, India.

Software's used : SQL Server 2005, 2008, .Net, Sybase

Title : Sr. Database Administrator

Achievements:

• Responsible for implementing and maintaining of 375 database servers spread across North America.

• Installation & Configuration of SQL 2000, 2005 and 2008.

• Managed mission critical databases of size (800 GB+).

• Planned and implemented Database Change requests (DCR).

• Provided well defined security standards on server level as well as on database.

• Troubleshooting day to day issues directed to GSD (Global service desk) & SCOM console.

• Scanning & finding security vulnerabilities of database servers using “App detective pro” and providing fix.

• Installation of Lite speed, script generation, setup jobs based on requirement and trouble shoot.

• Prepared process oriented documentation.

• Performed object level recovery for objects using SQL Lite speed.

• Familiar with processes like Shift turnover, DCR tracker, Change order Creation, Companion change order

creation, Work orders creation, Change request approval process.

• Efficient handling of On Call DBA to provide 24 * 7 supports.

• Responsible for On site offshore meetings, Offshore SQL meetings with other region SQL teams (UK, Asia

pacific, Japan) and documenting MOM.

• Creation of Net Backup policies and setup jobs.

• Configure, maintain & trouble shoot of Replication, Database Mirroring and Log shipping.

• Configure SQL Mail and setup alerts and notifications to Jobs.

• Raise service requests and keep track of requests.

• Detecting and resolving locks and deadlocks using trace flags and native tools like Profiler and activity

monitor.

• Used execution plans and index tuning wizard to fix performance issues.

April’07 Feb 2008

Company : Intelli group Asia Pvt Ltd, Hyderabad, India.

Software's used : SQL Server 2005, .Net, Java, Visual Basic.

Title : Database Administrator

Achievements:

• Administrating more than 20 mission critical Database servers.

• Providing technical solutions for application teams for deployment of database code.

• Configuration and creation of various database logins and users on SQL Server 2000, SQL 2005

environment.

• Maintain Production Databases at the size of (180 GB) and make them to run with high optimization.

• Performing of stored procedures tuning and responsible for quick results for end users.

• Designed Backup and recovery strategies for transactional databases and maintained retention policy.

• Trouble shooting software bottle necks by SQL Profiler to improve performance.

• Planning and designing of DTS packages for specified business workflows by customers.

• Trouble shooting day to day database connectivity and performance issues and assist development teams.

• Generation of daily space reports, health check reports and upload the same to FTP.

• Creating and debugging Views, Functions, Indexes, Cursors, Store Procedures, Triggers, Optimizing code

and improving efficiency

• Implementation of Backup, Re index, DB Shrink, Log Shipping and other database maintenance jobs

through Stored Procedures.

• Creating and Modifying Tables, T SQL Stored Procedures, Views, Indexes, User defined Functions, and

Triggers as required.

• Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when

requested).

• Prepared and deployed database build scripts into various environments.

Feb’06 April’07

Client : SLK Software Services Pvt Ltd, Hyderabad, India

Software’s used : SQL Server 2000, 2005, Visual Basic, SSIS, Clustering.

Title : Database Administrator

Achievements:

• Involved in Migration of SQL Server 2000 to 2005 and also on new hardware with the platform of

Windows2000 and 2003.

• Collaborate on configuration of servers to support a variety of business applications, data warehouse

• Configuring and Troubleshooting Service Objects in Service Broker for moving message queue in Database

and Instance Level.

• Install and validate upgrades and patches, Check and confirm databases status and cluster services status.

• Configuring and Troubleshooting disaster recovery and high availability solutions by Mirroring, Log

shipping, Replication and Clustering.

• Working with third party tools like Quest Lite Speed for log shipping and Fog light for performance

monitoring.

• Ensure process compliance for Quality and organization Regulations.

• Performed application program enhancements, troubleshoot and bug fix as required.

• Migrated DTS packages to SSIS.

• Management of users and logins creation/alteration, grant of system/database roles and permissions on

various database objects.

• Develop standards and guidelines to maintain and administer SQL.

• Deployed the SSRS reports in Microsoft share point portal server MOSS 2007.

• Worked on DTS/SSIS for transferring data from Heterogeneous Database to SQL Server

• Monitoring high availability and troubleshoot.

• Implementation of Backup, Re index, DB Shrink, Log Shrink and other database maintenance jobs through

Stored Procedures.

For transferring, used data import and Export utility and BCP command line utility.

•

Automated messaging services on server failures, for task completion and success.

•

Provided 24/7 Support for all non production & production environments.

•

Performed query tuning & optimization using Query Plans & SQL Profiler.

•

Implementing different development and test Server instances for Application development team and co

•

ordinate.

Creation and maintenance of databases, creating roles and managing user permissions.

•

Aug’04 Feb 2006

Client : Dimensions Cybertech India Pvt Ltd, Hyderabad, India.

Software’s Used : SQL Server 2000, Visual Basic, Java.

Title : Junior Database Administrator

Achievements:

• Performed regular Database Maintenance tasks, checking the disk Defrag procedures in Development

environment.

• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes

• Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server2005.

• Designed and developed disaster recovery strategy for databases.

• Used Index Tuning Advisor for troubleshooting performance issues.

• Upgraded development and production servers from SQL Server 2000 to SQL Server 2005

• Implementing load balancing replication across the Databases.

• Performed database refresh tasks from production to development and staging servers

• Involved in performance tuning of SQL Server for Web based production and development environments.

• Used Perfmon and Profiler Trace to monitor the Memory, CPU and disk usage, the private bytes.

• Processed trend in available bytes, Performed Uploading of bulk data migration with BCP Utilities.

• Performed database consistency checks and provided fix.

• Resolved issue of high usage of system CPU, disk and deadlocks transaction.

Education:

Masters of Information Technology from MAHE (Manipal Academy of Higher Education, Udupi,

•

Karnataka, India) in 2003.

Microsoft Certified MCITP professional.

•

Advanced SQL Server 2005 training by Microsoft India Pvt Ltd, Hyderabad, India.

•

Advanced SQL Server 2008 training by CR University, Bangalore, India.

•

Awards & Appreciations:

Received Service Excellence & Best Team player on June 2012 from Vice President of First American Inc.

•

Received Team Excellence & Best Team player on Mar 2013 from Vice President of First American Inc.

•

Received Service Excellence & Best Team player on Dec 2014 from Vice President of First American Inc.

•

Received Team Excellence & Best Lead on Mar 2013 from Vice President of First American Inc.

•

Received Team Excellence & Best Lead on Mar 2014 from Vice President of First American Inc.

•

Received Team Excellence & Best Lead on Dec 2014 from Vice President of First American Inc

•

Received award + cash award for “outstanding accomplishment” in the engagement from HSBC north

•

America Director –Business systems (USA) on July 21st 2010.

Received Best performer award from HSBC Global Technologies in the month of March 2010.

•

Received cash award from HSBC Delivery management for being a potential resource during data center

•

outage issue on April 2010.

Contact this candidate