We provide IT Staff Augmentation Services!

Snr Sql Server Dba Resume

0/5 (Submit Your Rating)

Ada, MI

SUMMARY

  • Over 7 years of experience in Database Architecture, Administration, Design, Development and Support of MS SQL Server 2012/2008R 2/2008/2005/2000 in Production, Test, Development andClusterServer Environments.
  • Experience in RDBMS database design and Architecture,performance tuning, optimization, backupand recovery in SQL Server 2000/2005/2008/2012.
  • Experience inDisaster Recovery Planning, Execution and Testing.
  • Experience in using SQL Server Tools like DTS,Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler,Index Tuning Wizard, and Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance andSQL Query Analyzer.
  • Migration/Upgrade of SQL Server Versions such asMS SQL Server 2000toMS SQL Server 2005/2008,MS SQL Server 2005toMS SQL Server 2008/2008R2/2012.
  • Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAPtechnologies.
  • Experience in Database administration activities forDatabase Security(creating logins, users, roles, and assigning permission to them).
  • Master in performing administrative tasks: database file management,backup/restore, security management,Database Mirroring, data integrationandsynchronization.
  • Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
  • Experience in implementing high availability using Log shipping, and knowledge of Database mirroring in SQL Server 2005.
  • Solid experience in High Availability SQL Server Solutions including Replication Models (Snapshot/Transactional) and SQL Server Clustering (Active - Active, Active - Passive).
  • Expert in usingBulk Copy Program(BCP), Data Transformation Services (DTS)packages andSSIS (integration services)with MS SQL Server 2000/2005/2008/2008 R2/2012.
  • Experience in creating and maintaining SSIS packages. Experience inDTS MigrationandMetadata Management:Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.
  • Experience in using SSIS(SQL Server Integration Services)for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools likeImport and Export Wizard, Package Installation and SSIS Package Designer.
  • Experience in designing/generating/using/deploying Visual Studio 2005 Business Intelligence Reports, SQL Server 2005Reporting Services(SSRS).
  • Extensive work experience on system analysis, design, development, testing and implementation of projects with fullSDLC(Software Development Life Cycle).

TECHNICAL SKILLS

RDBMS: SQL Server 2014/2012/2008/2005/2000.

Database Tools: Management Studio, BI Development Studio, SQL Profiler, Data Transformation Services (DTS), SQL Server Integration Service (SSIS), SQL Server Analysis services(SSAS), SQL Server Reporting services(SSRS), Erwin, Microsoft Visio.

Languages: SQL, TSQL, XML/HTML, JavaScript, .NET 4.0, ASP.NET

Web Tools: Adobe Dreamweaver, Internet Information Server (IIS), MS-Outlook Express.

Applications: Microsoft Office, Erwin, MS VISIO.

Operating Systems: Windows 95/98/2000/ 2003/2008/2008 R2/NT 4.0/XP, Linux, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Ada, MI

Snr SQL Server DBA

Responsibilities:

  • Installed, configured and managed SQL server 2005/ 2008/2008 R2/2012 databases and instances.
  • Migrated databases from SQL Server 2005 to SQL Server 2008/2008 R2/2012.
  • Implemented database security and managed logins, server roles, database roles and database permissions.
  • Implemented high availability features such as SQL failover cluster instance, mirroring and replication.
  • Reviewed software developers stored procedures, triggers, functions and other SQL to ensure that SQL code is optimized for performance, followed coding standards and is logically sound.
  • Interacted with Business System Analysts and Software Developers to transform business requirements and application requirements into appropriate data model solutions.
  • Assisted development team with performance issues, refreshing development/test databases from production databases.
  • Created, maintained and implemented database development standards along with best practices
  • Created maintenance plans to check database integrity, rebuild indexes, update statistics and execute SQL server agent jobs.
  • Worked with Performance Monitor, SQL Server Profiler and Extended Events to troubleshoot SQL server issues related to CPU, Memory, File I/O Locking, Blocking and Networking.
  • Configured linked servers to allow distributed queries, updates, commands and transactions on heterogeneous data sources across the enterprise.
  • Created, Maintained and Troubleshooted SSIS packages for data extraction from various sources, transformation and loading in to target SQL databases.
  • Defined report layouts including report parameters, Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS.
  • Involved in capacity planning and sizing database objects for effective space management and optimal performance.
  • Involved in Logical and Physical data modeling with business team using ERWIN.
  • Created, developed and reviewed the physical model created from the logical model, ensuring the detailed physical design of data structures and databases complies with standards, guidelines, and procedures recommended for all aspects of data modeling, database design, and maintenance; ensured proper data modeling and design paradigms were applied
  • Reviewed overall physical database structures for data integrity, performance quality, recoverability, maintenance and space requirement considerations
  • Assisted in the definition and development of database documentation and standards

Environment: Windows Server 2003/2008/2008 R2, MS SQL Server 2008/2008 R2/2012, Idera SQL safe Manager, Idera Diagnostic Manager, SolarWinds Server & Application Monitor

Confidential

Snr SQL Server DBA

