Post Job Free

Resume

Sign in

Service Representative Sql Server

Location:
Mysore, Karnataka, India
Posted:
March 12, 2020

Contact this candidate

Resume:

Md.Navazuddin

Email Id: adb9pk@r.postjobfree.com

Mobile : +918********* Career Objective:

Endeavor to excel in the field of Information Technology, through sincere work devotion by ensuring greater heights to my organization in terms of prosperity and reputation, which in return would improve my own growth.

Professional Summary:

3.10 years of experience in information technology, with experience in SQL Server Database Administration.

Proficient in Installation, Configuration and Administration of SQL Server 2005/2008/2008R2/ 2012 and 2014.

Experience in applying the service packs and cumulative updates to SQL servers.

Implement and maintain database security (Logins, Roles and Permissions).

Good experience in resolving Locking, Blockings and Deadlock issues.

Good experience in Space Management in Database.

Experience on tempdb, log file full issues in the Database.

Monitoring SQL Server agent scheduled jobs and alerts.

Having good hands-on experience in Backup & Recovery.

Good Experience in Performance monitoring and Optimization (Server level and Query level).

Good Experience in Upgradation from Lower version to Higher version.

Good Experience in Migration from SQL Server 2005 to SQL Server 2008.

Good Experience in Configuration of Clustering and Applying Service Packs.

Good Experience in SQL Server 2012 AlwaysOn like Configuration, failover, add and remove the database to availability group,

Good Knowledge in Replication like Configuration

Good Experience in Log shipping like Configuration, failover Log shipping

Good experience in latest Build Deployment activities as per client request.

Maintaining Documentation for the Build wise Deployment issues if any.

Good Experience in resolving the tickets within the SLA period.

Maintaining Documentation for the complete environment.

Work as part of a team and provide 24 x7 supports when required.

Work Experience:

Working as Associative SQL Database Administrator for UST Global, Bangalore from Apr 2017 to

Till Now.

Worked as Jr.SQL Server Database Administrator for Orion India Systems Pvt Ltd,Chennai From

Feb 2016 to Mar 2017

Educational Profile:

Bachelor of Computer Science (B.Sc.) from Thiruvalluvar University, Vellore

Technical Summary:

RDBMS

MS-SQL Server 2005/2008/2008R2/2012/2014

Languages

C, SQL and T-SQL.

Operating Systems

Windows 2003/2008/2012 and 2016 EE

Commercial Applications

MS Office

SQL Servers Tools

SSMS,DETA,Remedy and ServiceNow

Project Profile:

Project: 2

Organization : UST Global, Bangalore.

Client : AT&T USA.

Role : Associate Database Administrator.

Environment : SQL Server2008/2008R2 & 2012 on Windows 2008, 2012E

Team Size : 9

Description:

CCTP is an AT&T Enterprise initiative to support the strategy of a common desktop application solution across AT&T Consumer and BCS (Business Communication Services) Markets. The primary business objective is to present data from a variety of systems (BOSS,SORD etc.) in a way that will make the Service Representative’s job easier and more efficient. Our SQL Server team provides database administration for all applications that use SQL Server as backend.

Roles & Responsibilities:

Installation and Configuration of SQL Server 2008R2, 2012 and 2014.

Applying service packs along with the cumulative updates.

Performing SQL server daily health check and preparing a report based on it.

Monitoring Disk Space of all the Servers and freeing up space as per SQL Server.

Handling creation of new SQL Server databases as per Client/Application Team request.

Monitoring Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.

Applying Service Packs and Security patches for the Servers as released.

Created and managing Users, Roles and Groups and handling database security policies.

Managing Backups on a daily basis and Recovery as per request.

Add or remove database in to Alwayson availability group.

Reviewing SQL Server and SQL Server Agent Error Logs.

Performance related issues whenever the performance related issue tickets raised.

Maintain documentation and ensuring strict process is followed.

Configuring AlwaysOn in different versions.

Configuring Cluster Environment.

Applying service packs in Cluster Environment.

Maintaining Documentation for the complete environment.

Project : 1

Organization : Orion India Systems Pvt Ltd,Chennai

Client : KPMG International

Role : Jr.Database Administrator.

Environment : SQL Server2008/2008R2 & 2012 on Windows 2008, 2012E

Team Size : 12

Description:

KPMG has provided services to the financiers, owners and contractors on a range of large scale infrastructure projects globally and in SA. We provide a seamless range of advisory and assurance services to support you through the lifecycle of infrastructure projects. KPMG draws on a global team of infrastructure experts and proven methodologies.Our SQL Server team provides database administration for all applications that use SQL Server as backend.

Roles & Responsibilities:

Installation and Configuration of SQL Server 2005, 2008, 2008R2 and2012.

Applied services packs (patches) for SQL Server 2005, 2008, 2008R2 and2012.

Migration of databases from SQL Server 2005 to SQL Server 2008.

Responsible for creating Logins, Users and Assigning database Permissions

Monitoring the temp db full and transactional log full issues.

Installing the SQL server 2005/2008 R2 /2012 and applying the service packs.

Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.

Configuration DB mail by using SMTP Account.

Daily checking the tickets assign the tickets and resolve the tickets depends on the priority levels.

Daily monitoring the DB space Management issues and allocating the required space to databases.

Work as part of a team and provide 24 x7 supports when required.

Configuration Replication and Replication related space issues.

Configuration of Log shipping and failover log shipping.

Latest Released build Deployment activities whenever needed.

Maintaining documentation for deployment related issues if any.

[NAVAZUDDIN]



Contact this candidate