We provide IT Staff Augmentation Services!

Sql Server Dba Resume Profile

5.00/5 (Submit Your Rating)

SUMMARY:

  • 10 plus years of MS SQL Server Core database administration experience development experience with DBA duties.
  • Experience with Oracle 9i, 10g and 11g.
  • Hands on Experience in installing, configuring, creating, managing, monitoring, and troubleshooting SQL Server 2000, 2005, 2008, 2008R2 and 2012 databases in both Physical and Virtual environments.
  • Installed Cumulative Updates and service packs for various versions of SQL Servers.
  • Upgraded to SQL Server 2000 and 2005 databases to higher versions 2008, 2008 R2 and 2012.
  • Performed SQL Server database consolidations, upgrades, downgrades and migrations.
  • Hands on experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
  • Experience in Data transfer and Transformation using tools like DTS, BCP, Bulk Insert SSIS.
  • Experience with establishing and maintaining security, integrity controls in conjunction with the applications and security groups and assist in the design and implementation of development, testing, QA, and production environments.
  • Extensive experience with SQL Performance tuning and transaction analysis, thorough understanding of indices and statistics.
  • Strong experience in database Backup, Restore and Recovery procedures.
  • Hands on experience and knowledge of high availability SQL Server solutions, including Replication, SQL Server Clustering, Log Shipping Database Mirroring.
  • Experience in using Performance Monitor/Profiler to resolve Dead Locks/Long running queries.
  • Experience in Supporting Very Large Databases Troubleshooting the problems.
  • Supported 60 plus dev, test, stage and prod database instances single handedly.
  • Hands on experience on SQL Server 2005, 2008, 2008R2, 2012 Native and Sharepoint integrated mode Reporting Services.
  • Experience with Sharepoint 2010 installation and management for SSRS.
  • Configure and manage SQL Server Analysis Services SSAS 2005 and 2008R2.
  • Familiarity with new features like Always-on in SQL 2012.
  • Ability to work in a team environment with excellent communication, presentation, leadership, analytical, qualitative and interpersonal skills.
  • Documented SQL server Configurations.
  • Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team.
  • Coordinated with Oracle teams on various administrative and development activities.
  • Apply security updates/patches on Oracle Databases.
  • Perform Oracle backups and recovery.
  • Actively involved in the upgrade of oracle databases from 9i to 10g.
  • Extensive experience with third party database maintenance tools like Embarcadero DBArtisan, Data Architect and Performance Center.
  • Experience with Oracle Enterprise Manager Grid Control .
  • Provided 24x7 support and involved in on-call rotation.

TECHNICAL SKILS:

Operating Systems:

Windows 98/2000/2003/2008, AIX, Linux

Databases:

MS SQL Server 2000/2005/2008/2008R2/2012, Oracle 9i/10g/11g

Languages:

TSQL, PLSQL

Database Tools:

SQL Profiler, Performance Monitor, SQL Server Management Studio, DBArtisan, Performance Center, Data Architect

ETL Tools:

DTS, BIDS, SSIS

Reporting:

SSRS.

EXPERIENCE:

Confidential

SQL Server DBA

Responsibilities:

  • Install and maintain SQL Server 2008 R2 and 2012 database and SSRS on multiple servers.
  • Implement Fannie Mae standard procedures on all the database instances.
  • Monitor and troubleshoot database related issues and work with application teams to resolve issues.
  • Migrate and upgrade databases from older versions to 2012.
  • Lead a team that performed clustered database installations and managed clustered instances having Mount points.
  • Actively involved in capacity planning.
  • Provide On-Call support.
  • Perform database backups and recovery.
  • Provide Sharepoint backed database support with migrations and upgrades.
  • Create, drop and alter database objects.
  • Setup logins as per Fannie Mae standards and make sure security policies are strictly enforced in all the environments accordingly.
  • Create and implement change and Incident tickets through the remedy.
  • Provide application installation and setup support.
  • Experience with tape backup retrievals.
  • Create and update documentation.
  • Monitor management reports

Environment: SQL Server 2005/2008/2008R2/2012 , SSIS, SSRS,WindowsNT/2000/XP/2003/2012

Confidential

SQL Server DBA

