We provide IT Staff Augmentation Services!

Sql Server Dba/architecture Resume

0/5 (Submit Your Rating)

Atlanta, GA

SUMMARY

  • 8+ years of Microsoft SQL Server Database Administration, Architect & Development experience in SQL Server 2000/ 2005/2008/2008 R2/2012/2014 systems in OLTP and OLAP environment.
  • Installed SQL Server 2008/2008R2/2012/2014 on x64 - bit Operating System.
  • Configured ALWAYS ON AVAILABLITY GROUPS With SQL Server 2012/2014
  • Architect teh Database on Standalone server with WSFC and also design on FAILOVER CLUSTER INSTANCE by Configuring AAG on it.
  • Worked on DR site on implementing Architecture strategy.
  • Implemented side by side Migration of MS SQL Server /2008R2/2012 and applied Patches and Service packs to update different versions of MS SQL server.
  • Experience in upgrading SQL server software to new versions and applying service packs and patches.
  • Worked on applying SQL Server hot-fixes / Service Packs on all production and development instances on quarterly basis based on recommendations from Microsoft Tech-net.
  • Installed SQL Server Client on all Client Desktops.
  • Worked on VBLOCK Server’s by VCE from CISCO PROVIDER, configured DATABASE SERVERS on it.
  • Experience in working with Windows Servers / 2008/2012 .
  • Proficient with SQL Management Studio, Enterprise Manager, Query Analyzer, Business Intelligence development studio, Visual Studio, report builder 3.0, Scheduling jobs with SQL Server Agent.
  • Expertise in deployments, certificate renewals, process job tickets & bugs, test verifies backups and recovery.
  • Highly proficient in database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans.
  • Experience on High Availability and Disaster Recovery like Replication, Log shipping, Mirroring and Clustering and database security and permissions
  • Created Security by setting up groups and then logins for each Roles or Users for Maintenance of Databases.
  • Worked in Microsoft Distributed Transaction Coordinator (DTC)
  • Documented Disaster recovery plans and participated in disaster recovery drills.
  • Successfully implemented and tested Log Shipping technique used for warm backup solution for MS SQL server 2000/ 2005/2008 databases.
  • Proficient in implementing different types of Replication models like Snapshot, Transactional, Merge and Peer-Peer.
  • Experience in Implementing Database Mirroring in SQL server 2005/2008/2008 R2/2012.
  • Good knowledge about New features in SQL server 2012 & 2014
  • Involved in Installing, Configuring and Maintaining of both Active/Active & Active/Passive
  • Auditing database configuration and security configurations.
  • Experienced as aDeveloperinBizTalk Server2009/2006 R2/2006/2004
  • Strong experience indesigning,documentingandimplementingdifferentBizTalk architectural components
  • Strong experience inEnterprise Application Integrationwith BizTalk andMQ Seriesforasynchronous deliveryof data using messaging solution
  • Experience in working with huge databases, troubleshooting issues and documenting teh causes.
  • Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Database Engine Tuning Advisor, Windows performance monitor, DMVs, Resource
  • Governor, Data collection Reports, DBCC and Custom Script, Built in performance Report and Activity Monitor.
  • Experience in Scheduling and creating SQL Server jobs as well troubleshooting when jobs fail.
  • Proficient in migration of Data from Excel, Flat file, Non SQL db’s Oracle/Db2/Sybase to MS SQL Server by using SSIS.
  • Knowledge in SSAS and different schemas like Star Schema and Snow Flake Schema and also Data Modeling, Cubes and MDX queries. Created different storage modes for OLAP cubes like ROLAP and MOLAP
  • RDBMS experience, including SQL programming, data analysis and data verification and validation
  • Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
  • Extensive experience in implementing SSIS, SSRS, SSAS using Microsoft Business Intelligence development studio (MSBI) 2008R 2/2008/2005.
  • Working knowledge in SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) to manage ETL environment.
  • Developed writing parameterized Queries for generating reports, formatting report layout, sub reports using global variables, expressions and functions in SSRS 2005/2008R2.
  • Worked with highly transactional merchandise and investment databases with PCI compliance involving data encryption with certificates and security keys at various levels.
  • Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).
  • Management of schemas, Data modeling, objects & partitioning teh tables & indexes.
  • Ability to meet deadlines, quickly adapt to different project environments and ability to work with different team across geographical locations.
  • Experience in providing good production support for 24x7 over weekends on rotation basis.
  • Excellent organizational, interpersonal and communication skills with high level of adaptability and flexibility to adjust to changing work positions.
  • Strong time Management skills and excellent team player.
  • Ability to adapt quickly to changing environments.

TECHNICAL SKILLS

Languages: C, C++, SQL, T-SQL, PL/SQL

Database: MS SQL Server 2000/ 2005/2008/2008 R2,2012,2014 MS Access

Web Servers: IIS 6.0, IIS 7.0, IIS 7.5

