We provide IT Staff Augmentation Services!

Sql Server Dba Resume

4.00/5 (Submit Your Rating)

New, JerseY

SUMMARY:

  • Over 15 Years of Experience working as SQL Server DBA with SQL Server 2016,SQL 2014, 2012, SQL Server 2008 R2,2005/2000,
  • Worked in roadmap development, upgarde, migration to Microsoft SQL Server 20 16
  • Migration of database servicesfrom On - Premises to Cloud based technologies (AWS Amazon Cloud, Azure)
  • Design and implementation of High Availability(HA) systems (24x7x365) a nd Disaster Recovery models(DR): including Setup, Configuration, and Monitoring of Database Recovery strategies such as AlwaysOn, Failover Clustering, Replication, Log Shipping and D atabase Mirroring,
  • Provide on Call Support for Prod mission-critical (24x7) or problematic databases, and own problem resolution from end-to-end
  • Enterprise level Migration from On-Premises SQL Server to AWS Cloud EC2,RDS, setup will include S3,VPC,ELB,SNS,Cloudwatch,Cloudformation,Route 53,IAM,Kinesis,ECS and API gateway
  • Expert in leveraging AWS RDS, SQlServer/Aurora
  • Experience Using building infrastructure via AWS CLI
  • Design, setup administrator AlwaysOn high-availability(HA) and Disaster Recovery(DR) solution in SQL Server 201 6,SQL 2014
  • Manage SQL Server databases through multiple project lifecycle environments, from development to mission-critical production systems.
  • Expertise in best practices around high availability, automation and security on SQL Server worked on SQL Server's cloud based platform, Amazon Web Service(AWS), SQL Azure and Windows Azure Virtual Machine
  • Setup and Configure Log Shipping - Between On-Premises SQL Server and AWS EC2
  • Setup and Configure AlwaysOn Availability Groups - Between On-Premises SQL Server and AWS EC2
  • Expertise in common management tasks for SQL Server in AWS (Instance Classes, Storage, Provisioned IOPS, Multi AZ deployments, VPC, Security groups, Option Groups, Parameter Groups, Backup & Recovery)
  • Expertise in Microsoft SQL Server Security in AWS & Managing SSL for Microsoft SQL Server DB instances
  • Designing and deploying scalable, highly availability, and fault tolerant systems on AWS
  • Expertise in Data Encryption, Data Duplication, Security, etc worked (VLDB) very Large Databases such as multi-terabyte Databases
  • Capabilities to provide AWS operations and deployment guidance and best practices throughout the lifecycle of a project.
  • Extensively worked in advanced performance tuning, Research and troubleshooting, Query optimizing database design, capacity planning and establishing standards for SQL installations, maintenance, database tuning, backup/recovery, Migration, and coding standard apply patching & upgrading SQL server software

TECHNICAL SKILLS:

Databases: SQL Server 2016, SQL Server 2014, SQL Server 2012,2008 R2, SQL 2005,2000,Azure SQL Database, Azure VM, Business Intelligence(BI), Amazon Web Service (AWS), AWS Cloud Watch,O racle11g , MYSQL 5.x, MS Access,OLAP,OLTP

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS), ETL Extract Transformation and Load., Business Intelligence(BI)

Performance Monitoring Tools used: Spot Light, IDERA, Solar Winds, Red Gate, LiteSpeed, SQL SentryOne, Confidential Tivoli TSM, Doubletake, SQL Server Profiler, System Monitor, Tivoli Monitoring, BMC Patrol, Lumigent Entegra , Informix,AWS Cloud Watch, Goden Gate etc

Operating System: Windows Server 20 12 , Windows 200 8 R2, / 2000 Server (64bit) , Windows 2000 Advanced Server server, Windows XP, Unix, LINUX. Shell Script

Storage: AWS S3 Cloud Storage, NETApp/EMC Storage Technologies, SAN,

Scripting: Transact SQL,Windows Power Shell,, Shell Script

Cloud Computing: AWS( Amazon web Services)

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA

