We provide IT Staff Augmentation Services!

Sr. Sql Dba Resume

3.00/5 (Submit Your Rating)

Ashburn, VA

SUMMARY:

  • Highly skilled SQL SERVER DBA professional with 10 + years of experience delivering high - quality services, Well-experienced in industry leading Microsoft SQL SERVER Database Administration.
  • Accomplished projects as per user requirements (SLA) and highly effective team-oriented with ability to collaborate with cross-functional personnel at all levels.
  • Database Administration includes but not limited to Installation, Configuration, Upgradation, performance Tuning, Troubleshooting issues, Backup/Recovery, DR Failovers, Running DBCC and other maintenance tasks.
  • Experienced with High Availability and Disaster Recovery Technologies (SQLALWAYSON AG, Clustering, Mirroring and Log Shipping and various model of replication Technologies).
  • Strong relational database concepts. Strong experience in the management and administration of SQL SERVER Instances and databases in Microsoft Azure.
  • Strong experience with Microsoft Azure including migrating of on premise SQL Server Databases to the Cloud.
  • Performing Capacity Planning
  • Installing, Configuring & Upgrading Database Server  
  • Managing Data Integrity
  • Managing Security
  • Implementing & Managing Database High Availability
  • Implementing Effective Backup Strategies For Disaster Recovery
  • Database Performance Tuning & Query Optimization  
  • Team Building
  • Project Coordination
  • End User Training
  • Process Improvements
  • Communication
  • Systems Analysis
  • Troubleshooting & Problem Solving
  • Documentation

TECHNICAL SKILLS:

RDBMS: Microsoft SQL Server 2000/2005/2008/2012/2014/2016 , MS Access, Integration Server, Analysis Server, Reporting Server

SQL Server Technologies & Tools: Enterprise Manager, Management Studio, SQL Profiler, DTS (ETL), Database Tuning Advisor (DTA), IDERA, Red Gate,

Scripting Language: DOS & T-SQL

Case Tools: MS Office, MS Access, MS Excel, MS Outlook, MS Visio, MS Project.

ETL Tool: SSIS, SSRS, SSAS, Erwin,

Platforms: Windows

PROFESSIONAL EXPERIENCE:

Confidential, Ashburn, VA

Sr. SQL DBA

Responsibilities:

  • Responsible in designing, building and administering SQL Server clustered environments (2012/ 2014/2016 ).
  • Developed strategies, roadmaps and designs for large-scale organizations. Enabling the enterprise the ability for rapid growth and scalable solutions that do not require extensive manual intervention.
  • Migrated, monitored, optimized databases from on premise to cloud using Microsoft Azure SQL databases (Dbaas).
  • Responsible in designing enterprise SQL Server database environments by implementing SQL Server best practices with a focus on database optimization, functionality, and scalability.
  • Responsible to manage and maintain SQL Server database firm that contains thousands of instances including SQLALWAYSON AG, clustered environment, standalone environment, and various high availability configuration in Production, DEV, and UAT environment.
  • Worked with partners and team members within Technology to provide professional consultation services on technology best practices, standards and policies/guidelines.
  • Coordinated and lead teams to deliver solutions in assigned functional area, meet SLA’s, Interface with IT, finance, audit, business unit management and other areas.
  • Created and assigned appropriate database roles and privileges to users depending on the user activity.
  • Created SQL objects like Tables, Stored Procedures, Views, Indexes, defaults, user defined data types and functions.
  • Performed database maintenance, database monitoring and space management to utilize resources efficiently and to improve database performance.
  • Responsible in performing object migration between all production database Servers.
  • Performed SQL Server configuration for the business functions including Index & data management to determine defragmentation level whether to update statistics or rebuild and reorganize indexes.
  • Worked in a SQL server operating in a very large database environment and also resolving issues related to database and tables.
  • Performed database backup (full backup, differential and transactional backup) to recover database at the time of disaster.
  • Created log shipping, replication and database mirror for high availability of the database in case of database failure.
  • Established connectivity to databases and monitored system performance.
  • Involved in configuring, patching, testing, monitoring, and supporting multiple heterogeneous database instances, maintaining the databases at current release and maintenance levels.
  • Configured and setup snapshot replication from production to Development environments.
  • Created and scheduled SSIS package as per Client requirement.
  • Checked Disk space alerts on Production server and to inform Infrastructure to add more space if the disk was full.
  • Worked as part of a team and provide 7×24 supports when required.

Confidential, Rockville, MD

SQL Server DBA