Operating System: Windows 2000, Windows 2003/2008/Professional

Scripting: PowerShell 3.0/2.0

Disaster Recovery Tools: Log Shipping, Replication, Mirroring and Clustering Services

ETL Tools: DTS,SSIS, Informatica

Tools: SCOM, SCVMM, NetMon, SMB, SFTP, SQL Sentry

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

SQL Server DBA/Architecture

Responsibilities:

  • Create and manage databases across Development and Production instances using SQL Server Management Studio.
  • Migrated Datacenter from SQL 2000 TO SQL 2008R2 THEN SQL 2014 and Also Migrated SQL 2012 to SQL 2014 SERVERS.
  • Designed teh Database on Standalone servers with WSFC and also design on FAILOVER CLUSTER INSTANCE by Configuring AAG
  • Failover on both teh Primary & Secondary including teh Replica will be managed via Always On failover
  • Implemented AAG strategy on DR site.
  • Worked on HIPPA Compliance in Closed Loop Domain
  • Implement QA Environment working on AAG
  • Configure SQL SENTRY for Monitoring Database Servers
  • Work with Cisco Team on implementing VBlock and configured DATABASE Servers on it.
  • Design DATABASE Rollout plan for migration Task
  • Working Experience on SQL Server Licensing and also on SQL Sentry
  • Worked on Backstage environment by transfer scrubbed database data from our production servers to Backstage, by favoring Automated SFTP.
  • Documented teh Migration plan and its strategy.
  • Usage of new compression Techniques in SQL Server 2000/2012 for backup and restore jobs.
  • Disaster Recovery Planning, Testing and analyzing and continuous update of documentation.
  • Implemented AAG as a part of DR plan.
  • Creating Logins and Roles with appropriate permissions.
  • Creating and Maintaining Database Maintenance Plans.
  • Configured Database Mail for failure Job notifications
  • Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
  • Worked with DTS Packages to load teh massaged data into Data Warehousing System.
  • Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
  • Create Clustered and Non-Clustered Indexes to improve teh performance of database access.
  • Extensively worked on performance issues like Update statistics and Autostats
  • Involved in Capacity Planning, Database Normalization and De-normalization process.
  • Optimized teh database server usingDMV’s and DMF’sand performed acode reviewandtuningfor teh best performance of teh application.
  • Involved in Logical and Physical Data Modeling process using MS Visio.
  • Involved in Change Data Capture process.
  • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
  • Mentored team members to optimize SQL Queries.

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2012, 2008 (R2), Microsoft SQL Server 2000,2008R2,2012,2014, Windows 2003/2008 Server, IIS Server 7, MS Visual Source Safe, IIS 6.0, XML.

Confidential - Roanoke, VA

SQL Server DBA / Developer

Responsibilities:

  • Database Administrator/Database Programming/Product specialist.
  • Installation and Maintenance of SQL Server 2005/2008(R2)/2012/2014 on Test, Development and Production Environments.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
  • Extensively working on IMS performance issues like update statistics, rebuilding teh indexes at regular intervals for better performance.
  • Extensively worked on compliance issues.
  • To analyze long running slow queries and tune teh same to optimize application and system performance.
  • Worked on key performance indicators for customizable metrics.
  • To set up SQL Server configuration settings.
  • Monitoring SQL server performance using profiler to find performance and dead locks.
  • Managed Disk space, memory and User connections.
  • Rebuilding teh indexes at regular intervals for better performance.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Rebuilding teh indexes at regular intervals for better performance.
  • Managing teh clustering environment.
  • Using log shipping for synchronization of database.
  • To setup, implement, and maintain industry standards in database management.
  • Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
  • Experience working with IDERA in Server Monitoring for Performance Monitoring, Dead Lock, Blocking.
  • Monitoring SQL server performance using profiler to find performance and dead locks.
  • Monitoring teh servers using spot light third party Quest software.
  • Maintaining teh database consistency with DBCC at regular intervals.
  • Implemented teh online indexing on 24X7 environments.
  • Created teh documentation for issue diagnostics reports.
  • Migrated data to new location using Snapshot Replication, and implemented Transactional Replication to support up to date record of Inventory Information.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedure.
  • Involved in DATA Analysis like Analyzing and Accessing collection of Data.
  • To analyze long running slow queries and tune teh same to optimize application and system performance.
  • To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
  • To implement all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.
  • To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.

Environment: SQL Server 2000/2005 with clustering, Replication, T-SQL, Windows bit, SQL/PL SQL, DTS, SSIS, Profiler.

Confidential - CA

SQL Server DBA

