We provide IT Staff Augmentation Services!

Sql Server Dba Resume

PROFESSIONAL SUMMARY:

  • 5 years of experience in Database Management Technology in cluster, replications and log shipping
  • Extensive experience in database design, implementation and administration in MS SQL Server 2012/2008/2005/ 2000/7.0/6.5, Data Warehouse, SSIS, SSRS
  • Strong SQL Back End Programming in both Web based and Client/Server environment
  • Experience in Oracle 11g RDBMS, Reports 2.5, MySQL, DynamoDB, Amazon RDS, AWS Cloud Watch
  • Experience in Cloud Strategies based on AWS.
  • Excellent communication skills and a key team player. Highly motivated and quick learner

TECHNICAL SKILLS:

Languages: SQL, T - SQL, PL/SQL, HTML, CL and Shell Script, Web Service JSON pattern

Software: Oracle Developer/2000, Forms, Reports, SQL*Plus, SQL*Loader, Crystal Report 6.0/7.0/8.5/9.0, MS Central Microsoft SQL Server Management Studio, SQL Server Data Tools, SQL Server Business Intelligence Development Studio, Microsoft Visual Studio and MS Visio.

Database: SQL Server 2014/2012/2008/20005/2000 Oracle 11G, MySQL, OLTP, DTS/SSIS, OLAP, Data WarehouseBusiness Intelligence, MS Reporting Services, MS Analysis Services, SSIS, SSRS, BCP

Systems: Windows 7,8/XP/NT/2000/98/95, UNIX, Linux.

AWS: Automated Build Tools, Cloud Technologies, CI/CD Tools, Configuration, Management, Version Control Systems

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA

Responsibilities:

  • Provide Production Support for MS SQL Server Databases in High Availabilities
  • Perform day - to-day administration on SQL Server 2005-2012 environments
  • Set up and Configure database Mirroring, Log shipping, Replication
  • Ensure database health and integrity across all systems
  • Diagnose & troubleshoot issues, Conduct performance tuning for optimizations
  • Manage database Capacity growth and refresh data from production to lower environment
  • Monitor databases, migrate SQL Server from SQL 2005 to SQL 2008
  • Support SSIS, SSRS, Data warehousing\Manage and implement production release
  • Lead the Disaster Recovery
  • Install SQL Server in Cluster and Migrate SQL Server from SQL 2008 to SQL 2012
  • Set up and configure database Mirroring, Log shipping, support SSRS, SSIS
  • Automate maintenance jobs, install services patching
  • Identify problems, find root cause and perform tuning to ensure application performance
  • Manage database Capacity growth, write stored procedures, triggers
  • Maintain & manage Database security, install monitor tools on the Server
  • Experience setting up transparent data encryption (TDE) user security in Oracle and backup database

Confidential

SQL Server DBA

Responsibilities:

  • Provided production support for MS SQL Server 2005/2008 and maintenance in High Availability Cluster, Logshipping, Mirroring and SRDF
  • Collect business need to design server specs for new projects, install & configure new SQL Server 2008 in Cluster
  • Conducted SQL Migrations from SQL 2000 to SQL 2005 and to SQL 2008 for large Data Center
  • Set up database Log shipping, Mirroring, Replication, install & configure monitor on the Server
  • Diagnosed bottlenecks, Perform tuning for optimization
  • Managed database capacity growth, support Business Intelligence, MS Report Services
  • Implement service packs and manage database health, manage user security for compliance
  • Set up maintenance jobs and configurations on the Server
  • Provide support for production releases related with database work
  • Install SQL SERVER 2008 On Cluster
  • Migration Databases from SQL 2005 to SQL 2008
  • Manage and maintain 2008/2005 Production Database Servers, SSIS, SSRS
  • Support Developers and Business, write stored procedures\Queries
  • Set Best Practice for the server management
  • Conduct Performance tuning and work with Full text Index

Confidential

SQL Server DBA

Responsibilities:

  • Manage and Support MS SQL Server 2000/2005 Production Databases
  • Install SQL Server in Cluster and upgrade SQL Server from SQL 2000 to SQL 2005
  • Troubleshoot and Conduct performance tuning for applications
  • Automate DBA activities to help ensure the high availability of the Server
  • Write stored procedures, triggers and views
  • Set up log shipping and management strategy and Capacity planning
  • Configure database in SQL 2005 to automate operation alert
  • Maintain and support developers for SSIS/DTS, SQL Analysis Services SSRS
  • Migrate DTS to SSIS and Implement SSIS to load data into DW systems
  • Support large web applications and large Data warehouse systems
  • Manage and Support large amount of MS SQL Server 2005/2008 database in high availability environments including Cluster and Log shipping, Replication
  • Lead DBA for consolidating MS SQL Server databases on HP Polyserve Matrix
  • Proactively monitor, tune and improve Database Performance
  • Strong ability to Identify/ troubleshoot problems and resolve real-time database issues
  • Conduct performance tuning for applications
  • Perform database Backup and Recovery, lead the Disaster Recovery
  • Upgrade MS SQL Server 7.0/6.5 to SQL 2000 and from SQL 2000 to SQL 2005
  • Write batch files to Manage databases and Migrate data across Servers
  • Transfer data from different platforms using DTS/SSIS package
  • Design and troubleshoot DTS packages for the business needs
  • Write stored procedures, triggers and views
  • Create database and Manage backup in SSMS/MSSQL
  • Automate DBA activities to help ensure the high availability of the Server
  • Apply SQL Service patches and manage SQL server security, Support SharePoint in SQL
  • Support SSAS and Manage OLAP database for Data warehouse for financial business
  • Setup log shipping and replication
  • Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
  • Built database Triggers and Referential Integrity Constraints to implement business rules

Hire Now