We provide IT Staff Augmentation Services!

Sql Database Administrator Resume Profile

Professional summary

  • 5 years in-depth experience in managing multiple MS SQL Server 2000/2005/2008/R2/2012/2014 servers with very large OLTP Databases in development, testing/QA and production environments while ensuring their performance, high availability and internal/external security.
  • Logical and physical planning of relational databases manage internal databases from planning and testing stages through implementation and support.
  • Hands on experience in Installation, Configuration and Migration of SQL Server 2014/2012/2008 R2/2008/2005/2000, apply periodic service packs and hot fixes cumulative updates and complimentary third party tools.
  • Experience in configuring logical drives/ array and their RAID level using HP array configuration utility.
  • Experience with database maintenance, management and performance monitoring using third party tools including Spotlight, IDERA and REDGATE.
  • Expertise in creating database objects and structures including databases, tables, indexes, views, snapshots, stored procedures, triggers, functions and cursors.
  • Experience in developing complex TSQL scripts and stored procedures to perform administrative tasks and multiple DDL, DML, and DCL activities to carry out business requirements.
  • Extensive experience in performance tuning / analysis, troubleshooting and query optimization using native tools like MSSQL Server Profiler, Activity Monitor, Performance Monitor, Event Viewer, Index Tuning Advisor, Database Tuning Advisor DTA , Dynamic Management Views DMV ,Services and Protocols, and Configuration Manager.
  • Experience in using dynamic management views DMV and Dynamic Management Functions DMF , TSQL scripts, Triggers, and Store Procedures for troubleshooting and performance tuning that include finding out long running queries and query costs.
  • In-depth understanding of user management and database security at different levels to ensure database integrity and secure databases from unauthorized intrusions and data corruption.
  • Extensive experience in designing, implementing and maintaining high availability and disaster recovery plans including: back-up and restore, log shipping, replication transactional/merge , database mirroring, failover clustering and always-on.
  • Expertise in automating maintenance jobs in SQL Server job agent and task scheduler: such as Shrinking database, index rebuilding, creating filtered indexes, index reorganizing, cleaning up, updating statistics and full, differential and transactional log backups and other SSIS package tasks.
  • Extensive knowledge using PowerShell for different tasks.
  • Architects, monitors, and maintains the Microsoft SQL Server Database environments which support applications.
  • Experienced in configuring, maintaining and troubleshooting server-class hardware and operating systems.
  • Experience in Extract, Transform and Load ETL data from heterogeneous data Sources like Oracle, MS Access, UniData, and DB2 using MS SQL Integration Services SSIS , DTS, BCP and Bulk Insert.
  • Experienced in creating, managing and delivering server based reports with interactive views that provide valuable insight for business heading using MS SQL Reporting Services SSRS .
  • Experience with MSSQL Server Analysis Services SSAS .
  • Configuration and Administration of SharePoint Server 2007/2010 farms.
  • Excellent communication, coordination, presentation and analytical skills worked on 24X7 Production support, involved in an on call rotation.
  • Experience in SQL Server Policy-based Management.
  • Experienced in writing, troubleshooting, modifying and enhancing complex PowerShell / T-SQL scripts.
  • Migration from Sybase, Oracle and DB2 to SQL Server.
  • Proficient using Microsoft SQL Server, MS SQL Server Management Studio SSMS , MS Access, MS Visual Basic, Excel and other applications associated with query and reporting.
  • Advanced proficient in normalizing data received from a wide variety of sources, creating and executing database queries that organize data in a format suitable for analysis by auditors.

Skills

  • DBMS: MSSQL Server 2000/2005/2008/2008 R2/2012/2014, MYSQL, Oracle, MS-Access, Sybase, IBM DB2.
  • Operating Systems: Windows Server 2003/2008/2008 R2/2012/2012 R2, Windows /XP/Vista/7/8/8.1, MAC, Linux, Ubuntu.
  • Third party tools: Symantec, Redgate, Idera Diagonestic Manager, Idera Frag Manager Spotlight.
  • ETL tools: MS SQL Server integration services /SSIS/, DTS.
  • Reporting tools: SAP Crystal Report, MSSQL Server Reporting Services /SSRS/, PowerPivot.
  • Programming Languages: T-SQL, PowerShell, XML, HTML, VB.NET, JDBC, C , Java, Objective C, Swift, and C .
  • Applications: IIS, Visual Studio, FTP, Adobe Photoshop suite, Dreamweaver, Oracle CRMOD/CCOD, JIRA, SharePoint.
  • Networking: SAN, NAS, LAN, WAN.

Work History

Senior SQL Server Database Administrator

Confidential

