We provide IT Staff Augmentation Services!

Senior Database Administrator Resume

SUMMARY

  • Database Administration (MS SQL 2005, 2008, 2008R2, 2012, 2014, 2016, 2017 & 2019).
  • Very good experience in Installation, configuration and maintenance of SQL Server.
  • Expert in handling tight planned/unplanned outage windows
  • Proven track record in planning and building high performance support systems, implementing best practices/methodologies and continuous improvement programs that resulted in improved quality of operations and service levels.
  • Experience in Supporting Microsoft Azure Database infrastructure.
  • Experience in handling AWS RDS like Cassandra, Postgres, MSSQL Databases.
  • Experience in Database backup and disaster recovery procedures.
  • Experience in Log Shipping, Replication - Snapshot and Transactional.
  • Knowledge of SQL Server Clustering, Analysis Services & Reporting Services.
  • Experience in MS SQL Server upgrades from SQL Server databases.
  • Experience in SSIS & SSRS (2005, 2008, 2012 & 2014)
  • Experience in PowerShell scripting.
  • Strong knowledge of the Software Development Life Cycle (SDLC), Change Management (CM) process, and ITIL-based methodology.
  • Applied Service Packs and hot fixes.
  • Delivers high quality work and performs well under pressure.
  • Works under minimal supervision and has ability to prioritize own workload, and has worked on complex large-scale projects, requiring interacting with people of various technologies.
  • Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
  • Experience in providing Capacity planning reports to the management.
  • Expertise in Managing Virtual Environments Hyper-V and VMWare.
  • Experience in Storage Administration EMC VNX, VPlex and HP 3Par.
  • Created complex DTS Packages for Data Migration and Transformation, experience in data migration from oracle /excel to SQL Server 2000/2005/2008.
  • Expert in regular Database Maintenance - Disk Space Monitoring, Backup and Recovery, Database Tuning.
  • Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions. Very good T-SQL Programming skills.
  • Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
  • Has the ability to work in a fast paced environment, Good team player.

TECHNICAL SKILLS

RDBMS: MS SQL 2005, 2008, 2008 R2, 2012, 2014 & 2016.

Hypervisor: Hyper-V, VMWare.

Storage: EMC VNX & VPlex, HP 3Par

Backup Tools: Symantec NetBackup, HP Data Protector.

Programming/Scripting: SQL,PL/SQL, Unix Shell

OS Environments: Windows 2003, 2008, 2012 & Red Hat Linux 4.5.

Hardware: IBM, HP, Dell, EMC & Compatibles.

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Administrator

Environment: Microsoft SQL Server 2005, 2008, 2008R2, 2012, 2014 & 2016 Hyper-V, VMWare, EMC VNX 5800, EMC Vplex, Symantec Netbackup

