Experience

Idea Entity

• United States
• Software Development
• 100 - 200 Employee

• Sr MS SQL Server Database Admin

  • Jun 2023 - Present

  ● Manage all aspects of the RDBMS platform including SQL Server configuration parameters, Server Backups, DB Backup Plans, Transaction Log dump plans, Server Performance optimization, ● Conduct weekly database maintenance and optimize for high availability. Performance tuning, Index Management & Optimization, record lock/deadlock optimization & management. ● Use high-speed transaction recovery techniques and handle common database procedures such as upgrades, backups, recoveries, migrations, etc. ● Use of Microsoft SQL Management Studio, including SQL Profiler and Database Engine Tuning Advisor ● Experience with managing SQL Clusters and managing manual and automated fail-over is a must. ● Apply new SQL updates, patches and versions when required. ● Develop database solutions by designing proposed systems, defining database physical architecture, functional capabilities, security, back-up, and recovery specifications. ● Design, implement, and maintain databases in accordance with needs and views, create data models, indexes, and views. ● Prepare documentation and specifications such as data dictionaries, ERD diagrams, database schemas, developing flowcharts, and other pertinent documentation. ● Write TSQL code, and optimize store procedures and code in-application SQL statements and SQL procedures to extract data for processing and provide fast query responses. ● Work with different teams on application project development to meet business requirements and timelines. ● Determine, enforce, and document database policies, procedures, and standards. Show less



PKC Group

• Finland
• Motor Vehicle Manufacturing
• 700 & Above Employee

• MS SQL Server DBA/System Administrator

  • Jun 2020 - May 2023

  Upgraded SQL Server from 2008 R2 to 2016 using both in place and side-by-side upgrade. • Migrated database using backup and restore, detached and attached, log shipping and database mirroring. • Maintained and achieved high availability of database via coordinating with infrastructure teams to allocate system resources to database Server. • Troubleshoot and resolved SQL Server performance issues using both SQL Server inbuilt and 3rd party tools. • Change data capture (CDC) capture, insert, update and delete activities in rational formats for MS database server • Automate SQL Server administrative tasks using maintenance plans and Store Procedures • Assess Databases for cloud Migration using the DMA tool, correct Migration blockers. • Ability to work with multiple VMs and monitor replication for high availability and disaster recovery scenarios. • Ability to automate and configure management of database task. • Work with development and operations to tune production queries for optimal performance • Experience with ETL frameworks, Writing Queries using SSRS for reporting services • Experience with programing languages like Python, Tableau and PowerShell Show less



Code TECHNIQ

• Japan
• E-Learning Providers
• 1 - 100 Employee

• Sql Server Database Administrator

  • Dec 2018 - May 2020

  • Upgraded windows servers from Windows 2008 R2, 2012 R2, 2016 to 2019. • Worked together with software vendors to make compatibility checks before upgrade of Windows servers. • Acted as a subject matter expert while facilitating programmers and engineers to efficiently use database systems. • Created and integrated DB backup/restore and disaster recovery strategies on company’s SLA leveraging proven methodologies. • Utilized PowerShell scripting and removed local admin rights from all users and performed several monitoring tasks via PowerShell, with the help of developers. • Mitigated downtime, fixed overall database access and performance issue, and uncovered anomalies while patching and upgrading database Servers and Windows Server. • Generated prompt response to tickets, resolved user request based-off priority, and ensured database configuration maintenance in the configuration repository. • Ability to manage multiple VMs, Data centers, Host computers using Windows EXSI • Used SSRS to prepare and deliver a variety of interactive and printed reports, SSAS was used as an analytical processing, data mining, and reporting tool to make data work for end-users, SSIS was used in copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data. Show less



MTN

• South Africa
• Telecommunications
• 700 & Above Employee

• MS SQL Server DBA/Administrative Assistant Intern

  • Jul 2016 - Sep 2018

  Key responsibilities Installation of SQL Server/ SQL management Studio • Database creations using GUI or Script, table management, index creation, creating users and logins and certificate creations. • Implemented change management process and resolved tickets with absolute precision in a timely manner. • Coordinated with customer and 3rd party vendors to manage and support the database system and operations. • Devised effective solutions for slow running queries, deadlock, and blocking issues to optimize overall productivity. • Developed testing, backup, and recovery plans employing both SQL Server level backups and Veeam backups. • Leveraged expertise regarding extended events and SQL profiler while supervising SQL server performance. • Accomplished on time upgrades and migrations from SQL server 2000 to 2008/R2 Show less