Responsibilities:

  • Involved in designing of Conceptual Logical Model and Physical Model
  • Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages to import/export data feeds to/from data warehouse and claim systems
  • Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
  • Created SSIS packages to export data from Oracle to SQL Server Database.
  • Performance: Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
  • Supported clustering and replication for servers.
  • Generated database SQL scripts and deployed databases including installation and configuration
  • Responsible for tier 2 support for more than 10 SQL Servers in a 24x7 mission-critical/production environment.
  • Worked on CDC(Change Data Capture)
  • Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
  • Enabling and Disabling Change Data Capture (CDC).
  • Maintained cluster servers to provide high availability.
  • Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
  • Managing SQL server usingPowerShell scripts
  • Performed Administrative tasks in SQL Server usingPowerShell
  • Tune slow running queries using SQL Server Profiler
  • Worked with database tuning advisor, SQL server profiler, Performance monitor and activity monitor for Performance tuning
  • Import data across multiple instances using BULK INSERT and BCP Utility.
  • Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages to import/export data feeds to/from data warehouse and claim systems
  • Used ER/Studio to reverse engineer legacy database from Sybase to SQL Server.
  • Plan, analyze and develop Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements.
  • Created and tuned stored procedures, triggers and tables.
  • Created several materialized views and UDF’s to be accessed by teh new front end applications.
  • Managed Materialized and Partitioned views for better performance.
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance teh performance of databases
  • Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
  • Provide 24 X 7 supports to all production, development, staging and clustered servers.
  • Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service and SQL 2000 on windows 2003 enterprise edition.

Environment: SQL Server 2000/2005, T-SQL, CVS, Windows NT/2000/XP/2003, VMWARE

Confidential

SQL Server Developer/DBA

Responsibilities:

  • Installed SQL server 2005 on windows 2008 Enterprise Edition advanced servers, applied service packs and security fixes.
  • Migrating from SQL server 2005 to SQL server 2008 and redirecting users to migrated server.
  • Changes in schema and stored procedures according to changes made in application.
  • Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
  • Responsible for creating Virtual machines by using HYPER-V Manager and SCVMM tools
  • Worked with SCOM team to implement monitoring criteria for IIS and SQL servers
  • Responsible for Hosting WCF web services on IIS and good experience configuring IIS security for both web applications and web services.
  • Responsible for Application pools creations according application security and performance needs.
  • Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
  • Created checklists to install SQL Server installation, service packs, security fix and MS SQL cluster installation.
  • Implemented and Scheduled different Database Backup strategies like Full, Differential and Transactional log backup
  • Implemented SQL Server high availability solutions including clustering, replication and log shipping.
  • Have good experience in installing and configuring SSL certification for security reasons.
  • Writing scripts to automate SQL tasks using power shell.
  • Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
  • Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc. as required.
  • Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.
  • Design and implement Backups and Restore database policies.
  • Preparing teh golden bits and scripts for smooth deployments to production using applications like Octopus and Sequence manager.
  • Install, configure and maintain systems running Windows server 2003/2008 & IIS 6.0/7.0 and participate in server upgrade and planning.
  • Good experience in generating reports using SSRS services.
  • Involved in deploying and managing websites on IIS servers in both Preview and Production environments.
  • Capacity Planning, Storage Planning, Hardware Upgrade’s and Preparing Estimates for Database, table size growth.
  • Preparing RCA’s/Postmortem for high Severity tickets/issues.
  • Performance monitoring, remote administration, Web application management, automation for Internet facing applications.
  • Work on monitoring solutions using Microsoft System Center Operations Manager SCOM and Site Scope.
  • Install security patches, IPAK’s, perform Service account password reset, SSL Certificate renewal and other regular maintenance work. Build operations documentation and update out of date or incorrect information.
  • Provided 24/7 supports to all production, development, staging and clustered servers.

Environment: SQL Server 2005/2008, T-SQL, Windows 2003/2008, IIS 6.0/7.0,HYPER-V, SCVMM

Confidential

SQL Server Developer/DBA

Responsibilities:

  • SQL Server 2005 Database Administration.
  • Installed and configured more than 2GB ram in SQL Server 2005.
  • Managed teh migration of SQL Server 2000 databases to SQL Server 2005
  • Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load teh Data from various Databases and Files.
  • Installed, authored, and managed reports using SQL Server 2005 Reporting Services
  • Build ASP.NET web pages using VB.NET
  • Did trouble shooting of Client connections, viewing error log and applications.
  • Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
  • 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.
  • Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
  • Experience in implementing and maintaining new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
  • Transferred data (ETL) to Data ware house Environment using SSIS.
  • Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
  • Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2.5 Terabytes.
  • Managing teh clustering environment.
  • Expertise in SQL Server Analysis Services.
  • Managed VERITAS net backups.
  • To analyze long running slow queries and tune teh same to optimize application and system performance.
  • Maintaining teh database consistency with DBCC at regular intervals.
  • Expertise in creating and supporting in OLAP Cubes
  • Involved in development activities included hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.

Environment: SQL Server 2005/2000 Enterprise Edition, Windows Server 2003, ASP.NET, VB.NET, EMC Storage Area.

We'd love your feedback!