System Engineer Resume

SUMMARY:

5 years of industry experience in Microsoft SQL Database Administration, installation of MS SQL server in cluster server and standalone server, configuration of SQL server services, Log - shipping, linked servers, maintaining SQL server security, configure maintenance plan and configure backup strategy.
Performed database upgrades from SQL 2000, 2005, 2008 to later versions
MCTS 70-462 (Administering Microsoft SQL Server 2012 Databases) certified in March 2013
Planned and executed the relocation of data center for Confidential, India.
Seamlessly collaborated with 10 members to achieve daily objectives for critical projects of Confidential & Toubro Finance limited.
Skilled in analyzing technical information and clearly conveying it to clients.
Designed and implemented user set- up, end user training materials and testing procedures.
Worked in a 24x7 production environment
Effectively handled Teradata database for Confidential project when working with Confidential .

TECHNICAL SKILLS:

Database Management: Microsoft SQL server 2005, 2008, 2008 R2, 2012, Teradata 14, Oracle, MySQL, Oracle, Big Data, Hadoop, MS Access

Operating System: Windows Server 2003/2008/2008 R2/2012, VMware, Linux

DB Monitoring Tools: Spotlight, Fog Light and Whats up Gold Monitoring tools

Infrastructure Platforms: AWS, Microsoft Azure

Ticketing Tools: BMC Remedy, CA Service Desk

Storage: NetApp, IBM, EMC, Hitachi

Programming \Scripting: C#, Core Java

Standards: ITIL v3

TECHNICAL EXPERIENCE:

Supporting servers in the Prod /Dev/ UAT environment for MS SQL Server 2012, MS SQL Server 2008 R2, MS SQL Server 2008 and MS SQL Server 2005 Databases.
Installation and Configuration of MS SQL server 2012, 2008 R2, 2008 and 2005 on Window Cluster Server.
Installation and Configuration of MS SQL server 2012, 2008 R2, 2008, 2005 on Standalone Window Server.
Upgrade SQL server with service pack.
Upgrade SQL server with version (side by side up gradation and in place up gradation).
Log-shipping Configuration, Monitoring and Troubleshooting.
Configuring Reverse Log Shipping for DR Drill failover/failback activity.
Database Full backup, differential backup, transaction-log backup, file & file group backup and copy only backup strategy under disaster recovery plan.
Database Restore, attach, detach and bring the database single user mode, offline mode.
Recovery of database from suspect mode.
Movement of user and system databases file (mdf&Ldf) one location to another location.
Shrinking the Log file and database file.
Rebuild and reorganize the Indexes.
Memory capping for SQL server on database server.
Creating, Configuring, Scheduling and Troubleshooting database maintenance plans
Monitoring the database growth, disk space availability, CPU & Memory utilization and SQL server services status.
Monitoring SQL log viewer, SQL log file, Activity monitoring and OS Event log.
Monitoring SQL server scheduled jobs and database log space.
Creating Linked server From SQL to Oracle and SQL to SQL for distributed query purpose.
Knowledge of Always ON (MS SQL Server 2012), Mirroring and Replication.
Configure database backup on Remote server.
Creating database instances and schemas.
Managing Security at SQL server and database level.
Database capacity planning

WORK EXPERIENCE:

Confidential

Associate Technical consultant

Responsibilities:

Monitoring database performance or resource crunch alert and taking appropriate action on priority.
Provide Teradata DBA Support
Viewpoint Monitoring & session management

Confidential

System Engineer

Responsibilities:

Worked in HDFC datacenter and Confidential datacenter relocation project.
Relocated database servers for critical applications like Netbanking, Mobile banking
Performance validation of database servers post relocation\migration.
Planned database server migration with minimum downtime.

Confidential

System Engineer

Responsibilities:

Monitoring.
Performance Tuning.
Planning Disaster Recovery.
SQL server Installation and Configuration on window cluster server and standalone servers.
Upgrading SQL server with Version and service pack.\
High Availability.
Managing Security.
Database migration.
Configure schedule jobs and creating link server..

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship