We provide IT Staff Augmentation Services!

Sr Sql Server Dba Resume

SUMMARY:

  • I have 10 years of extensive experience in Database Administration, Database designing in Client/Server/Web environment and Development.
  • Highly technical SQL Server DBA with Strong Management Skillsgood hands on experience with NT Systems, application development.
  • Extensive experience in problem resolution, 24x7 production Supportsystems analysis, Backup and Recovery, design, testing and implementation of application software in various platforms.
  • Support SSRS security and Administration in production and development.
  • Currently upgrading to SQL Server 2017 and the database size varies from 2mb to 3tb.
  • We have over 200 databases and the total size of the databases is around 200tb.
  • We have BI tools (SSIS and SSRS) which I’m in charge on the backend.
  • Experience in Sybase 10/12 and 15 installing application on Windows server and development.
  • Installed, configured and tested vendor software on both the backend and front end for the company for selecting vendors to company.

EXPERIENCE:

Confidential

Sr SQL Server DBA

Responsibilities:

  • Install, upgrade, configure and administer SQL Server in clustered and standalone environments.
  • Provide Production Database Support.
  • Provide support for BI tools (SSIS / SSRS).
  • Provide client/server and web application development using MS SQL Server and Windows.
  • SQL performance tuning utilizing industry standard tools and tracing software.
  • Create procedures, database triggers and table creation scripts.
  • Database optimization and replication strategies
  • Create scripts for database administration, maintenance and performance improvements.
  • Provide Sybase adaptive server front end support for analysts and client service users.
  • Maintain the front end reporting tools which are custom built.
  • Installation and maintenance of custom built and user requested applications and maintenance of applications.
  • Troubleshooting application issues and application connectivity issues to SQL or Sybase.
  • Create and maintain SQL backups and restores.
  • Replication.
  • Implement Disaster recovery for SQL databases.
  • Upgrade SQL servers and databases. Assess and develop long - term strategic goals for production databases in conjunction with data owners and department managers.
  • Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.
  • Create models for new database development and/or changes to existing ones.
  • Install and configure relevant network components to ensure database access as well as database consistency and integrity.
  • Respond to and resolve database access and performance issues.
  • Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
  • Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
  • Monitor, optimize and allocate physical data storage for database systems.
  • Plan and coordinate data migrations between systems.
  • Develop, implement, and maintain change control and testing processes for modifications to databases.
  • Interact with analysts and technical support.
  • Understand networking concepts, security, administration and hardware configuration.
  • Migrate data across different databases and platforms.
  • Creating Logins, users and granting permissions.
  • Develop routines for end-users to facilitate best practices database use.
  • Establish appropriate end-user database access control levels.
  • Basic understanding of .Net Web Development.
  • Create SSIS packages to support the website and custom applications.
  • Manage and/or provide guidance to junior members of the team.
  • Currently Installing, upgrading and migrating to windows 2012r2 and SQL server 2017.
  • Installed, configured and tested vendor software on both the backend and front end for the company for selecting vendors to company.
  • Testing the connections performance and reliability of vendor software.

Hire Now