Sr Developer/DBA

Venkateswarlu

E-mail: *********.******@*****.*** Mobile:91-994*******

Objective:

Intend to build a career with leading corporate of hi-tech environment with committed & dedicated people, which will help me to explore myself fully and realize my potential to become a successful professional in the field of Information Technology and to work in an innovative and competitive world.

Work Experience:

Working as MS SQL Server Database Administrator at Sony Ericsson.

Worked as MS SQL Server Database Administrator at LYCATECH, CHENNAI.

Professional Summary:

3.7 years of experience as Microsoft SQL Server Database Administrator.

Experience in handling SQL server 2000 and 2005 production databases.

Expertise in installation Client and Server, configuration, Backup & Recovery, application support, User & Security Management.

Includes all types of backups like Full, Differential, Transaction log and Tail log Backups and implementing disaster recovery Plan.

Creation and maintenance of databases, creating roles that assign to the particular

Users and managing user permissions based on requirements by client.

Creating different types of jobs and scheduling as per client requirements.

Hands on experience on up-gradation and migration.

Hands on experience in configuring replication, implementing database log shipping.

Experience in maintaining and automating SQL server.

Experience in monitoring and troubleshooting SQL server.

Creating Maintenance Plan.

Experience in configuration Replication & Trouble shooting.

Experience in configuration Log sipping & Trouble shooting.

Experience in configuration Mirroring & Trouble shooting.

Configuration different types of Mirroring like Synchronous (high protection and high availability) and Asynchronous (high performance).

Implementing manual fail-Over and automatic fail-Over of Mirroring.

Managing Master server jobs.

TECHNICAL SKILLS

Data bases : SQL Server 2000/2005.

Operating systems : Windows XP/ NT.

Languages : TSQL.

ACADEMIA

2006 B.S.C from S. V UNIVERSITY.

Certifications and Training

(MCTS(70-431,MCITP(70-443))

Designing and Implementing Databases with Microsoft SQL Server 2000

Database Tools

Veritas NetBackup

Service Center

BMC Patrol

PROJECTS SUMMARY

PROJECT 2

(I)WR Grace:

Project Name : Chemical

Duration : Feb 2009 to till date

Role : DBA

Team Size : 4

Platform : SQL server 2000/2005/2008

Windows server 2000/2003

Brief Overview of Product:

Grace has two operating segments, Grace Davison that provides specialty chemicals, materials and formulation technologies, and Grace Construction Products that produces specialty construction materials, systems and services that strengthen, enhance and protect structures.

Grace Products:

Grace Davison's history began in 1832 when William T. Davison, an Irish immigrant, founded the company.

Grace Construction Products:

Refining Technologies

Advanced Refining Technologies

Materials & Packaging Technologies

Specialty Catalysts & Process Technologies

Discovery Sciences

Construction Products

Customer Service.

Research & Development

Responsibilities:

• SQL server daily health check.

• Verify backups and error logs on the servers and troubleshoot on any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.

• Implemented Log-Shipping as high availability solution using both Enterprise SQL Server 2005 editions.

• Also refreshing Database as per the requirements of the clients.

• Database maintenance plan creation and troubleshooting.

• Re-Indexing.

• Follow change control procedures to migrate code into production servers.

• Respond to trouble tickets assigned to me and fix any database issues promptly

• Primary on call support for weekends

• Installation of SQL server 2005.

• Monitoring and configuration Replication & Trouble shooting.

• Monitoring and configuration Log sipping & Trouble shooting.

• Monitoring and configuration Mirroring & Trouble shooting.

• Dropping The Databases as per client Requirement

PROJECT 1

Title : calling cards, mobile services (MVNO) British Telecom.

Client : Lycatech, UK.

Role : MS SQL DBA.

Team Size : 6

Environment : Sql server 2000/2005

Duration : April 07 – Jan 09

Description:

Lycatel is the global market leader in the prepaid international calling card market present in 16 countries worldwide. Lycatel offers a broad product portfolio comprising of prepaid telephony solutions including calling cards, mobile services (MVNO), carrier to carrier wholesale services and residential indirect access services. In 2006, Lycatel launched Lycamobile, our flagship mobile brand. Present in 6 markets, Lycamobile continues to grow rapidly, attracting over 1.7 million customers already, with a further 7 market launches planned throughout the remainder of 2007/2008. Through a relentless focus on providing voice quality by partnering with over 200 global telecommunications carriers, the Lycatel brand serves its growing base of over 8.5 million customers within expatriate and ethnic global niche segments that want to make low cost international calls. We originate and terminate over 1.6 billion minutes of voice traffic per month and complete over 2.9 million voice calls per day.

Customer Products

LYCA MOBILE

LYCA TALK

E SHOP

LYCA FLY

LYCA CRUICE

Responsibilities:

• Installing and Configuring SQL Server, including service pack deployments

• Migration of SQL Server databases.

• Database Administration And Maintenance

• Creating and implementing disaster recovery plans.

• Managing Security (Creating users, logins and roles ,granting permissions)

• Ensuring Data consistency in the database through DBCC commands.

• Adding users in the Database and granting permissions.

• Scheduling jobs in Sql server

• Configuring Log-shipping and troubleshooting & monitoring.

• Configuring Replication and troubleshooting & monitoring.

Role Played:

• Client Side System Analysis

• Data Base Design and development

• Data Base Maintenance and Fine Tuning Performance

• Maintenance plan

• Package Configuration to Move the Day on Daily Basis.

• Report Database Configuration.

PERSONAL DETAILS

Date of Birth : 10 June 1984.

Languages Known : English, Telugu and Hindi

Marital status : Single

DECLARATION

I hereby declare that the information furnished above is true to the best of my knowledge.

Venkateswarlu

Contact this candidate