Responsibilities:

  • Manage SQL Server databases through multiple project full lifecycle environments, from development - Staging to mission-critical production systems
  • Expertise in setup High Availability and Recoverability of databases using standard MS SQL technologies including AlwaysOn
  • Responsible for administration, maintenance, performance monitoring and availability of E nterprise Production SQL server environments
  • Provide on Call Support for Prod mission-critical (24x7) or problematic databases, and own problem resolution from end-to-end
  • Worked in roadmap development migration to all lower version of SQL Databases to Microsoft SQL Server 2016
  • Migrated on-premises SQL Server databases To AWS EC2
  • Expertise in Microsoft SQL Server Security in AWS & Managing SSL for Microsoft SQL Server DB instances
  • Provide on Call Support for Prod mission-critical (24x7) or problematic databases, and own problem resolution from end-to-end
  • D esign, Implement and maintain of Disaster R ecovery(DR) and High Availability (HA ) solutions with Alwayson , Log Shipping, Replication Database Mirroring, etc
  • Manage a centralized MS SQL Server 2014, SQL 2012 and 2008R2 Platform consisting of thousands of mission critical databases
  • Migration of existing on-premises SQL Server Databases To Microsoft Azure
  • Managed deployments of services to MS Azure and AWS worked on SQL Server's cloud based platform, SQL Azure and Windows Azure Virtual Machine
  • Design and deploy Microsoft SQL Server Instances in VM vSphere
  • Setup and Configure Log Shipping - Between On-Premises SQL Server and AWS EC2
  • Setup and Configure AlwaysOn Availability Groups - Between On-Premises SQL Server and AWS EC2
  • Designing and deploying scalable, highly availability, and fault tolerant systems on AWS
  • Capabilities to provide AWS operations and deployment guidance and best practices throughout the lifecycle of a project
  • Extensive worked on Migrating Databases residing on servers in one data center to another and Upgrading Database platforms to newer versions
  • Participate in software design reviews with developers to ensure that the architecture is scalable to meet long-term performance goals.
  • Database optimizing, Indexing, Index Partitioning, Table Partitioning, disk partitions, Query optimizing, and Disk optimizing. worked in Cloud Computing
  • Roles and Network Seccurity group /Rules AWS portal, AWS CLI,, Poershell

Confidential

SQL Server DBA

Responsibilities:

  • Manage a centralized MS SQL Server 2014, SQL 2012 and 2008R2 Platform consisting of thousands of mission critical databases
  • Expertise in High Availability and Recoverability of databases using standard MS SQL technologies including Always On
  • Provide on Call Support for Prod mission-critical (24x7) or problematic databases, and own problem resolution from end-to-end
  • Worked Azure SQL Database Environment
  • Manage SQL Server databases through multiple project lifecycle environments, from development to mission-critical production systems
  • Design, setup administrator AlwaysOn high-availability(HA) and Disaster recovery(DR) solution in SQL Server 2014
  • Worked in roadmap development migration to all lower version of SQL Databases to Microsoft SQL Server 2014
  • Responsible for capturing various database, server, and application metrics, observing trends that will help longer-term capacity planning and analysis efforts
  • D esign, Implement and maintain of Disaster R ecovery(DR) and High Availability (HA ) solutions with Log Shipping, Replication Database Mirroring, etc
  • Extensive worked on Migrating Databases residing on servers in one data center to another and Upgrading Database platforms to newer versions
  • Experience working with Windows Hyper-V Server, Azure, Windows Clustering including
  • Participate in software design reviews with developers to ensure that the architecture is scalable to meet long-term performance goals.
  • Database optimizing, Indexing, Index Partitioning, Table Partitioning, disk partitions, Query optimizing, and Disk optimizing.
  • Responsible for administration, maintenance, performance monitoring and availability of E nterprise Production SQL server environments
  • Evolve the quality and consistency of service delivered by our platforms through automation and process improvement
  • Design and Deploy Microsoft SQL Server on Virtualizing with VMware vSphere
  • Install, and setup configure Windows Server Failover Clustering (WSFC) in Windows 2012
  • Ensure backup and recoverability of all enterprise SQL server databases
  • Contribute to the ongoing development of technology and production processes company-wide.Keep abreast of new design tools, hardware, software and technology and make recommendations for future deployment
  • Document technical details of issues resolved and assist the team with building and maintaining technical repositories.
  • Work closely with the infrastructure team to perform SQL Server installations and to configure hardware and software so that it functions optimally with the DBMS. Plan and implement database upgrades as needed
  • Ensure appropriate procedures are followed for implementation of data and database changes
  • Develop and adhere to common database standards and procedures within a production operations unit. Maintain documentation related to database platforms, guidelines, methods and standards.
  • In-depth query performance tuning - detailed understanding of the query optimizer, execution plans, plan cache, cost estimation, indexes, and statistics
  • Strong working knowledge SAN/storage, hardware, and network components used in SQL Server implementations Extensive worked with NetApp/EMC storage technologies
  • Upgrade and Migrate all SQL Server databases from One Data Centre to Other in Enterprise Level data Centre
  • Worked as data architect or data modeler. Administers and controls an organization's data resources, including multiple relational databases and servers
  • Carry out cause analysis of Database/SQL performance problems and recommend a solution for Production as well as Release environments.
  • Contribute to the ongoing development of technology and production processes company-wide. Keep abreast of new design tools, hardware, software and technology and make recommendations for future deployment
  • Coordinate, schedule and implement database related patches; both software and security
  • Experience of Reporting, Analysis and Integration Services (SSRS/SSIS/SSAS)

Confidential

Sr SQL Server DBA

