System Engineer Resume
CAREER OBJECTIVE:
A quick learner highly motivated to set and achieve goals and able to inspire the trust and confidence of others. Work equally well as a team member or independent and able to prioritized and delegate. To do the kind of work that brings out the best in me. Responsibility with authority is what I seek.
SUMMARY:
4.7 years of experience in Administration and Maintenance of Databases in Microsoft SQL Server on Windows based Operating systems. I actively engaged in Database Administration and proficient in use of administrative tools like Enterprise Manager, Query Analyzer, System Monitor. My expertise includes database administration, Backup /Recovery, Log shipping, Replication, Mirroring, Performance tuning, Database Job Scheduling, Troubleshooting and Debugging.
FUNCTIONAL COMPETENCE:
- Installations.
- Backup and Restore.
- Monitoring Jobs.
- Log shipping.
- DTS (Data transformation Services).
- Replication.
- Maintenance.
- Database Security.
- Building Reports.
- Database Mirroring.
- Good knowledge on performance tuning and troubleshooting.
- Have worked independently in production support environment and Data Centre support.
- Allocate system storage.
- SAN Storage devices.
- EMC Storage LUN creation and assign to Server
KEY TECHNICAL SKILLS:
Databases: MS SQL Server 2000/2005/2008
Operating Systems: Windows 2000 professional/Advanced server, Windows 2003 Server and Windows Server 2008
Mailing Tool: Microsoft Outlook and IBM Lotus Notes
Ticketing Tool: Clear Quest, Ticketeria.
Monitoring/bakup tools: Light Speed, Idera, Redgate
Client Tool: Putty and FTP(File Transfer Protocol)
PROFESSIONAL EXPERIENCE:
Confidential
System EngineerTechnology: SQL Server 2008
Responsibilities:
- Installation.
- Installation of SQL Service Pack on SQL Server.
- Database Creation.
- Adding the data files and log files to the database.
- User & Login Creation and give the grant permission.
- Take the backup of the databases.
- Database restoration and optimization.
- Logins movement from one server to another.
- Log shipping between the databases.
- Transactional replication of the databases.
- Monitoring the database Mirroring.
- Job Scheduling and monitoring the jobs.
- Rebuilding and Reorganized the Indexes through maintenance plan.
- Troubleshooting SQL Server production issues.
- Performance tuning.
- Disk space issues of databases on SQL Server.
- Working as part of a Team and provide 24*7 DBA on call Support.
Confidential
System EngineerTechnology: MS SQL Server 2005
Responsibilities:
- Detail analysis of User requirements.
- Map the user requirements with the operational system.
- Create a systematic approach document and send it to customers.
- User/Schema creation.
- Monitoring the log shipping of the databases.
- Monitoring Replication.
- Managing the hard disk space utilization.
- Monitoring the jobs.
- Backup and restore of the databases.
- Maintenance of the databases.
- Import and export data using Wizard method.
Confidential
System EngineerTechnology: MS SQL Server 2000
Responsibilities:
- Installation of SQL Service pack on SQL server.
- Maintaining databases backups, storage and space uses.
- Databases shrinking.
- Backup and restore of the databases.
- Adding the data files and log files in to the databases.
- Monitoring, scheduling and troubleshooting jobs.
Confidential
Technical Support
Technology: MS SQL Server 2000
Responsibilities:
- Installation of Service pack and update patches.
- Installation of Anti - virus software and scan the systems.
- User and Login Creation and giving the appropriate permission.
- Implementing backup strategy and ensuring scheduled backups as per the plan.
- Backup and restore of the databases.
- Health Check of all servers like disk space, databases spaces.
- Managing log files and data files like adding, renaming and resizing.
- Monitoring the Backup Jobs, Replication Jobs.
- Monitoring log shipping.