We provide IT Staff Augmentation Services!

Ms Sql Server Dba Resume

2.00/5 (Submit Your Rating)

Columbus, GA

SUMMARY:

  • Around 6 years of IT experience in Database Design, Data Modeling, Data and Database Security, Requirements Analysis, Application Development, Testing, Implementation and Deployments using SQL Server 2014/2012/2008 /2005.
  • Experience with Multi - Servers and Multi-Terabyte Databases design for Very Large Databases
  • Strong experience in Business Intelligence (BI) using Visual Studio 2008/2005.
  • Experience in managing more than 1000 Database servers
  • Experience in primary data analysis, mapping and migration from Oracle to SQL server
  • Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering, log shipping and Mirroring.
  • Created, Built and deployed successfully dynamic SSIS packages into SQL Server 2008/2005 databases and scheduled them according to requirements.
  • Extracted, Transformed and Loaded data in Data warehousing using SSIS packages.
  • Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2008/2005 database.
  • Experience in Migration of Data from Excel, Flat file using DTS, SSIS and other ETL Tools.
  • Experience in working with Reporting tools like MS SQL Server Reporting service (SSRS),
  • Report Builder and BIDS
  • Rendered reports in CSV, PDF, XML and Delivered reports by file share and E-mail according to schedule.
  • Experience on BizTalk, SSRS, SSIS, SharePoint .
  • Experience in Database Design activities including Data Files and File group organization, Capacity Planning, Data Partitioning and Data Normalization.
  • Resolved issues with Indexes, Blocking and locking issues to remove the performance bottlenecks.
  • Database design & administration experience on SQL Azure, MS-SQL Server 7/2000/2005,
  • Proficiency and Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
  • Rebuild online index and worked with Dynamic Management Views (DMV) for improving query performance.
  • Experience on migrating Sybase ASE old version (11.9/12.x) database into Oracle and MS SQL server SQL Server 2012 migration from SQL Server 2008 / 2005.
  • Experience in Change Data Capture (CDC), Change Tracking (CT) in SQL server 2008.
  • Experience in Creating complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.
  • Good hands-on with creating Partitioned Tables and Partitioned Views.
  • Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions depending on the Technical Requirements.
  • Experience in migration of data using BCP Utility, Bulk Insert command, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
  • Experience with Java application interface.
  • Expert in Query Tuning and activities including Updating Statistics, Re-building and Re-organizing Indexes.
  • Monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor, DBCC commands and Dynamic Management Views.
  • Programming automated tasks to reconcile accounting data between clients and Prime Brokers, including working with Microsoft SQL Server and Perl scripting language.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, VB.Net, HTML, C

Services: Database Engine, SSIS, SSRS(Visual Studio 2008, 2005)

RDBMS: MS SQL Server 2012 2008, 2005, 2000, 7.0, MS Access databases,DB2,Oracle 10 g,11g, Sybase ASE

Reporting Tools: BIDS, Report Builder 2.0, Report Builder 3.0

Modeling Tools: Microsoft Visio, SQL Diagrams, ERWIN 4.1, SQL Server Enterprise Manager

Operating Systems: Windows 2008 R2/2003/2000 Server (64/32 Bit), Windows 2000 Professional, Windows NT 4.0/3.5.

Other Tools: DTA,Perl,SQL Profiler, DTS XCHANGE, Citrix, Diagnostic Manager, SQL Lite speed, RMAN, Precise, Spotlight.

PROFESSIONAL EXPERIENCE:

Confidential

MS SQL Server DBA