Responsibilities:

  • Handling Clients production Databases and maintaining High Availability like AlwaysOn AG, replication, mirroring and logshipping.
  • Install configure and maintain AlwaysOn AG cluster with single primary and multiple secondary nodes in the same Datacenter and Distributed AG across different datacenters.
  • Design, implement & maintain objects Replication (transactional & snapshot) to maintain data consistency across the nodes depending upon the requirement.
  • SQL standalone/Cluster Installations.
  • Migrated Databases from on-prem MSSQL Server to Cassandra and Postgres.
  • Manage and support AWS RDS instances like Cassandra, Postgres, MSSQL.
  • Performing Database maintenance activities like Backups, Restoring, and Re-indexing etc.
  • Managed all phases of the software development lifecycle (SDLC).
  • Creating Maintenance plans and jobs for automation of the repetitive task & Monitoring the Scheduled jobs
  • Analyzing, Identifying and Resolving performance issues of the server
  • Configuration and troubleshooting of high availability and disaster recovery features like log shipping, mirroring, replication, clustering etc.
  • Analyzing and troubleshooting the SQL Server processes and jobs
  • Manage day-to-day SQL Server Administration with PowerShell
  • Maintain the SQL Server environment using PowerShell scripting and programming options.
  • Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
  • Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
  • Developing reports on SSRS on SQL Server (2005/2008/2012 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • Solving Disk space, Log files full and database file full related issues on SQL servers.
  • Proactively working on Performance and Blocking issues on servers by auditing Databases.
  • Installations, patching, cumulative upgrades, hot fixing, backing up and recovering high impacting databases, monitoring and administration of jobs. Installations are made on both stand-alone as well as clusters
  • Replication Set up end to end
  • Work as part of a team and provide 7×24 supports when required.
  • Managing Virtual Environments Hyper-V and VMWare.
  • Managing and supporting Production, Development & TEST environments.
  • Setup and maintain documentation and standards.
  • Developed SQL scripts for maintaining administration tasks.
  • Allocating system storage and planning future storage requirements for the database system for all the clients
  • Created and maintained users and user groups.
  • Installing and upgrading the database server and application tools
  • Work as part of a team and provide 7×24 supports when required.

Confidential

Senior Database Administrator

Environment: Microsoft SQL Server 2005, 2008, 2012 & 2014 Windows 2008,2012 Server, NetApp, Hyper-V, Oracle VM, HP Dataprotector

Responsibilities:

  • Involved in installation and configuration of SQL server 2005, 2008 and 2012.
  • Applied patches and service packs to keep the database at current patch level.
  • Responsible for configuration of Microsoft Server/Client Products and implementation.
  • Managing and supporting Production, Development & TEST environments.
  • Database High Availability: Installed, Configured and Managed Database Mirroring, Replication, AlwaysOn and Fail-Over Cluster Servers in SQL Server 2012.
  • Migrated MSSQL Databases from in premises to MS Azure Cloud.
  • Configured bulk import jobs using powershell.
  • Automated routine/repetitive jobs using powershell.
  • Configured bi-directional transactional replication to maintain consistent data across the clusters.
  • Regular Database Maintenance jobs
  • Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
  • Involved in Analysis and Design Documentation, User requirements and maintained good documentation.
  • Supported production and development databases.
  • Implemented SQL standards in writing Stored procedures, Triggers, Views, Sql functions and locking issues.
  • Coordinated physical changes and performance monitoring of two replicated production servers, all Microsoft SQL Server 2005.
  • Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability.
  • Developed SQL scripts for maintaining administration tasks.
  • Applying Cumulative, Mini, Bug Patches & Performing Upgrades.
  • Created and maintained users and user groups.
  • Backup and Recovery plans for Field office and Headquarters database servers.
  • Maintained the field office database backups through SQL mail Scripts.
  • Interacting with the users and troubleshooting the problems involved with the development of stored procedures.
  • Responsible for General Database Administration and Performance tuning.
  • Experienced in resolving deadlock and blocking issues for concurrent users.
  • Developed Database Backup Scripts and automated this process.
  • Applied patches and service packs to keep the database at current patch level.
  • Involved in Analysis and Design Documentation, User requirements and maintained good documentation.
  • Implemented SQL standards in writing stored procedures, Triggers, Views, Sql functions and locking issues.
  • Documenting MS SQL Server database design, implementation and configuration.
  • Interacting with the users and troubleshooting the problems involved with the development of stored procedures.

Confidential

Senior Database Administrator

Environment: Microsoft SQL Server 2005, 2008, 2008R2 & 2012 Windows 2003, 2008, 2008R2, 2012 Server.

Responsibilities:

  • Involved in installation and configuration of SQL server 2005, Applied patches and service packs to keep the database at current patch level.
  • Responsible for configuration of Microsoft Server/Client Products and implementation.
  • Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
  • Responsible for General Database Administration and Performance tuning.
  • Experienced in resolving deadlock and blocking issues for concurrent users.
  • Developed Database Backup Scripts and automated this process.
  • Applied patches and service packs to keep the database at current patch level.
  • Responsible for configuration of Microsoft Server/Client Products and implementation.
  • Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
  • Involved in Analysis and Design Documentation, User requirements and maintained good documentation.
  • Supported production and development databases.
  • Implemented SQL standards in writing stored procedures, Triggers, Views, Sql functions and locking issues.
  • Documenting MS SQL Server database design, implementation and configuration.
  • Interacting with the users and troubleshooting the problems involved with the development of stored procedures.
  • Managed 24/7 Database Environment (Dev, Test/UAT and Production).
  • Installed, Configured, and Administered SQL Server 2008R2, 2012 in development, test, and production environment.
  • SQL/T-SQL, Triggers, And Stored Procedure: Wrote SQL, T-SQL, Stored-Procedures and triggers.
  • Assisted SQL developers to optimize SQL queries, Stored Procedures and Triggers.
  • Monitoring and Performance Tuning: Performed database monitoring and Performance tuning.
  • Monitor Servers activity, and worked with clients to solve different problems.
  • Performed index and statistics management.
  • Managed SQL Server Error Logs, space usage, growth pattern.
  • Used DBCC and ALTER C statements to check and manage database consistency, index fragmentation/rebuilding, statistics.
  • Managed BLOCK and LOCK.
  • Database Automation: Created Backup jobs for different types of backup like FULL, Differential and Transaction Log.
  • Created Jobs for database maintenance Index fragmentation, rebuild, database statistics.
  • Data Modeling: Worked on different Data Modeling projects using ERwin for designing Logical & Physical Database.
  • Used Backward & Forward Engineering to create Logical and Physical database.
  • Index/Constraints, Triggers, Stored Procedure: Created and managed Index (Cluster/Non-Cluster), Constraints.
  • Security Management: Created and Managed users, group roles, schema, and security at object level, data encryption.
  • Export & Import data from/to Oracle, MySQL, and Access Database including flat files like text, excel, and CSV files to SQL Server 2005/2008.
  • Database Migration: Migrated MS Access databases into MS SQL Server.
  • Migrated Oracle 10g, MySQL database into MS SQL Server 2008R2.
  • Imported data from Oracle,Excel, Flat file, CSV file to SQL Server Database,.
  • Backup/Recovery: Work experience and strong knowledge in disaster recovery.
  • Rebuild databases using backups.
  • Reports: Installed, Configured, and administered SQL Server Reporting Services (SSRS).
  • Developed Reports using SSRS.
  • Developed Ad-hoc Reports using Report Builder 3.0, 2.0.
  • Deployed Reports.
  • Managed security for reports.

Confidential

Senior Database Administrator

Environment: Microsoft SQL Server 2005, 2008 Windows 2003, 2008

Responsibilities:

  • Maintained mission critical production database as well as production applications including Emergency off-hour support.
  • Installed and configured SQL Server 2005, and 2008R2 on as standalone and Clustered Servers.
  • Automating Database tasks (Created jobs, alerts, and schedules for database maintenance tasks).
  • Wrote SQL/T-SQL codes, stored Procedures, Triggers and Functions.
  • Helped database developers to tune up SQL/T-SQL Queries.
  • Applied Service Packs, and hot fixes.
  • Performed database backups, restored database from backup.
  • Replication: Configured and maintained transactional and merge replication.
  • Security Management: Access and security management like creating Logins with appropriate roles. creating users and groups and granting and revoking privileges for data security.
  • Migrated Oracle, MySQL, MS Access 2000/97 databases into MS SQL Server 2000and2005.
  • Standby and Mirroring: Configured and Maintained Replicated database using Log Shipping and Replication in SQL Server 2000 and 2005 for high availability.
  • Performed performance tuning: Using SQL Server profiler, Windows performance monitor and Database engine tuning advisor to analyze and fine tuning of long running queries and stored procedures and slow running servers.
  • Documentation: Created documentation for installation, monitoring procedures, security policies, configuration changes, migration procedures, and best practices.
  • Reporting Services: Installed, configured and maintained SQL Server 2000/2005 Reporting Service.

Hire Now