We provide IT Staff Augmentation Services!

Sql Dba Resume

3.00/5 (Submit Your Rating)

SUMMARY

  • SQL Server DBA with experience in project management, people management, solution development, system integration roles in a career spanning 15 years, giving a well - rounded experience on various customer scenarios.
  • Experience in SQL database administration on production, staging & development servers with server configuration, performance tuning, and maintenance with excellent troubleshooting capabilities.
  • Experience in Disaster Recovery Planning, SQL Server Replication, Backup/Recovery and Security Management operations.Having hands on experience in DR processes including Log Shipping and Database Mirroring.
  • Experience in data transformation services like SSIS, DTS, BCP and Bulk Insert.
  • Experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities.
  • SQL Server Setup, Installation & Version Upgrade.
  • Plan, Design and Scheduled Database Maintenance & Administrative Tasks.
  • Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
  • Create, manage SQL Server AZURE Databases. Setting up SQL Azure Firewall. Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers.
  • Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
  • A multidimensional profile with Six Sigma Green Belt, capable and experienced in handling Database Administration, project, people and solutions management.

TECHNICAL SKILLS

  • Storage
  • ISS
  • ERP
  • Web Dev
  • ERWIN
  • MS Project, MS Office
  • Client server, web-based
  • Dot Net, ASP, XML
  • PeopleSoft
  • Windows
  • SQL Server
  • Oracle

PROFESSIONAL EXPERIENCE

Confidential

SQL DBA

Responsibilities:

  • Migrating database to RDS instance.
  • Setting up Connection Strings and connecting to SQL Server RDS instances from locally Installed SQL Server Management Studio (SSMS) for Developers.
  • Querying servers for getting details of users/logins.
  • Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
  • Performed Production support and on Call duties.

Confidential

SQL DBA

Responsibilities:

  • Configure trace to identify users/logins accessing orphan/unmapped servers.
  • Responsible for all SQL Server General Administration and Performance.
  • Setup backup and restoration jobs for development and QA environments.
  • Performed installation of SQL Server & Service Packs.
  • Suggested Disk Capacity, Processors and Memory based on the Capacity planning.

Confidential

SQL DBA

Responsibilities:

  • Ensure all the SQL SERVER features worked as expected after consolidation or fail over.
  • Help the developers & testers understand & debug issues related to SQL Server.
  • Security and architectural planning issues met as well as testing and training.
  • Failover cluster testing and resolution on HP servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
  • Performed installation of SQL Server &Service Packs.
  • Instrumental in transition & steady state of various responsibilities.
  • Used DBCC checks to ensure the physical consistency of the database and objects post failover & consolidation.
  • Providing support to the Application developers on the application databases.
  • Performed Production support and on Call duties.

Confidential

SQL DBA

Responsibilities:

  • Responsible for General Database Administration and Performance.
  • Upgrading PRISM database to SQL 2008.
  • Rebuilding / Monitoring the indexes at regular intervals for better performance.
  • Implementing point in time recovery solution.
  • Monitoring of database size and disk space in Production, Staging & Development environments.
  • Performed installation of SQL Server & Service Packs.
  • Setup backup and restoration jobs for development and QA environments.
  • Used DBCC checks to ensure the physical consistency of the database and objects post failover & consolidation.

We'd love your feedback!