Security Sql

• Kanala Uday Kumar Reddy

• ***************@*****.***

• Mobile No. : +91-900*******

CAREER OBJECTIVE

To be associated with a dynamic organization this provides optimal learning opportunities to achieve organizational goals for the benefit of the company and the individual. PROFESSIONAL SUMMARY

• Having around 4.0 years of IT experience in MS SQL Server Database production support and Maintenance Activities

• Expertise in Installing, configuring, securing and managing SQL servers to ensure better performance and application availability.

• Exposure to SQL Server and Windows environments.

• Experience in working with production (24 x 7) and development environments.

• Instrumental in High Availability tasks of SQL Server such as Backup, Restore, Replication, Log shipping, Mirror server, cluster and Security

• Able to configure jobs for routine activities and troubleshooting them in case of failures.

• Familiar with implementation strategies, backup/recovery strategies.

• Monitor SQL Server down, SQL Server Agent, Error log, Application and System logs, Job failures, Backup Failures, Database and Log growth, CPU, Memory and Disk Utilization using the in-house built SQL Server monitoring tool.

• Creating database users, controlling access to SQL Server and making sure right people get access to right data and looking after the security issues.

• Experienced in advanced concepts of SQL server like Mirroring and log shipping.

• Expertise in implementing MS SQL Server security and database permissions.

• Performing the Failover and Failback operations in the cluster environment and adding the new Disks and troubleshooting activities.

• Configuring and Maintaining and troubleshooting the Database mirroring and also experience in Mirroring DR activities.

• Configuring and Maintaining and troubleshooting the Database Log Shipping and also experience in Mirroring DR activities.

• Troubleshooting Space issues and performing Capacity Planning for Production Database servers.

• Database performance monitoring and tuning when required as per application and business requirements.

• Performing Database Refresh from Production to Stage environment.

• Experience with upgrades from SQL 2005 to 2008 r2 and from 2008 R2 to 2012.

• Experience in SQL Server migration activities

• Knowledge on Windows and SQL Server clustering and Always ON High Availability.

• Flexibility working in 24*7 environment

• Administrating MS SQL Server, analytical, monitoring, troubleshooting, organizational skills, and assessment planning and implementation.

• Team player, willing to share and develop my knowledge and experience

• Ability to handle multiple tasks and tight deadlines.

• Working with different clients has made me interact with people of different cultures and mindsets. PROFESSIONAL EXPERIENCE

• Working as a Member Technical (SQL Server DBA) with ADP PVT Ltd, Hyderabad from April 2017 to till date.

EDUCATION

• Completed B.Tech (ECE) from JNT University, Andhra Pradesh in 2015. TECHNICAL SKILLS

• SQL Server Versions SQL Server 2000, 2005,2008, 2008R2, 2012, 2014

• SQL server tools SQL Server Management Studio, SQL Profiler, Performance Monitor, SQLCMD, Microsoft Clustering Services (MSCS), SQL Server Upgrade Advisor, DMV's and DBCC Commands, DR Configuration, Log Shipping, Mirroring, Clustering, Always On and Transactional Replications

• Operating Systems Windows Server 2008 R2, 2012, 2016

• Ticketing Tools Jira

• Backup Tools Symantec Net tool, Comm Vault and Lite speed

• Application skills IIS, ITIL

• Other Essential Software Microsoft Office Word, Excel PROJECT EXPERIENCE

Project #1 : Freedom IT Operations – United Kingdom. Client : SBI UK, HCUK, Uber, Wipro around 1000 clients from UK. Duration : April 2017 – Till Date

Team Size : 4

Environment : MS SQL Server 2008 R2, 2012, 2016.

Tools : Enterprise Manager, Query Analyzer, SSMS, Profiler, Splunk. Description: ADP freedom is a powerful mixture of payroll software and expert services which promotes efficiency through streamlining processes. It ensures organizations enjoy an increase in the accuracy and timeliness of employee's pay, and is fully accredited by the HMRC. Responsibilities:

• Working closely with application development and support team to understand their requirements and provide timely solutions, for both current and future projects.

• Configuring replication, mirroring, SQL clusters and troubleshooting issues.

• To reduce threat to the environment identified users having SYSADMIN rights and relegate them to the appropriate rights.

• Planed phased implementation of security patches in coordination with application team to minimize downtime to end users.

• Installation and configuration of MS SQL Server 2008R2, 2014, 2016.

• Migrating databases from SQL Server 2008R2 to 2014/2016.

• Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking

• Configuring and troubleshooting high availability scenarios like Log Shipping.

• Implemented Database Mirroring with High Availability Mode in SQL 2005

• Maintained & Monitored Alert/Schedule to make smooth replication process.

• Ensure and maintain sound backup and recovery policies and procedures.

• Backup and restoring the databases from production to test environment.

• Resolving blocking processes related issues.

• Executing the scripts in production environment.

• Updating Service packs and Security patches for the Servers.

• Monitoring of server performance.

• Performing data refresh activities from production to Dev/Test/CFT on need basis.

• Performance tuning of the database.

• Creating and reviewing Security features for all the servers.

• Configuring and monitoring the Database Mirroring and Log Shipping.

• Trouble shooting blocking, space issues.

• Ensuring Data consistency in the database through DBCC commands.

• Migration and up gradation of servers and databases

• Repetitive issues analysis and proposals for permanent resolutions.

• Working on Jira ticketing tool for ticket management. Project #2 : Surepay Payroll Systems – United Kindom Client : Amazon,ECPUK,Newlook around 1000 clients–United Kingdom. Duration : July 2019 – Till Date

Team Size : 2

Environment : MS SQL Server 2016, Biztak server 2016, Biztak server 2020 Tools : . Net,Windows Cluster, SSMS, Jira, Confluence, IIS, Biztalk Healthcheck monitor tool, Nagios monitoring tool.

Roles and Responsibilities:

• Experience in Installation Biztalk application.

• Gathering the requirement from the Business team and build the servers from the scratch.

• Experience migrating Biztalk application from old version to newer version.

• Knowledge on configure Biztalk Master secrete server.

• Experience in using Biztalk Health check monitor tool.

• Troubleshooting in fixing MSDTC issues and experience in using REGEDIT.

• Experience in configuring send and receive handlers in Biztalk.

• Experience in setting up multinode configuration and cluster setup.

• Having experience in installing SQL server.

• Experience in configuring Biztalk Host and Host instance and cluster setup.

• Applying Windows Patches and SCCM patches.

• Migrating Databases from 2008R2 to 2016.

• Experience in changing SQL server collation server properties.

• Migrating SQL Jobs and SQL logins from one server to another server.

• Hands on experience in applying patches on applications. K Uday Kumar Reddy

Contact this candidate