Responsibilities

  • SQL Server 2014 installations, patches and upgrades, including both standalone and clustered environments of production, test and development.
  • Responsible for SQL server logical and physical database design, implementation, and maintenance.
  • Database maintenance, management and performance monitoring using third party tools including IDERA and Spotlight.
  • Using dynamic management views DMV and Dynamic Management Functions DMF , TSQL scripts, Triggers, and Store Procedures, troubleshoot and tune performance that include finding out long running queries and query costs.
  • Automate maintenance jobs in SQL Server job agent and task scheduler: such as shrinking database, index rebuilding, creating filtered indexes, index reorganizing, cleaning up, and updating statistics.
  • Analyzing Locks, Dead Locks using both Spotlight and DMVs and DMFs, and handling the isolation Level and Concurrency Effects.
  • Develop TSQL scripts to create database objects and perform DML and DDL tasks.
  • Create Databases, Tables, Indexes, Stored Procedures, Views, database management policies and Constraints, Defaults, Rules, Functions, Triggers, Cursors and Dynamic SQL queries.
  • Manage users and groups roles from Active Directory or SQL, provide appropriate server roles, map them to specific databases and grant specific privileges over selected database securable objects to ensure security and integrity.
  • Scheduling and automating maintenance plans using SQL Server Job Agent.
  • Design, implement and manage database maintenance and disaster recovery plans including replication, full /differential /transactional log backups with recovery procedures.
  • Architects, monitors, and maintains the Microsoft SQL Server Database environments which support applications.
  • Use Commvault to restore full, differential, and transactional log backups.
  • Configure Always on Availability groups using PowerShell scripts.
  • Migrate data from Unidata to SQL Server using SSIS packages.
  • Worked on Agile Scrum Methodology and SDLC Software Development Life Cycle to design high level database structure including packages, reports and data warehouse architecture.
  • Designed and implemented SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
  • Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files carrying out ETL processes.
  • Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices of error handling logics to handle bad data, avoid package failures and to maintain optimal performance.
  • Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case and schedule SSIS packages using SQL Server Agent.
  • Used VB.NET and C Script for Data Flow and Error handling using Script Component in MS SSIS.
  • Developed datasets to perform reporting and created interactive Drill down, Drill through, Tabular, Cross tab, Parameterized, Cascaded and Sub- reports, Report models and Ad-hoc reports using SSRS.
  • Used SSAS SQL Server Analysis Services to design, implement and manage data warehouses OLAP cubes and reporting solutions to improve asset management, incident management, and data center services.
  • Managed the historical data in the data warehouse from various data sources and generated various drill down, drill through, matrix and chart reports from SSAS cubes using SSRS.
  • Built efficient dimensions and fact tables with Star and Snowflake Schemas to perform analysis and deploy OLAP cubes on Development and Production Servers using SQL Server Analysis Services SSAS .
  • Provides expert level database administration support to developers and others as needed.
  • Use PowerShell to configure user accounts and give a necessary privileges for SQL logins.
  • Involved in writing and executing Stored Procedures, Functions, and Packages in PL/SQL.
  • Created Tables, Synonyms, Sequences, Views, PL/SQL Stored Procedures and Triggers.
  • Works on a HADR strategy, especially on Always On Availability Groups and SQL Server Clustering.
  • Configure, maintain and troubleshoot server-class hardware and operating systems.
  • Monitoring with team members and write a well-defined documentation for future use.

Lead SQL Server Database Administrator

Confidential

  • Wal-Mart Stores, Inc., is an American multinational retail corporation that runs chains of large discount department stores and warehouse stores.

Responsibilities

  • Perform SQL server logical and physical database design, implementation, and maintenance.
  • Install, configure SQL Server 2005/2008/2008R2/2012/2014 and apply periodic service packs and hot fixes cumulative updates for Dev, Staging and Prod environments.
  • Manage and work across 50 servers and more than 200 databases with OLTP databases.
  • Perform daily checkups on SQL jobs, replication, hardware diagnostics for hard drives, backups, disk-space, SQL and windows error logs as part of proactive maintenance plan.
  • Develop TSQL scripts to create database objects and perform DML and DDL tasks.
  • Create Databases, Tables, Indexes, Stored Procedures, Views, database management policies and Constraints, Defaults, Rules, Functions, Triggers, Cursors and Dynamic SQL queries.
  • Manage users and groups roles from Active Directory or SQL, provide appropriate server roles, map them to specific databases and grant specific privileges over selected database securable objects to ensure security and integrity.
  • Scheduling and automating maintenance plans using SQL Server Job Agent.
  • Design, implement and manage database maintenance and disaster recovery plans including replication, full /differential /transactional log backups with recovery procedures.
  • Set up and manage transactional log shipping, SQL Server Mirroring Synchronous/ Asynchronous , Fail over clustering and Transactional replication in multiple environments as part of disaster recovery plan and load balancing strategy.
  • Extensively used SQL native tools like Index tuning wizard, Database tuning advisor DTA , SQL profiler, Performance monitor, Activity monitor, Event viewer, dynamic management views and dynamic management functions for monitoring, performance tuning/analysis and troubleshooting.
  • Performance tuning by analyzing execution plans, creating and maintaining indexes rebuild/reorganize , Statistics, partitions, Client/Server Connectivity and structure modification.
  • Analyzing Locks, Blocks, Dead Locks, Resource Utilization, handling Isolation Level and Concurrency issues.
  • Perform usual cmd commands, configure SQL Server cluster nodes and stopping SQL server related services using PowerShell.
  • Implement database refresh using SSIS packages and automated backup/restore jobs.
  • Auditing of database for logins, users transactions, and database activities and resolving orphan users.
  • Migrated data and database objects from Oracle and Sybase to SQL Server 2012 and SQL Server 2014.
  • Configured SMTP Server for Database Mail setup and received Alerts.
  • Data Migration to and from various sources using SQL Server Integration Services SSIS .
  • Developed automated procedures to produce client data files on schedule using Microsoft Integration Services SSIS packages.
  • Develop reports using SQL Server Reporting Services SSRS .
  • Identify, recommend, and implement new database administration technologies.
  • Worked with a team of ETL developers, application developers, network engineers, server administrators, system analysts and testers.
  • Strong experience in mentoring with team members, documentation.

