We provide IT Staff Augmentation Services!

System Analyst Resume

0/5 (Submit Your Rating)



  • Over 8+ years’ experience in Database Administration, System Analysis and Administration, Development & Support of MS SQL Server2000, 2005, 2008 R2, 2012 and 2014 in Production, Development & Replication Environments.
  • Extensive knowledge about the environments like Commercial, Oil & Gas.
  • Hands on Experience as Core Production Support MS - SQL SERVER DBA for Databases ranging from 100 GB to 5 TB.
  • Extensive experience in handling DBA duties such as Installation, up gradation of MS SQL Server software on Windows Platforms, Database Creation, Database Auditing, and Production Database Support & Maintenance, enhancement, automation, tuning and optimizing databases for high Availability, Performance and Security.
  • Experience in handling Database Migration for DB Version Upgrade.
  • Experience in Database Migration from MS-Access to SQL Server.
  • Expertise in setting up and troubleshooting Database Clustering in Active-Active and Active-Passive Mode on a mount point storage cluster.
  • Expertise in setting up and troubleshooting Always on availability.
  • Experience in configuring high availability methods like Mirroring, log shipping, Replication.
  • Experience in PowerShell Scripting.
  • Experience in creating and troubleshooting SSRS reports and sending notifications through SSRS.
  • Knowledge in database modelling using Microsoft Visio tool.
  • Monitored and modified Performance using Wait States, Index tuning & Execution Plan management.
  • Performed query tuning to reduce response time by 60% in some cases, using cache plans, execution plans and index tuning.
  • SME for Infrastructure issues related to SQL database server such as memory, CPU, I/O, Disk, etc. & Monitor log files to proactively resolve issues
  • Knowledge in working with third party tools like TOAD, LiteSpeed, Commvault & Foglight
  • Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.


Operating System: Windows 2003/2008/2008 r2/2012

Databases: SQL Server 2000/ 2005/2008/2008 R2/2012, MS-Access

Languages: HTML, T-SQL, PowerShell

Tools: & Utilities: Data Protector (Backup Tool), Data Protection Manager (DPM), Red Gate for SQL Server & SQL Litespeed, Red Gate, TOAD, Oracle SQL Developer, MS Visio, Commvault, Foglight.


Confidential, California

System Analyst


  • Handling Production Databases
  • Installing, configuring, upgrading & administration of MS SQL Server 2005/2008/2008 R2/2012.
  • Develop and test a backup and restore strategy.
  • Perform Health check on the servers frequently.
  • Trouble shooting SQL server Performance Issues.
  • Monitoring the CPU, Memory utilization and Disk Spaces on servers.
  • Monitoring job failure alerts and resolve if any job failure issues.
  • Develop Performance baseline and fine-tuning queries.
  • Manage security of database structures and corporate data held within databases.
  • Establishing the needs of users and monitoring user access and security.
  • Controlling access permissions and privileges;
  • Design SSIS package to extract data from External data source to SQL Server.
  • Analyse the database growth & trends and Planning the Capacity of the Servers.
  • Check the Integrity of the databases and tables.
  • Database modelling using MS Visio.
  • Monitoring the error logs, Database Availabilities, Space to avoid the failure of applications on regular intervals.
  • Periodically identifying mismatch, orphan ids and fixing the same.
  • Automating Administrative Tasks by creating alerts, jobs, scheduling jobs.
  • Configuring the audit alerts to capture the failed login attempts and Monitor the unauthorized user access to the databases and remediate the
  • Automating the administrative tasks writing system side stored procedures and programs
  • Interacting with the support teams so that the database environment is always available without any downtime
  • Secure the database environment following the Information Security and Standards of client
  • Installing/Configuring/Monitoring/Troubleshooting SQL Server on Clustering, Always On availability.
  • Configuring/Monitoring/Troubleshooting log shipping, database mirroring and replication
  • Monitoring the servers with various windows performance counters to identify server status
  • Moving System databases from one location to another.

Environment: MS-SQL Server 2014\2012\2008\2005, Windows 2008\2003\2000, MS Excel 2007\2003, MS-ACCESS 2007\2003, T-SQL, MS-OFFICE, SQL Litespeed, MS Visio


SQL Server DBA


  • Performed server installation and configurations for SQL Server 2005\2008\2008R2.
  • Performed installation of SQL Server Service Packs and Cumulative Updates.
  • Regular monitoring of production databases.
  • Creating users in the server and databases and assigning required privileges.
  • Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard
  • Shrinking transaction log and databases as per requirement.
  • Used SQL Server Profiler to monitor and record database activities of particular users and applications.
  • Trouble shooting of the performance issues and tuning.
  • Monitoring and troubleshooting activities like blocking, locking and deadlock etc.
  • Maintaining the database consistency with DBCC at regular intervals.

Environment: MS SQL Server 2000/ 2005/2008/2008 R2 Enterprise Edition, Windows 2000 Advanced Server, Windows 2003 Enterprise Edition, IIS, Red Gate.



  • Contact Centre System Engineer designing, deploying and supporting Contact Centre infrastructure.
  • Monitoring Daily Health checks.
  • Performing Database operations (Purging data, Backup data) on Brightware DBstandards coordinating.
  • Point of contact for the Contact Center Applications
  • Creating and managing the mail routing rules in Firepond (Brightware).

Environment: MS SQL Server 2000/2005/2008 Enterprise Edition, Windows 2000 Advanced Server, Windows 2003 Enterprise Edition, Toad, Oracle

We'd love your feedback!