Responsibilities:

  • As a Production and development support DBA responsible for maintaining 200 SQL Servers out of which 170 servers are production servers in which 100 were mission critical and 70 were business critical servers, remaining test and development servers.
  • Installed SQL Server 2008 R2 and SQL Server 2005 on windows 2008 R2 and 2003servers, applied service packs and security fix for all servers.
  • On call 24/7 support to databases on weekly rotation Used ERWIN to carry out heavy duty Logical and Physical data modeling.
  • Implemented Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit environment.
  • Expert in physical Architecture, logical Architecture for data flies and log files on production environment
  • Managed SQL Servers in 32/64bit Clustered environments. Implemented Database Mirroring on SQL Server 2008 environments.
  • Configured and maintained Log shipping architecture to provide backup server solution for 4 environments. Implemented transactional replication for data refresh. And managed all Publisher, Distributor and Subscriber database environments for the replication
  • Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
  • Upgraded server from MS SQL Server 2005 to MS SQL Server 2008 and Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
  • Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers. Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
  • Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS and Scheduled package execution in SSIS and Installing packages on multiple servers in SSIS
  • Extensively worked on SSIS for data manipulation and data extraction, ETL Load and Created extensive reports using SSRS ( Tabular, Matrix )
  • Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments.
  • Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
  • Created the standard documents for Disaster recovery testing and implemented them.
  • Experienced with database sizing and capacity planning for production servers. Implementing Framework Operating system ITIL
  • Responsible for upgrades i.e. SQL server 2005 Service Pack, SQL Safe Backup tools and SQL Diagnostic Manager.
  • Supporting the business 24/7, maintaining 99.999 uptimes, depending on the application and business SLA requirements.
  • Experienced with creating logical and physical database design for development projects.
  • Experienced with improving SQL Server using windows performance monitor to improve the server performance.
  • Created the backup schedule for production, test and development servers.
  • Worked with developers to do the database schema changes and database restore requests.
  • Involved in restore operations to refresh the data from production to test servers.
  • Experienced in troubleshooting production servers and fixed the user and application issues.

Environment: SQL Server 2008/2008 R2 Enterprise Edition, Windows Server 2008 R2 Enterprise edition, Idera SQL safe Manager, Idera Diagnostic Manager, Idera Defrag Manager, SSIS, Dell PowerEdge R900

Confidential, New York, NY

Sr. SQLServer DBA

Responsibilities:

  • Performed the role of Senior Database Architect for all SQL Server database environments
  • Managed All Production, Development and QA Environments running MS SQL Server 2008/2005.
  • Expert in logical Architecture for data files and log files separate location on production environment for better performance.
  • Involved in Migration of Production Database Servers from SQL Server 2005 to SQL Server 2008.
  • Involved in Performance Tuning on Production, Staging and Test Servers.
  • Involved with maintenance of ACTIVE/PASSIVE Cluster Environments
  • Implemented Database mirroring for High Availability.
  • Maintained various databases for Production and Testing using SQL Server 2008.
  • Used All Fusion ERWIN to deploy any changes to the database and objects from test to production.
  • Worked with SQL Server Profiler and Perfmon. Involved in Monitoring Performance of different production servers.
  • Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
  • Using SQL server reporting services(SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
  • Making a Report as per user requirement using MS Reporting Services 2000/2005
  • Created Service Broker Programs to continuously load data from the mirror database to the report database.
  • Created SSIS Packages to migrate slowly changing dimensions and Performance tuning, and Optimization of Stored Procedures and Queries. Involved in data modeling for the application and created ER diagram using Erwin.
  • Created Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
  • Created the backup and restore strategy for production and development environment.
  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Involved in creating reports using SQL Server Reporting Services (SSRS) as per the requirement.
  • Migrated DTS packages to SSIS packages.
  • Experience in creating and executing SQL Server Integration Services (SSIS) packages.
  • Involved in Migration of Reporting Servers from SQL Server 2000 to SQL Server 2008.
  • Managing schema objects such as tables, views, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
  • Involved in Data Security by maintaining and giving granular permissions to the users/login as needed, enforcing the password policies and by creating proxy accounts.
  • Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them whenever necessary.
  • Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
  • Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Environment: SQL Server 2005/2008 Enterprise Edition, Windows Server 2003/2008 Enterprise edition, Dell Poweredge M710, Idera SQL safe Manager, Idera Diagnostic Manager, Erwin, Visio

Confidential, Jersey City, NJ

MS SQL Server DBA

Responsibilities:

  • Data Import/Export through DTS. Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery. Creating users, Roles and granting privileges. Creating database, tables, indexes, and rules. Developed stored procedures, triggers, and views for managing efficient data retrieval.
  • Written T-SQL statements using DML and DDL for retrieval of the data. Configured data mapping between different Databases.
  • Query optimization using SQL Profiler and performance monitors to enhance the performance of database servers.Transformed data from various data sources using OLE DB connection by creating various DTS packages.
  • Experience in writing and debugging Stored Procedures and triggers. Designed, Developed and managed the reports using Reporting Services. Experience in Database Backup, Recovery and Disaster Recovery procedures.
  • Created Replication models Snapshot and Transactional. Created and scheduled various SQL Jobs using SQL ServerAgent to perform various Administrative skills.

We'd love your feedback!