Responsibilities:

  • Upgrade and Migrate all SQL Server databases from One Data Centre to Other in Enterprise Level data Centre
  • Serve as primary DBA support for mission-critical (24x7) or problematic databases, and own problem resolution from end-to-end
  • Work with IT-Infrastructure team to design/optimize physical server and disk structure layout in production, test and development environments
  • Install Setup maintain and administering Microsoft Cluster(MSCS) in SQL Server 2005, SQL Server 2008 R2 on Windows 2008 and Windows 2003
  • Carry out root cause analysis of Database/SQL performance problems and recommend a solution for Production as well as Release environments.
  • Carry out analysis of performance reports and proactively identify expensive SQLs and other performance bottlenecks.
  • Keep abreast of new, performance-related SQL Server features and evangelize their use across IT teams.
  • Responsible for supporting and managing the enterprise-wide databases in Production, development and test environments
  • Migrated databases from SQL Server Using, ETL tool such as SQL Server Integration Services (SSIS),
  • Identified critical hardware and software upgrades required and worked with technical & business personnel from proposal to implementation
  • Microsoft SQL Server management and performance tuning. Focuses on index tuning, query modifications, Table partitioning and hardware optimization.
  • Extensive worked on Migrating Databases residing on servers in one data center to another and Upgrading Database platforms to newer versions
  • Experience working with Windows Hyper VM Server, Windows Clustering including
  • Active Directory and proper disk configuration

Confidential, New Jersey

Lead SQL Server DBA

Responsibilities:

  • Managing more than 175 SQL Servers, processing more than 12 million transactions per day with other DBA staff and automated most of the jobs to cut the high management cost and increased productivity
  • Take responsibility for database monitoring, troubleshooting, performance tuning 24x7 availability of SQL Server databases
  • Involved in advanced performance tuning, database design, capacity planning and establishing standards for SQL installations, maintenance, tuning, and coding standards
  • Redesigned a thorough backup and recovery strategy for all major production systems
  • Run diagnostic tools to identify database performance bottlenecks including Clustering and replication experience
  • Prepare set up environment for Disaster Recovery (DR Server) with Standby by ServerSet up configure and maintain Microsoft Cluster in SQL Server 2000/2005
  • Design setup maintaining strategies for High Availability systems (24x7x365)
  • Set and maintain and troubleshoot Replication, Log-Shipping, in SQL Server 2005/2
  • Designed and implemented Transactional and Snapshot Replication for Synchronization data between production and standby server in SQL Server 2005
  • Administrator all SQL Server Databases creation/Installation/configuration, backups, recovery/restore, automate jobs, performance tuning
  • Responsible for logical and physical Database design RDBMS with a significant effort towards application and database tuning
  • Take responsibility for database monitoring, troubleshooting, performance tuning and the 7x24 availability of SQL Server databases
  • summaries to consistently meet aggressive product release timeframes
  • Monitor and Maintain DB growth and capture changes for capacity planning
  • Take responsibility for database monitoring, troubleshooting, performance tuning and the 7x24 availability of SQL Server databases
  • Design and implement disk structures, space management strategies, transaction log architectures and recovery models
  • Wrote installation and procedural manuals for support staff
  • Performing substantial data cleanup, restructuring, and reporting deployed and monitored SSIS Packages including upgrading DTS to SSIS
  • Index evaluation and recreating of indexes and views based on data collection methods data modeling using ERWIN to document and maintain data model And data Dictionaries
  • Monitored Database Logs database objects, such as tables, indexes, rules, user-defined data types, defaults, database triggers & stored procedures (to implement complex business rules) worked with the application support/development teams for database upgrades and releases
  • Improve database efficiency by continuously monitoring database performance bottlenecks and perform tuning when required database support & problem resolution within virtualized and non-virtualized Windows 32-bit & 64-bit
  • Planning, implementation, and documentation of Microsoft SQL Server 2005/2008

environment: Deploy, maintain and test enhance all backup, failover, failback and disaster recovery capabilities of the databases as appropriate

Confidential Bank, New York

Senior SQL Server DBA

Responsibilities:

  • Administrator all SQL Server Databases creation/Installation/configuration, backups, recovery/restore, automate jobs, performance tuning, etc.
  • Involved in advanced performance tuning, database design, capacity planning and establishing standards for SQL installations, maintenance, tuning, and coding standards managing over 50 SQL Servers in multiple countries supporting several hundred users
  • Setup and maintain High Availability with Cluster
  • Successfully maintain peak performance of all primary databases by providing advanced tuning methods, customized scripts deploy, maintain and enhance all backup, failover and disaster recovery capabilities of the databases as appropriate
  • Prepare and set up environment for Disaster Recovery (DR Server) with Standby by Server
  • Designed and implemented Replication, Log Shipping in SQL Server 2000
  • Provided analysis and recommendations for implementing full-text indexing to meet management requirements designing, documenting, and performing all Replication Agent test plans, test designs, test cases, and test summaries to meet aggressive product release timeframes consistently
  • SQL Server troubleshooting worked for Sox compliance Auditing creating, testing, and reviewing set and maintain Log-Shipping, Replication in SQL Server 2000 take responsibility for database monitoring, troubleshooting, performance tuning and the 7x24 availability of SQL Server databases
  • Optimized the code and database for maximum performance

We'd love your feedback!