We provide IT Staff Augmentation Services!

Database Administrator (dba) Resume

MO

SUMMARY:

  • Database administrator (DBA) with extensive experience installing, configuring and supporting next - generation database solutions in SQL Server environments; an effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business/management & significant experience working with steering committees; Self-motivated team player with excellent verbal and writing communication skills & ability to learn things fast and a discerning mind
  • Administering MSSQL Server 2016, 2014, 2012,
  • Experience on Azure databases
  • Installation and configuration SQL 2016/ 2014/2012/2008 R 2/2008/2005.
  • Upgraded inplace and sidebyside upgrade from SQL 2008, 2008 R2 to 2014 & 2016.
  • Performance tuning
  • Data modeling, purging/archiving databases
  • Security Auditing and maintaining server/ database level permissions
  • Installing, configuring and troubleshooting MSQL cluster instances
  • Expertise in Database administration activities like Installation, Configuration, Backup &Recovery, Database Security, Data Integration Services, Database designing and Query optimization.
  • Windows DNS, DHCP, Active Directory, Kerberos, Windows Administration and Group Policies
  • Running Database Consistency Checks using DBCC
  • Experience in configuring Always on with High Availability (HA) and Disaster Recovery (DR)and Windows Server Failover Clusters, Contained Databases, Online Index Rebuilds, CDC, TDE
  • Installing and configuring Foglight
  • Partitioning, Log shipping, Linked Servers
  • Good hands on experience on Microsoft Operations Manager( MOM)
  • Snapshot and Transactional replication implementation & troubleshooting
  • DTS Packages, SQL Server Integration Service (SSIS) and SQL Server Reporting Service (SSRS)
  • Database Objects development (Tables, Views, Stored procedures, Cursors, T-SQL scripts and batch files)
  • Database Mirroring, Database Snapshot and Service Broker.
  • Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
  • Expert in Database Capacity Planning and Maintenance.
  • Supporting and configuring SQL Server Reporting Services.
  • Good knowledge on SQL Server database, t-log and memory architectures and internals.
  • Experience in AWS design and Administration with knowledge in EC2 and AWS.
  • Experience in Microsoft Azure and Amazon AWS cloud implementation.
  • Participated in planning of Disaster Recovery Planning, Execution and Testing.
  • Basic T-SQL Developer skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers.
  • SQL debugging and query optimization and Schema Maintenance
  • Good hands-on experience on all high availability solutions
  • Data Security, Backup & Recovery
  • SQL server profiler and Index Tuning Wizard
  • Standby/Failover Administration
  • Ability to work in OLTP & OLAP environments
  • Working on 2.2, 2.6 & 3.0 mongo DB
  • Upgraded from 2.2 to 3.0 and 2.6 to 3.0.
  • Implemented 3 node replication
  • Worked on unix platform like Solaris and linux.
  • Good theoretical knowledge on new features in SQL Server 2008, 2012.
  • Working on sharding environment.
  • Created index for performance.
  • Implemented wired tiger from default storage.
  • Worked on basic shell scripting and created shell scripts and updated the scripts as per the requirement for automate the process.

PROFICIENT IN AN ASSORTMENT OF TECHNOLOGIES, INCLUDING;

Programming: C, C++, TSql, HTML

Operating System: WINDOWS 98|XP|2000|VISTA| and WINDOWS Server 2000, 2003, 2008, 2012,2014 & 2016

Front-end: MS-OFFICE, Foglight, SQL Client Tools, SSCM, Management Studio, Query Analyzer, SQL Profiler, SSIS, Netbackup,SQL monitoring tool, DPA(Ignite) & OEM.

Backend: Mongo db(nosql), RDBMS Concepts, SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014 & 2016, Oracle 9i & 10g

Others: SCOM 2012, Foglight Deployment and Administration and administration

WORK EXPERIENCE:

Confidential, MO

Database administrator (DBA)