Responsibilities:

  • Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition..
  • Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
  • Expert in implementing the snapshot isolation and DDL triggers.
  • Experience with 10 + Tera Byte databases.
  • Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
  • Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).
  • Involved in analysis, database designing, coding and testing.
  • Optimized the performance of Queries and Store Procedures with modification in T-SQL statements, by removing unnecessary columns, by eliminating redundant and inconsistent data, by renormalizing tables, and created indexes wherever necessary.
  • Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Used SQL Server Profiler to monitor and record database activities of particular users and applications
  • Managing the VERITAS net backups.
  • Hands on experience in Setup and Troubleshooting Log shipping and mirroring.
  • Installing SQL Server with minimum access privileges service account to improve security and to attain high ratings in SOC audits.
  • Comprehensive experience utilizing VMware technologies in the deployment of mission critical SQL Server environments.
  • Experienced in designing and deploying HA and DR solutions using VMware technologies.

Environment: SQL Server 2008/2012/2014 Enterprise, Windows Enterprise Server 2012, SQL LiteSpeed 4.5, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler

Confidential, Columbus, GA

SQL Server DBA

Responsibilities:

  • High Availability Disaster Recovery during SQL 2014 migration.
  • P2V migration of 2005 and 2008 to 2014 and 2012 Migrations
  • Production supporting DBA activities in huge OLTP environments.
  • Query tuning queries based on Hich CPU, Memory and Logical reads and writes.
  • Analyzing and designing and implementing different types of Replication Models.
  • Supporting Huge Databases, Troubleshooting the problems.
  • Spreading huge tables to different file groups to achieve maximum performance.
  • Writing TSQL code and complex stored procedures for different tasks. Tuning the code written by team members to achieve optimum performance.
  • Setting up DR solutions using Log shipping, Mirroring, Always On (2012) in windows clustering environments for High Availability.
  • Experience in managing more than 1000 Database servers
  • Setting up monitoring alerts and dashboards in addition using of SQL built-in dashboards.
  • Discussion with peers about performance issues, SQL Internals about log shipping, DB mirroring, replication etc.,
  • MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
  • Database creation, restoration, recovery, User/Schema Creation and maintenance Space Management.
  • Monitoring and Troubleshooting SQLServer using Windows System Monitor, creating an Alert in Windows System Monitor, creating a SQL server Performance Alerts.
  • P2V Migration of 70 + Sql servers as part of Code reduction for SQL licensing project.
  • Data migration (import & export - BCP) from Text to SQL server.
  • Setting up High availability always on future on new 2012 servers.
  • Good understanding and experience in SQL Server 2008 features like Change Data Capture (CDC), Transparent Data Encryption (TDE) and Policy based Management.
  • Prepared and documented Backup & Restore Plans and manage data import and export form multi-agency interfaces
  • Working with developers on RFC deployments
  • Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc

Environment: SQL Server 2014/2012/2008, SSIS, SSRS, Visual studio 2008, MS Visio 2007, XML, VB.Net,Report Builder 3, Oracle 11gR2, BizTalk, SSRS, SSIS, Sybase, DB2.

Confidential, Edison N

SQL Server DBA

Responsibilities:

  • Production supporting DBA activities in huge OLTP environments.
  • Designing SSIS packages those involved in different tasks like ETL, maintenance plans, monitoring etc.
  • Analyzing and designing and implementing different types of Replication Models.
  • Experience with BMC Patrol, DBArtisan, Quest Fpass.
  • Spreading huge tables to different file groups to achieve maximum performance.
  • Writing TSQL code and complex stored procedures for different tasks. Tuning the code written by team members to achieve optimum performance.
  • Setting up DR solutions using Log shipping, Mirroring, Always On (2012) in windows clustering environments for High Availability.
  • Setting up monitoring alerts and dashboards in addition using of SQL built-in dashboards.
  • Discussion with peers about performance issues, SQL Internals about log shipping, DB mirroring, replication etc.,
  • MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
  • Database creation, restoration, recovery, User/Schema Creation and maintenance Space Management.
  • Monitoring and Troubleshooting SQLServer using Windows System Monitor, creating an Alert in Windows System Monitor, creating a SQL server Performance Alerts.
  • Maintaining and Automating SQLServer like, Configuring Database Mail, creating an Operators, Creating Jobs, Alerts, Database Maintenance plans.
  • Data migration (import & export - BCP) from Text to SQL server.
  • Designed SQL SSIS Packages in Business Intelligence Development
  • Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
  • Created new databases, involving importing and exporting: installing and configured database software for Oracle Application development environment. worked on migrating Sybase ASE old version(11.9/12.x) database into Oracle and MS SQL server