Responsibilities:

  • Installing, Configuring, Upgraded & migrating SQL Server /Applied Service Packs
  • Migrating from versions to SQL SERVER 2012
  • Experience with Microsoft Azure including migrating of on premise SQL Server Database to the Cloud
  • Supporting both production environment and non-production environment
  • Set up security and access profiles and procedures for database system administrators.
  • Responsible in designing, testing and implementing an enterprise Disaster Recovery Plan.
  • Responsible in establishing and maintaining sound backup and recovery policies and procedures
  • Designed and handled of Disaster recovery and high availability solutions (Failover Clustering, Alwayson, DB Mirroring, Logshipping and Replication)
  • Responsible for capacity planning
  • Performed troubleshooting and advised best practices to SQL development teams
  • Taking care of SQL Server Performance  issues and errors using native tools like Profiler, Perfmon, system stored procedures, dynamic management views, custom stored procedures and third party tools
  • Performed both MS SQL and operating system performance tuning and monitoring
  • Involved in project implementations for installations/upgrades, client builds/decommissions, data center moves and routine maintenance of MSSQL DBA responsibilities
  • Automated & monitored application related jobs and data replication activities
  • Worked as per the company’s Incident Management, Problem Management and Change Management
  • Worked in close coordination with different Teams (like Network Team and other application Teams) as well with Stake holders and customers.
  • Prepared project plans, provides technical expertise regarding architecture, development tools, and work effort estimates.
  • Researches, investigates and give recommendation of best practices for information and application services, and contribute to work plans.
  • Wrote documentation for a database including data standards, procedures and metadata.

Confidential, Owings Mills, MD

SQL Server Server DBA

Responsibilities:

  • Installed and configured MS SQL Server 2005 and 2008 and 2012 versions
  • Experienced in SQL Server Migrations of various versions (2005, 2008, 2012)
  • Experienced on both production environment and non-production environment support
  • Mentored the team members on routine administration tasks such as backups, recovery, monitoring, and performance tuning and database growth analysis.
  • Configured and monitored the High availability solutions (SQL server Clustering, SQL server AlwaysOn, SQL server Database Mirroring, SQL server Log-Shipping and SQL server Replication Technologies)
  • Analyzed and defined capacity planning for maintenance of the different Database Backups and Restore scenarios
  • Provided appropriate access to client so that they will have access to their respective needed server and database objects.
  • Ensuring audit compliance for user security, data modification permissions.
  • Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
  • Set up security and access profiles and procedures for database system administrators.
  • Experienced to work in coordination with different Teams (like Network Team and other application Teams) as well with Stake holders and customers.
  • Experienced in monitoring and troubleshooting performance issues and optimized TSQL queries, stored procedures, functions etc.
  • Experienced on Incident Management, Problem Management and Change Management
  • Supported the research, investigations and recommendation of best practices for information and application services, and contribute to work plans.
  • Wrote documentation for a database including data standards, procedures and metadata.

Confidential

SQL Server DBA

Responsibilities:

  • Monitored all instances of the server and databases are up and running.
  • Monitored the performance and manage the parameters to give fast responses to users.
  • Refined the physical design to meet the requirements of system storage.
  • Wrote documentation for a database including data standards, procedures and metadata.
  • Controlled privilege and permission for access.
  • Discussed and worked with the technical staff to make sure the integrity and security of the database.
  • Supported development and deployment of software applications
  • Designed database systems and data structures in collaboration with software development teams for existing and new applications.
  • Designed and implemented Operational automation tasks using SQL Server Job using T-SQL scripting
  • Backup and restore the database using T-SQL scripting
  • Participated in writing the functional requirements with the team. 
  • Monitored SQL job failures debug and resolve.
  • Worked with programmers’ team to create development and support strategies for database systems.
  • Responsible for the implementation and maintenance of database backup and recovery processes.

Confidential

Business Analyst

Responsibilities:

  • Develop business architecture using requirements such as scope, processes, alternatives, and risks.
  • Analyze client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis.
  • Conduct testing including functional, regression, user acceptance, integration and performance to verify the client’s needs are met.
  • Communicate client’s business requirements by constructing easy-to-understand data and process models.
  • Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
  • Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.
  • Engage client to gather software requirements/business rules, and ensure alignment with development teams
  • Translate stakeholder requirements tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.
  • Identify and reconcile errors in client data to ensure accurate business requirements.
  • Draft and maintain business requirements and align them with functional and technical requirements.
  • Facilitate monthly meetings with clients to document requirements and explore potential solutions.

We'd love your feedback!