Responsibilities:

  • Primarily working as a PRODUCTION support DBA giving round the clock support for SQL instances running on SQL Server 2016/ 2014/2012/2008 R2/2008 on virtual, physical and cloud environments.
  • Installed, configured, and migrated to SQL Server 2016 from 2012/2008R2 on physical, virtual and cloud.
  • Upgrading all the lower version from 2008, 2008 R2, 2012 to 2016 always on environment.
  • Implemented High Availability in SQL 2016 by configuring Always on Availability groups across Windows Server Failover Clustering using Failover Clustering Instances.
  • Preparing the Run plans on lower environments to migrate/upgrade the sql server instances.
  • Migrating the SSIS packages, SQL Jobs, Linked servers on to new instance.
  • SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
  • Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
  • Experienced with database sizing and capacity planning for production servers.
  • Experienced with creating logical and physical database design for development projects.
  • Created and scheduled maintenance plans for Database backups, log backups and cleanup.
  • Consolidating client foot print by planned unused databases and moving from physical server to virtual servers.
  • Database refreshes will be done with Netbackups with a scheduled sql jobs.
  • Set up SQL server Clustering and Always On technologies
  • Migration of database from one datacenter to another datacenter by using db mirroring and XIV storage replication around 500 databases.
  • Experience in working on PowerShell scripts for DBA reports.
  • Experience in working on all the High Availability Disaster Recovery Methods during migration/upgrades.
  • Worked on creating and maintaining Azure SQL Databases (PAAS) on singleton, elastic pool and managed instance.
  • Created and managed databases on Azure Virtual Machines (IAAS).
  • Involved in Performance Tuning on Production, QA and Development SQL servers for on premise and cloud-based servers on Azure VMs (IAAS).

Confidential, TX

Database administrator (DBA)

Responsibilities:

  • Installed and administered 2014 and 2016.
  • Database backup taken to azure account in 2016.
  • Created a table in memory for better performance in 2016.
  • Installed, managed and administrated MS SQL Server 2014/2012/2008 R2/2008/2005 Production and Non-Production Servers.
  • Consolidating client foot print by planned unused databases and moving from physical server to virtual servers.
  • Migration of SQL Server 2008R2 to 2012/2014.
  • Set up SQL server Clustering and Always On technologies
  • Migrating all the databases from physical standalone to virtual cluster server.
  • Migration of database from one datacenter to another datacenter by using db mirroring and XIV storage replication around 500 databases.
  • Daily database refresh methods I have used are sql native restore, Flexclone restore ( Confidential tool) & XIV snap.
  • Performed always on configuration with HA (FCI) and DR.
  • Experience in working on PowerShell scripts for DBA reports.
  • Experience in Configured and maintained database refresh from Production to UAT and Development Servers with Confidential FlexClone technology and XIV snaps.
  • Provided End to End SQL Server Administration Support to around 900 SQL Servers.
  • Designed and Implemented database maintenance plans for various database activities.
  • Performing SQL Server installations, service pack upgrades configuration.
  • Worked extensively on monitoring the database, checking error logs, checking the log file size and free space in the data drives.
  • Worked on setting up log shipping, database mirroring and building redundancy to eliminate single point of failure and troubleshooting Log shipping and SQL clustering issues.
  • Implemented Database Mirroring and Transactional Replication as a part of DR plan.
  • Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
  • Used Database Consistency Checks- DBCC commands for database maintenance
  • Detected and Resolved Locks and Deadlocks using the Trace Flags and Native tools such as Profiler and the Activity Monitor
  • Running Index Tuning wizard for optimal query performance
  • Performed all aspects of database administration, including backups and recovery
  • Handled orphaned users while moving databases.
  • Scheduled weekly jobs and Maintenance tasks for better performance, created the alerts with Database Mail SMTP.
  • Setting up and maintaining linked servers, replication and SQL cluster servers.
  • Defragmentation of tables and indexes for improved performance and effective space management.
  • Worked on Profiler, Perform Counters, DMVs, DMFs and DTA to tune the databases, servers, and query tuning.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Extensively worked on Business Intelligence tools such as SSQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analytical tool (SSAS).
  • Mongo DB administration for content assistance and proposal builder application.
  • Regular mongo backups and restores on lower environments.
  • Built the replication nodes for high availability.
  • Upgraded mongo database from 2.2 to 3.0 versions.
  • Regular heath checks on database by monitoring the space.
  • Based on client required need to do collection backup and restore.
  • Performing DML operation on data.
  • Experience on sharding environment.
  • Monitor MongoDB cluster connectivity and security
  • Manage and review MongoDB log files
  • File system management and monitoring

Confidential, NC

Database administrator (DBA)

Responsibilities:

  • Providing End to End SQL Server Administration Support to all the IT-managed MSSQL Servers.
  • Installed and Configured MS SQL Server 2005/2008/2008 R 2/2012/2014.
  • Designed and Implemented database maintenance jobs for various database activities.
  • Performing SQL Server installations, SQL cluster builds, service pack upgrades and post-SQL build configurations.
  • Setting up database monitoring solutions TSQL scripts and SCOM 2012, checking error logs, checking the log file size and free space in the data files and drives.
  • Building redundancy to eliminate single point of failure and troubleshooting Replication, Log shipping and SQL clustering issues.
  • Designing and configure Sql failover cluster instance for Sharepoint site for maintaining the DB Inventory, team technical, process and standards documents.
  • Resolving SQL Clustering (FCI) Failures.
  • Experience in working on PowerShell scripts for DBA reports.
  • Planning storage capacity and accessing the hardware requirements for the upcoming requirements.
  • Maintaining server and database level user security and conducting SOX-compliance audits.
  • Worked on production Break fix issues which include performance, blocking and space related issues.
  • Database Migrations from SQL 2005 to 2008 &2012.
  • Using UIM tool (CA monitoring tool) to monitor/Test the SQL Server Databases alerts.
  • Implementing change requests, processing user work requests and resolving incident tickets.

