Sql Server Operator

MALLESWARAN S

Career Overview:

Overall, having a 5 year of IT-Infrastructure Environment.

* **** ** ******** ** SQL DBA Responsibility.

Good experience with SQL Server Clustering Configuration and Maintaining highly available(Always ON) server’s environment

Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2005/2008R2/2012.

Proficient in technologies like MS SQL 2005/ MS SQL 2008 R2, Oracle(Level – 1) and MS Access in Windows/ Unix Environment.

Responsibilities include monitoring daily, weekly and monthly system maintenance and also Skilled BACKUP & RECOVERY, LOG SHIPPING, MIRRORING, REPLICATION in MS SQL (2005/2008R2)

Expertise in Transact-SQL (DDL, DML, DCL) and in Design and Normalization of the database tables.

Handling in Sharepoint,SAP, Adrelian, D2S, DMS application related Database’s.

Experience in Oracle 11g (L1 activity) such as Table space checking, refreshes activity using the RMAN tool and Regular Monitoring on Unix Environment.

Hands on experience in VBA Macro Developing, Reporting, SQL and Database Management (MS Access, MS SQL (2005/2008)).

EDUCATIONAL QUALIFICATIONS:

SSLC with 65% (2006-2007) V.V.H .Hr.Sec.School, Salem-636006

Diploma in Information Technology with 94% in Salem Polytechnic College, Salem -65.

B.E in Computer Science Engg with in Annauniversity college, Chennai

TECHNICAL EXPERTISE :

Database’s : MS SQL(2005/2008R2 /2012),Oracle.

Servers : SQL Server (2005/2008R2/2012),UNIX

Tool : BMC,CISM, SolorWinds, NetBackup, SCCOM. Other : Macro Developing, DailyMonitoring, Always On

Professional Experience:

1.Working as a MS SQL DBA in Wipro since Jan- 2014 to till date.

Wipro InfoTech

Wipro helps customers do business better by leveraging our industry-wide experience, deep technology expertise, comprehensive portfolio of services and vertically aligned business model. Our 55+ dedicated emerging technologies ‘Centers of Excellence’ enable us to harness the latest technology for delivering business capability to our clients.

CLIENT NAME: DAIMLER (Bharath Benz)

Projects and Responsibilities:

Creating and maintaining various databases for Production, Development and Testing using SQL Server 2005/2008.

Assisted in designing, capacity planning, security and accessibility functions of databases(200+ Server’s).

Responsibilities include monitoring daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.

Responsibilities include’s Upgrading for two applications from MS SQL Server 2005 to MS SQL Server 2008

Installing and configuring SQL Server Cluster server in SQL Server 2005 using HP servers.

Monitoring the server for High availability of the servers.

Creation and scheduling of Maintenance plans (database and log backups and cleanups),

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

Deploying Administration tools like SQL DB Access, Performance Monitor and Backup Utility, Native client access the Database

Implement Log Shipping in SQL Server 2005/2008 from the primary server to Standby server.

Installing and configuring SQL Reporting Services 2005/2008 on Windows Server 2003/2007 environment.

Created monitoring scripts to alert for production issues.

Managing DB backup and restore activity.

Migrating SQL Server 2005 databases into SQL Server 2008 R2.

2.Worked as a MS SQL Analyst in Nokia Siemens Networks since Jan- 2011 to Jan-2014.

Nokia Siemens Networks:

Nokia Siemens Networks is one of the largest telecommunications equipment suppliers in the world. It implements the GSM architecture. It supports Wireless networks, operator services and wire line networks. It has over 600 operator customer in 150 countries

CLIENT NAME: VODAFONE

Projects and Responsibilities:

Installation, configuration and upgrading of Microsoft SQL Server 2005/2008 R2 software and related products.

Responsible for monitoring and making recommendations for performance improvement in hosted databases.

Responsible for Database support, troubleshooting, planning and migration. Resource planning and coordination for application migrations with project managers, application and web app teams. Project involved guidance and adherence to standardized procedures for planned data center consolidation for worldwide centers using in-house corporate and third party applications based on SQL 2005/2008 in the upgrade project on SQL 2005/2008

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

Perform SQL Server service pack and Windows Service pack upgrades.

Responsible for General Database Administration and Performance

Migrated Oracle 11g data into SQL Server 2005/2008 and Vice Versa

Monitoring the automated loading processes.

Take care of the Database design and implementation

Recover database files, log files, control files and multiplexing as well.

Strong Experience in MS Excel, VBA and Macro Developing.

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

Mobile : 090***-*****

Contact this candidate