We provide IT Staff Augmentation Services!

Sr. Sql Dba Resume

MarylanD

SUMMARY

  • I am a tenured IT professional with over fifteen years of MS SQL Server Database Administration experience.
  • I am a highly driven individual who is passionate about SQL Server and all its latest versions and upgrades.
  • Currently I am working at Confidential with SQL Server version 2016 and doing migration research for SQL Server 2017.
  • I have been working with Amazon Web Services and Microsoft Azure for the last 5 years.
  • I have managed teams of SQL DBA’s.

CORE COMPETENCIES

  • Managing SQL SEVER Instances
  • Databases High Availability
  • Disaster Recovery
  • Integrity & Security
  • Project Coordination
  • End User Training
  • Process Improvements
  • Communication
  • Troubleshooting & Problem Solving
  • Documentation

PROFESSIONAL EXPERIENCE

Confidential, Maryland

Sr. SQL DBA

Responsibilities:

  • Installing, Configuring, Upgraded & migrating SQL Server /Applied Service Packs
  • Migrated Databases from Relational Database to Relational Database example, Oracle to SQL server
  • Migrated Databases from Relational Database to Non - Relational Database NOSQL including SQL Server to MongoDB, SQL Server to CouchDB, SQL Server to Cassandra
  • Supporting both production environment and non-production environment
  • Set up security and access profiles and procedures for database system administrators.
  • Designing and handling of Disaster recovery and high availability solutions (Failover Clustering, Alwayson, DB Mirroring, Logshipping and Replication)
  • Provide deep technical expertise to support delivery and maintenance of IT solutions.
  • Provide IT teamsand business personnel with technology solutions by weighing advantages of technology standards,market availability of products, and risks and benefits of technology to meet business/IT needs.
  • Involve in customer engagement, work planning, project management services provided to ITcustomers.

Confidential, Austin, Texas

Sr. SQL DBA

Responsibilities:

  • Installing, Configuring, Upgraded & migrating SQL Server /Applied Service Packs
  • Migrated Databases from Relational Database to Relational Database example, Oracle to SQL server
  • Migrated Databases from Relational Database to Non-Relational Database NOSQL including SQL Server to MongoDB, SQL Server to CouchDB, SQL Server to Cassandra
  • Supporting both production environment and non-production environment
  • Set up security and access profiles and procedures for database system administrators.
  • Designing and handling of Disaster recovery and high availability solutions (Failover Clustering, Alwayson, DB Mirroring, Logshipping and Replication)
  • Performing both MS SQL and operating system performance tuning and monitoring
  • Works as per the company’s Incident Management, Problem Management and Change Management
  • Works in close coordination with different Teams (like Network Team and other application Teams) as well with Stake holders and customers.
  • Prepares 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.
  • Writes documentation for a database including data standards, procedures and metadata.

Confidential, Houston, Texas

Sr. SQL Server DBA

Responsibilities:

  • Installed and configured MS SQL Server 2005 and 2008, 2012 and 2014 versions
  • Experienced in SQL Server Migrations of various versions (2005, 2008, 2012, 2014)
  • Supported both production and non-production environment
  • Configured and monitored the High availability solutions (SQL server Clustering,SQL server AlwaysOn, SQL server Database Mirroring,SQL server Log-Shipping andSQL server Replication Technologies)
  • Analyzed and defined capacity planning for maintenance of the different Database Backups and Restore scenarios
  • Set up security and access profiles and procedures for SQL Server Instances & databases
  • Worked in coordination with different Teams (like Network Team and other application Teams) as well with Stake holders and customers.
  • 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, Houston, Texas

Sr. SQL Server DBA

Responsibilities:

  • Upgraded/migration Database from SQL Server from lower to higher versions.
  • Migrated Databases from Relational Database to Relational Database example, Oracle to SQL server
  • Migrated Databases from Relational Database to Non-Relational Database NOSQL including SQL Server to MongoDB
  • Implemented techniques and performed special tasks within the context of database performance and tuning. Created, upgraded, maintained, while working closely and coordinating with hardware, network, and OS administrators.
  • Installed & configured database software, associated database tools and performance monitoring software.
  • Experienced on both production environment and non-production environment support
  • Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
  • Performed acceptance testing to verify that database changes perform without adverse consequences.
  • Estimated disk storage requirements for database software, database files & database administration needs.
  • Participated in meetings impacting databases physical design.
  • Automated the SQL Server Job
  • Developed, tested & implemented a robust database backup and recovery strategy
  • Provided appropriate access to client so that they will have access to their respective needed server and database objects.
  • Developed & maintained T-SQL scripts, utility jobs or implement needed software for database maintenance.
  • Implemented & managed database Mirroring, clustering, failover and load balance technologies as per the company’s requirement.
  • Conducted root cause and analysis for database issues, errors, incidents and problems.
  • Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
  • Researched, reviewed and recommended for preventive maintenance.
  • Set up security and access profiles and procedures for database system administrators.
  • Ensured the Availability of the Database Server in a 24X7 Environment.
  • Managed security by defining roles and rights.
  • Handled fine tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.
  • Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures etc.
  • Identified and evaluated industry trends in database systems to serve as a source of information and advice for upper management.
  • Created the SQL Server Integration Services (SSIS) and DTS Packages for data import and export.
  • Participated in the preparation of project plans, providing technical expertise regarding architecture, development tools, and work effort estimates.
  • 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, Addis Ababa, Ethiopia

Sr. SQL Server DBA

Responsibilities:

  • Installed, configured, monitored, upgraded, patched and tuned SQL Server 2000, 2005 and 2008 servers.
  • Worked on troubleshooting the database issues and code issues.
  • Created, upgraded, maintained, and supported Sybase ASE databases
  • Experienced on both production environment and non-production environment support
  • Performed Performance Tuning of the database, Stored Procedures and SQL queries.
  • Designed and implemented Logical and physical database design upon requirement, also the patching the critical servers\instances.
  • Involved in designing, configuring, monitoring and troubleshooting replication methodologies, log shipping and mirroring on critical databases and quickly resolving issues.
  • Involved in Day-to-day activities such as Agent Jobs, Backups and Recovery, Services, Index, Database growth, health and consistency check, Data maintenance (partitioning, archiving and purging), issue\ problem maintenance and management, Incident management, Security maintenance etc.
  • Monitor and tune all aspects of SQL Server infrastructure like Disk, CPU, Memory, SQL Code etc., by using Perfmon, Profiler, Dynamic management views
  • Involved and implemented the Disaster recovery process to the critical databases and Instances as per MSFT standards.
  • Configured SQL Server clustering and application services clustering.
  • Managed internal and external MS SQL database security.
  • Designed and implemented Operational automation tasks using SQL Server Job using DOS/PowerShell/T-SQL scripting
  • Backup and restore the database using DOS/PowerShell/T-SQL scripting
  • Developed & maintained using DOS/PowerShell/T-SQL scripts, utility jobs or implement needed software for database maintenance.
  • Involved and worked with the Change management, Release management for the smooth releases and of application\server\db installation or db patch\upgrade.
  • Manage SQL Server security, application users, assist developers and users for access issues.
  • Worked as team player in resolving issues, documentation etc.

Confidential, Addis Ababa, Ethiopia

Database Administrator

Responsibilities:

  • Monitored all instances of the server 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 DOS/PowerShell/T-SQL scripting
  • Backup and restore the database using DOS/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.

Hire Now