Responsibilities:

  • Maintained various client databases in MS SQL Server 2000, 2005, 2008, 2008R2 and 2012 versions.
  • Wrote stored procedures for ease of administration and management.
  • Performance analysis and evaluation of queries and Databases in a slow running application and monitoring / optimizing / tuning the performance of the SQL Server.
  • Scheduled maintenance on databases and capacity planning to increase performance and productivity.
  • Administer client reports using Reporting Services SSRS in native and sharepoint integrated mode.
  • Troubleshoot and minimize production down issues.
  • Created and Implemented, scheduled maintenances and backup procedures to the database to enhance overall performance and disaster recovery methods.
  • Extensive use of DTS/SSIS and scripting for various ETL processes.
  • Maintained 60 plus database instances in dev, test, stage and prod.
  • Upgraded SQL Server 2000 and 2005 databases to higher versions 2008R2 and 2012.
  • Performed SQL Server database consolidations, migrations, upgrades and downgrades.
  • Configured and Managed Standby databases using Log Shipping.
  • Installed, configured and maintained SQL Server Clusters.
  • Actively involved in capacity planning.
  • Co-ordinated with Oracle team on various administrative and development activities.
  • Apply security updates/patches on Oracle Databases.
  • Perform Oracle backups and recovery.
  • Installed Oracle clients.
  • Actively involved in the upgrade of oracle databases from 9i to 10g.

Environment: SQL Server 2000/2005/2008/2008R2/2012, SSIS, Reporting Services, Replication, MS Access, OSQL, Windows NT/2000/XP/2003/2008, Oracle 9i/10g/11g , AIX, Linux, Embarcadero DBArtisan Performance Center

Confidential

SQL Server DBA

Responsibilities:

  • Installation of MS SQL Server 2005.
  • Installation of SQL Server Service Packs.
  • Database designing and database modeling.
  • Responsible for Database Backups Restoration, Backup Strategies and Maintenance Plans.
  • Creating and moving databases and stored procedures for production from stage database and visa versa.
  • Created Clustered and non-clustered Indexes.
  • Creation of various data objects like tables, views and indexes.
  • Cleansing databases by deleting unnecessary objects.
  • Generated various reports using Reporting services.
  • Involved in Security Administration- creating users and assigning them roles and privileges.
  • Created Security Model for search criteria.
  • Used SQL Server Integration Services SSIS to migrate DTS packages from SQL server 2000 to 2005.
  • Configuring, Maintaining and Troubleshooting Database Mirroring.

Environment: Operating Systems: MS Windows Server 2003, MS Windows 2000 Professional RDBMS: MS SQL Server 2000 2005

Tools: SQL Server Business Intelligence Development Studio, SQL Server Management Studio, Enterprise Manager, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor, Database Maintenance Plan Wizard, Data Transformation Services DTS SSIS

Front End: .NET FrameWork 2.0

Confidential

SQL Server DBA

Responsibilities:

  • Installation of SQL Server 2000.
  • Providing Primary DBA 24X7 support for databases in Stage and Production environment.
  • Responsible for Database and Log Backups Restoration, Backup Strategies and Scheduling Backups.
  • Created and Implemented, scheduled maintenances and backup procedures to the database to enhance overall performance and disaster recovery methods.
  • Creating and moving databases and stored procedures for production from stage database.
  • Performance analysis and evaluation of queries and Databases in a slow running application and monitoring / optimizing / tuning the performance of the SQL Server.
  • Responsible to monitor 10 production servers and 6 development server individually.
  • Worked with Various DBCC commands to ensure Database Consistencies.
  • Creation of Clustered and non-clustered Indexes for Query Performance.
  • Creation of various data objects like tables, views and indexes.
  • Refreshing test databases whenever necessary.
  • Generating various reports using complex stored procedures.
  • Involved in Security Administration- creating users and assigning them roles and privileges.
  • Scheduling Jobs and Alerting using SQL Server Agent.
  • Using Data Transformation Services DTS an Extract, Transform Loading ETL tool for SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
  • Configuring, Maintaining and Troubleshooting Replication.
  • Creating Linked servers.

Environment:

  • Operating Systems: MS Windows 2000server, MS Windows 2000 Professional RDBMS: MS SQL Server 2000
  • Tools: Enterprise Manager, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Database Maintenance Plan Wizard, Data Transformation Services DTS .
  • Front End: VB 6.0/ VB. Net/ ASP. Net/ DotNetNuke Portal Technology
  • Siebel Call center Event Management Module 7.5.3

Confidential

SQL Server Developer/DBA

Responsibilities:

  • Installation of SQL Server 2000.
  • Creatre Logins and setup security.
  • Scheduling Jobs and Alerting using SQL Server Agent.
  • Perform database Backups and restores.
  • Performance Monitoring.
  • Involved in Database Desingning and Modeling.
  • Coded SQL to perform database tasks such as inserts, updates and deletes.
  • Coded SQL to perform database tasks by using inner/Outer joins and group by/having clause.
  • Created Database objects like Stores Procedures, Triggers, Views, and Rules etc.

Environment:

  • Operating Systems: MS Windows 2000server, MS Windows 2000 Professional RDBMS: MS SQL Server 2000
  • Tools: Enterprise Manager, Query Analyzer, System Monitor/Performance
  • Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Database Maintenance Plan Wizard, Data Transformation Services DTS .

We'd love your feedback!