| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateCandidate's Name
MSSQL Server DBA
Phone number:PHONE NUMBER AVAILABLE E-Mail: EMAIL AVAILABLE
PROFESSIONAL SUMMARY
Over 7 years of experience in Microsoft SQL Server Database Installation,
Configuration, Administration, Maintenance and Performance Tuning, Backup/Restore
and Disaster Recovery on 2019/2017/2016/2014/2012. Applying service packs, hot fix
and cumulative updates in development, quality, and production environments.
Expertise in implementing different types of high availability and disaster recovery
(HADR) technologies like Replication, Log Shipping, Always-On and Windows Failover
Clustering.
Performance monitoring using built-in tools as well as third party tools.
SQL Server Reporting Services Installation, Configuration and Maintenance using Visual
Studio and Reporting Services.
Firsthand experience migrating scripts in a production environment, creating, and
modifying stored procedures, triggers, and functions based on business requirements.
Firsthand in implementing SQL Server Security through administering user permissions,
user roles and setting database authentication modes.
Experience in Data Migration between several versions
Experience Creating Packages, Jobs and Sending Alerts using SQL Mail/Database Mail.
Use Index tuning wizard and rebuild & reorganize indexes for faster Query Performance.
Expert in tuning databases by choosing indexes and using tools like Database Engine
Tuning Advisor (DTA), and SQL Profiler.
Experience in database issues like space, deadlocks, performance and blocking.
Experience in Monitoring and optimizing the performance of the database using native
tools and Third-party tools.
Ensure timely completion of the Databases regular refreshes keeping all the reporting
environment in sync
Hands-On experience in Upgrade of SQL server versions and applying patches and
service packs.
Use DBCC Utilities to maintain the consistency and integrity of each database in the
production server.
24 X 7 (Local as well as Global) Production Database on Call Support.
Use, VMware, Hyper-V
Excellent analytical, communication and interpersonal skills.
Use ticketing service like Service Now, Remedy
Used third party tools like Redgate, Century One, Golden Gate
Environments & Tools
Platforms Windows Operating Systems /XP/NT/2000/2003/2008 R2/2012/2016/ server,
Languages T-SQL, PL/SQL, Power BI, C++, Power shell, CMD,
RDBMS Microsoft SQL 2005/2008R2/2012/2014/2016/2017/2019, MS Access, Analysis
Server 2000/2005, power BI,
SQL Server Tools Enterprise Manager, Management Studio, SQL Profiler, DTS/SSIS (ETL), SSRS
Database Tuning Advisor (DTA), SQL server Migration assistant.
Third party tools Idara Diagnostic manager, Redgate tools, LiteSpeed, PAL tools, SolarWinds, GoldenGate
SCORE CARD
Skills Years of Experience
Performance Monitoring / Tuning / 7+
Troubleshooting/Server Admin./Microsoft Suite
(Acces,Word,Excel,PowerPoint) Report
development,Crystal Reports
Transparent Data Encryption 7+
Azure Cloud Computing, IaaS,PaaS and SaaS 2+
SSIS, SSAS, SSRS 7+
Candidate's Name
MSSQL Server DBA
Phone number:PHONE NUMBER AVAILABLE E-Mail: EMAIL AVAILABLE
Title SQL Database Administrator May 2023 - Present
Client - STG INTERNATIONAL, ALEXANDRIA VA
Responsibilities:
Provide guidance and support for database engineering of large-scale systems, major
system elements.
Projects short term & long-term requirements for Database Administration and design
in conjunction with other teams requirements.
Involved in the migration of SQL Server 2005 databases to SQL Server 2019.
Involved in creating Stored Procedures, views, tables, constraints.
Monitor all servers including High availability and Disaster recovery servers.
Experienced in Data Modeling (Logical and Physical Design of Databases),
Normalization and building Referential Integrity Constraints. Designed schemas. Built
tables, FKs, PKs, etc. by providing a structure that meets the business needs.
Installed and managed reports using SQL Server 2012 Reporting Service.
Evaluated data storage considerations to store databases and transaction logs.
Created databases using Transact SQL Statements, SQL Server Management Studio and
Database Wizard.
Participated in implementation of new releases into production.
Managed trouble shooting of Client connections, viewing error log and applications.
Extensive experience in troubleshooting database issues, working with multiple
technology and engineering teams, and have a deep knowledge of IT infrastructure.
involved in the planning and development of the database systems, as well as
troubleshooting any issues that may arise.
Day-to-day administration of live SQL Servers, Databases.
Performed daily tasks including backup and restore by using SQL Server native tools like
SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, Database
Engine Tuning Advisor etc.
Designed and implemented Security policy for SQL Servers.
Responsible for monitoring and making recommendations for performance
improvement in hosted databases like index creation, index removal, index modification,
file group modifications, and adding scheduled jobs to re-index and update statistics in
databases.
Used Stored Procedures, DTS packages, BCP for updating Servers.
Developed and optimized database structures, stored procedures, Dynamic
Management views (DMVs), DDL triggers and User-Defined Functions (UDFs).
Used Log shipping for synchronization of database.
Performed daily, weekly, and monthly Database Maintenance tasks.
Managed SQL Server security by creating roles and security groups.
Maintained data integrity by performing validation checks.
Involved in Fine-tuning of database objects and server to ensure efficient data retrieval.
Give support and advice applications side teams, department.
Work in a dynamic team environment and possess time management skills to meet
schedules.
Environment: SQL Server 2022/2019/2017/2014/2012/2008, SQL DB Access,
Performance Monitor, SQL Profiler. Windows 2003 Enterprise server.
Title Sr. SQL Server Database Administrator
Network Rail Consultant, Texas Feb 2020 Apr 2023
Responsibilities
Involved in the migration of SQL Server 2012 databases to SQL Server 2019.
Involved in creating Stored Procedures, views, tables, constraints.
Candidate's Name
MSSQL Server DBA
Phone number:PHONE NUMBER AVAILABLE E-Mail: EMAIL AVAILABLE
Monitored the server for High availability of the servers.
Experienced in Data Modeling (Logical and Physical Design of Databases),
Normalization and building Referential Integrity Constraints. Designed schemas etc. by
providing a structure that meets the business needs.
Installed and managed reports using SQL Server 2012 Reporting Service.
Evaluated data storage considerations to store databases and transaction logs.
Created databases using Transact SQL Statements, SQL Server Management Studio and
Database Wizard.
Participated in implementation of new releases into production.
Managed trouble shooting of Client connections, viewing error log and applications.
Give support and advice applications side teams, department.
Day-to-day administration of live SQL Servers.
Performed daily tasks including backup and restore by using SQL Server 2012 tools like
SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database
Engine Tuning Advisor.
Designed and implemented Security policy for SQL Servers.
Responsible for monitoring and making recommendations for performance improvement
in hosted databases like index creation, index removal, index modification, file group
modifications, and adding scheduled jobs to re-index and update statistics in databases.
Used Stored Procedures, DTS packages, BCP for updating Servers.
Developed and optimized database structures, stored procedures, Dynamic Management
views (DMVs), DDL triggers and User-Defined Functions (UDFs).
Used Log shipping for synchronization of database.
Performed daily, weekly, and monthly Database Maintenance tasks.
Managed SQL Server security by creating roles and security groups.
Maintained data integrity by performing validation checks.
Involved in Fine-tuning of database objects and server to ensure efficient data retrieval.
Good Understanding & Knowledge on Cloud computing and implementations including
Infrastructure as a Service (IaaS) on VM
Experience configuring and troubleshooting Geo Replication and OMS Storage for Event
Audits (Azure)
Experience working with Database Synchronizations and HUB - MEMBER Topologies
Experience troubleshooting automated backups and metric management (Azure)
Performed Migration from on premise servers to Azure cloud.
Deploy Database from on-premises to Azure Cloud.
Visual Studio - Design a new table, modify existing table, or quickly add new or modify
existing columns, constraints and indexes.
Visual Studio - Develop, build, test and publish database from a source-controlled
project.
Environment: SQL Server 2019/2017/2016/2014/2012/2008R2, SQL DB Access, Performance
Monitor, SQL Profiler. Windows 2012 Server.
Title Sr. MS SQL Server Database Administrator
ABYSSINIA. LLC Virginia (US), Feb 2018 Jan 2020
Responsibilities
Installation, administration, and maintenance of MS SQL databases.
Provided 24 x 7 production support to high critical databases and performed backup
and recovery of large databases.
Administered MS SQL databases on various server platforms.
Managed users, their security privileges, and accesses in MS SQL databases, created
groups, roles, users and assigned access privileges to each.
Monitored, assessed reconfigured database storage spaces, capacity and estimated
sizing and growth requirements in MS SQL Server Databases.
Worked with developers regarding testing and accommodating new functionality of
Candidate's Name
MSSQL Server DBA
Phone number:PHONE NUMBER AVAILABLE E-Mail: EMAIL AVAILABLE
database interfaces.
Created, configured, and managed various types of database objects like tables,
indexes, functions, procedures, packages, triggers, store procedures and database
infrastructure objects like tablespaces, data files, log files, etc.
Created and automated a new process of incorporating XML data into MS SQL server
and upgraded databases usually from MS SQL 2005 to 2008/2008 R2 in more than 25
databases and migration of MS SQL from 32bytes to 64bytes.
Apply patches to production databases as required by the business.
Reformed De-fragmentation /Reorganization of database, Re-build indexes and move
table in MS SQL Database.
Wrote complex T-SQL queries and stored procedures for retrieval of data and other
applications.
Created DTS package to export and import data from SQL Server to MS Access, text
files and excel files.
Automated data clean up and data migration efforts.
Set up backup and recovery procedure using clustering, log shipping and mirroring in
MSSQL for hot backups and cold backups, incremental and full backups and performed
database cloning to setup test and development database.
Exported and imported data from text files, excel to SQL Server database using bulk
copy insert and BCP utility.
Recovered databases during the event of crash on several occasions and these were to
point in time.
Created & maintained databases, tables, indexes, store procedures, roles, profiles,
partitions and other schema objects.
Played a good team member among project team and entire infrastructure team.
Title MSSQL Database Administrator
Intelsat, Illinois, Chicago Jun 2015 - Jan 2018
Responsibilities
Installation, Upgrade, Configuration and Migration of Microsoft SQL Server in clustered and
non-clustered production environments.
Planning for High Availability and Disaster recovery of databases using mechanisms like
Replication, Log Shipping, Always On and Clustering.
Responsible for performance tuning and optimization of databases using tools like SQL
Profiler, Query Analyzer Database Engine Tuning Advisor.
Experience in MS SQL Server Performance Tuning, Query Optimization, Client/Server
Connectivity and running Database Consistency checks Using DBCC.
Extensively work on using System Monitor and SQL Server Profiler to identify
bottlenecks, discovering slow-running queries.
Evaluate and monitor execution plans, query plans, key lookup operators for all troubled
code, Evaluate transaction isolation levels.
Create maintenance plans and jobs to achieve maximum performance.
Performed Migration from on premise servers to Azure cloud.
Support ETL process and deploying SSIS package
Good Understanding & Knowledge on Cloud computing and implementations including
Infrastructure as a Service (IaaS) on VM
Extensively worked on upgrading Microsoft SQL server, failover clustering, log
shipping, and replication, using System Monitor and SQL Server Profiler to identify
bottlenecks, discovering slow-running queries, performing backup and recovery
databases, and implementing database modifications on production servers.
Candidate's Name
MSSQL Server DBA
Phone number:PHONE NUMBER AVAILABLE E-Mail: EMAIL AVAILABLE
Hand on experience in troubleshooting of all databases related issues.
Conduct baselining of SQL Servers to identify potential bottlenecks in reference to
Memory, Disk I/O, CPU, database locks using SQL native tools & DMVs as well as third
party tools.
Involve in development of database including creating new databases, modification of
existing databases, & creating reports to meet business needs.
Support data migration from Excel, Flat file to Microsoft SQL Server by using BCP and DTS
utilities as well as Extracting, Transforming and Loading of data using Microsoft
SQL Server SSIS and DTS.
24 X 7 Production Database on Call Support.
Migration SQL Server 2008 to SQL Server 2014/2016 and handled post migration issues.
Automated SQL Jobs day-to-day operations, critical SQL Server Alerts, and repetitive
tasks.
EDUCATION
Electrical and Electronics Engineering
Addis College (Addis Ababa)
Bachelor degree (BSc)
|