Environment: SQL Server 2012/2008, SSIS, SSRS, Visual studio 2008, MS Visio 2007, XML, VB.Net, Report Builder 3, Oracle 11gR2, BizTalk, SSRS, SSIS, Sybase .

Confidential, Miami, FL

SQL Server DBA

Responsibilities:

  • Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
  • Performed data migration from SQL Server 2005 to SQL Server 2008.
  • Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
  • Created SQL scripts for tuning and scheduling.
  • Performed data conversion from flat file into a normalized database structure.
  • Created Triggers to enforce data and referential integrity.
  • Installing of report builder 3 and Deploying the Reports
  • Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
  • Defined Check constraints, Business Rules, Indexes, and Views.
  • Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
  • Responsible for creating the reports basing on the requirements using SSRS 2008.
  • Data migration (import & export - BCP) from Text to SQL server. worked on migrating Db2 database into MS SQL server
  • Good understanding and experience in SQL Server 2008 features like Change Data Capture (CDC), Transparent Data Encryption (TDE) and Policy based Management.
  • Studio (BIDS), to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008, 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks in Visual Studio 2008.
  • Prepared and documented Backup & Restore Plans.
  • Created clustered and non-clustered indexes to improve the performance of queries with by understanding the Actual execution plan. Eliminated key-lookups, table scan and converted index scan to index seek
  • Backing up master & system databases and restoring them when necessary and automated backup processes using SQL Server jobs.
  • Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.
  • Experience with BMC Patrol, DBArtisan, Quest Fpass. .
  • Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
  • Created Daily System Health Checks Reports for Space, CPU, Memory, Table Statistics, Indexes.
  • Experience with Oracle11g, Oracle RAC, Oracle Grid, RMAN.

Environment: Windows 2003 Server, SQL Server 2005/2012, SQL Server 2000,T-SQL, PL/SQL, Erwin 4.1, JavaScript, MS IIS Server 5.0, SOAP, Perl, XML, Oracle8i/ Oracle11g.

Confidential, Long Island, NY

MS SQL DBA

Responsibilities:

  • Designed and applied schema change scripts to existing objects to synchronize with changing business rules.
  • Performed data migration from SQL Server 2005 to SQL Server 2008.
  • Took part in data normalization process with senior database analyst.
  • Created stored procedures, triggers, views, added/modified tables for data load transformation extraction and manipulation.
  • Created clustered and non-clustered indexes to improve the performance of database and tables.
  • Filtered bad data using complex T-SQL statements, Cursors and UDFs and implemented various constraint and triggers for data consistency.
  • Designed and applied schema change scripts to existing objects to synchronize with changing business rules.
  • Build table relationships and wrote stored procedure to clean the existing data.
  • Coordinated with front end developer to put in the business rules. Wrote stored procedure to check some of the rules at the backend at the time of entering data.
  • Developed SQL Scripts to Insert/Update and Delete data in MS SQL database tables.
  • Developed the project using iterative approach.
  • Managed database changes based on feedback.
  • Migrating DTS package from SQL Server 2005 to SSIS in SQL Server 2008.
  • Created new SSIS packages according the business rules.
  • Participated in creating reports using SSRS.
  • Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
  • Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
  • Configured SQL mail agent for sending automatic e-mails to employees for Invoice using SSIS packages.
  • Working knowledge of hardware, including RAID, multi-processor architecture.

Environment: SQL Server 2008/2005, SQL Server 2008 Integration Services (SSIS), SQL Server 2008

We'd love your feedback!