Confidential, TX

Database administrator (DBA)

Responsibilities:

  • Performing regular server health checks before starting the business hours.
  • Performed always on configuration with HA (FCI) and DR.
  • Experience in Configured and maintained database refresh from Production to UAT and Development Servers with Confidential
  • Automating Database refreshes on SQL Server instance
  • Worked on various Recovery Models, Performing Backups & Recovery of data.
  • Provided End to End SQL Server Administration Support to around 1000 SQL Servers.
  • Designed and Implemented database maintenance plans for various database activities.
  • Performing SQL Server installations, service pack upgrades configuration.
  • Worked extensively on monitoring the database, checking error logs, checking the log file size and free space in the data drives.
  • Worked on setting up log shipping, database mirroring and building redundancy to eliminate single point of failure and troubleshooting Log shipping and SQL clustering issues.
  • Setting up and maintaining linked servers, replication and SQL cluster servers.
  • Maintaining server and database level user security privileges.
  • Experience on Working in table level partitioning for huge table for improving performance.
  • Defragmentation of tables and indexes for improved performance and effective space management
  • Monitored, set and controlled system capacity plan for future system requirements and made recommendations for space management and monitoring
  • Implementing change requests, processing user work requests and resolving incident tickets.

Confidential

Service Design Engineer

Responsibilities:

  • Involved in designing the Infrastructure of SharePoint application.
  • Installed and Configured MS SQL Server 2012, 2008/2008R2/2005
  • Performed migration/upgradation from lower to higher version.
  • Performing regular server health checks before starting the business hours.
  • Worked on various Recovery Models, Performing Backups & Recovery of data.
  • Setup backup and recovery procedure using SQL native Backup.
  • Provided End to End SQL Server Administration Support to around SQL and Web Servers.
  • Designed and Implemented database maintenance plans for various database activities.
  • Worked extensively on monitoring the database, checking error logs, checking the log file size and free space in the data drives.
  • Worked on setting up log shipping, database mirroring, SQL AlwaysOn, transactional replication and building redundancy to eliminate single point of failure.
  • Experience in Performing Cluster operations, failover and failback, adding dependencies and troubleshooting.
  • Worked with other Technical Teams like Application Admin team, Server team and Network team to solve Performance and/or connectivity issues.
  • Troubleshooting functional/technical issues in the application and raising bugs with the Env team.

Confidential

Database administrator (DBA)

Responsibilities:

  • Performing a role of Primary DBA, handling about all SQL server databases.
  • Identifying and automating frequently performed activities at work.
  • Planning and configuring of MS SQL 2005/2008, SQL Cluster servers, SQL Litespeed.
  • Tracking recurring issues and providing solutions/fixes.
  • Installing and configuring Foglight (a third-part monitoring tool).
  • Setting up and maintaining linked servers, replication and SQL cluster servers.
  • Troubleshooting Replication, Log shipping and SQL clustering issues.
  • Maintaining server and database level user security privileges.
  • Configuring and troubleshooting Service Broker and Database mirroring.
  • Monitored and controlled system capacity plan for future system requirements.
  • Made recommendations for space management and monitoring.
  • Handled routine administration of SQL Server 2000/2005/2008.
  • Configured replication in SQL 2005 on test and production servers.
  • Working on service requests (SR) raised by users to meet their needs meeting SLAs.
  • Uploading report files (.rdl) in SSRS report sites and SSIS packages/files (.dtsx) to meet the business needs.

Confidential

Database administrator (DBA)

Responsibilities:

  • Involved in Installing and Configuring of MS SQL 2000/2005, SQL Cluster servers, SQL Litespeed (a third party tool for SQL server backups and restores) and upgrading servers and Migrating databases from SQL Server 2000 to 2005/2008.
  • 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.
  • Maintained server and database level user security privileges.
  • Worked on performance issues and optimized SPs and queries.
  • Set up and maintained linked servers, replication and SQL cluster servers.
  • Maintained the database consistency with DMV and DMF’s at regular intervals.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Involved in Troubleshooting Replication, Log shipping and SQL clustering issues.
  • Instrumental in Configuring and troubleshooting Service Broker and Database mirroring.
  • Set up and Monitored Backup jobs and DBA maintenance jobs using ignite tool.
  • Performed regular server health checks.

Hire Now