SQL Database Administrator

Confidential

Remote Tiger Inc. is a full service IT consulting firm offering end to end service and implementation solutions to clients worldwide.

Responsibilities

  • Responsible for SQL server logical and physical database design, implementation, and maintenance.
  • Create new databases, manage database security, enroll and map users.
  • Creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors, Temp tables and Dynamic SQL queries.
  • Experience in Normalization, Database design, Performance Analysis and Production Support.
  • Scheduling and automating maintenance plans using SQL Server Job Agent.
  • Design, implement and manage database maintenance and disaster recovery plans including full/differential /transactional backup and recovery procedures.
  • Set up and manage transactional log shipping, SQL Server Mirroring Synchronous/ Asynchronous , Fail over clustering and transactional replication.
  • Strong Experience in Performance Tuning including Updating Statistics, Re-Indexing Query Optimization, Client/Server Connectivity and structure modification.
  • Extensively used the native tools like Index tuning wizard, Database tuning advisor, SQL profiler, Performance monitor, Activity monitor, Event viewer for performance analysis.
  • Implement database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management.
  • Experience in analyzing Locks, Dead Locks and handling the Isolation Level and Concurrency Effects.
  • Executing stored procedures, creating always on availability groups and adding replicas, managing services, executing cmd commands using PowerShell.
  • Created Tables, Synonyms, Sequences, Views, PL/SQL Stored Procedures and Triggers.
  • Created PL/SQL functions to facilitate business functions and calculations.
  • Analyzing execution plans and index management for better Query Optimization.
  • Configured SMTP Server for Database Mail setup and received Alerts.
  • Auditing of database for users transaction, login and database action and removing orphan users.
  • Upgrading and downgrading SQL server instances.
  • Develop reports using SQL Server Reporting Services SSRS .
  • Data Migration to and from various sources using SQL Server Integration Services SSIS .
  • Worked with a team of business analysts, data architects, application developers, ETL developers and testers.
  • Strong experience in mentoring with team members, documentation and 24/7 on call production support.

SQL Server Database Administrator/SSRS/SSIS Developer

Confidential

Documents Authentication and Registration Office provide a reliable means of evidence through authentication and registration of documents, to facilitate contractual and other relations between persons and organizations both at domestic and International level and thus support the Justice System and Investment, besides ensuring the availability of documents whenever they are required.

Responsibilities

  • Installing, configuring, administering and securing test and production servers.
  • Create and optimize database objects, e.g. Tables, Views, indexes, cursors, stored procedures, functions, CLR code and Triggers.
  • Scheduling and automating maintenance plans using SQL Server Job Agent.
  • Administer, maintain, develop and implement policies and procedures for ensuring security and integrity.
  • Enrolling and mapping users following company policies and procedures.
  • Scheduling and automating full/differential/ transactional backups and implementing recovery strategies.
  • Configured and monitored database replication as high availability and disaster recovery strategy.
  • Upgrading the SQL Server Databases, Monitoring and Performances tuning.
  • Developed reports using SSRS, Crystal Reports with T-SQL, MS Excel and Access.
  • Developed automated procedures to produce client data files on schedule using Microsoft Integration Services SSIS .
  • Used PowerShell for automating repetitive tasks, executing jobs, stored procedures, configuring ports and IP addresses, working with Active Directory.
  • Implement data models, database designs, data access and table maintenance codes.
  • Installing and monitoring SQL agent jobs.

Hire Now