Anubhab Dash

SENIOR MSSQL DATABASE ADMINISTATOR

E-mail: admc3o@r.postjobfree.com

Contact: Primary :943-***-****

Secondary:897*******

Objective:

With 6 years of total experience I am seeking a position in your company to utilize my skills and abilities that can offer professional growth while being resourceful, innovative and flexible I feel your company will help me to convert my innovative ideas into master products.

Career Profile:

Working with DXC Technology as Professional 2 Database Administrator from Jan 2021 to till date.

Worked with ZeOmega Infotech Pvt limited as Senior Database Administrator (DBA-L2) from Apr 2017 to 2021 Jan.

Worked with Mercedes-Benz Research and development from March 2015 to March 2017 as Database Administrator (DBA-L1).

Profile Summary:

I Have Predominant skills working on Managing SQL Server Production Database of organization and deployment of App Server for Web Application.

Having 6 Years of experience in operational team with managing Change Advisory Board (tickets), incidents, providing RCA and Ability to understand existing project/Production Environment, UAT sign off and Identify the process and technology gaps

Expertise skills on carrying out DB Maintenance tasks within stipulated Downtime window without breaching SLA’s.

Manage and support 24x7 production databases as well as development databases to ensure maximum availability of database resource for various applications with Weekly on call rotation as part of a Global DBA team

Provide DBA support for development team operations and project activities

SQL Server skills include:

Installation & Configuration of MS SQL Server 2016, 20014, 2012 and 2008R2.

Hands on Always ON Clustering Setup and debugging issues.

SQL Server Log Shipping, T-Replication, Always ON.

Database Migration with Data Security, Backup & Recovery.

SQL Server patching and maintenance in production environments.

Experience in Performance tuning activities like verifying the slow running queries.

Knowledge in fragmentation and re-indexing the fragmented indexes.

Knowledge in Azure (IAAS, PAAS & SAAS)

Knowledge in DTU and Vcore.

Worked on Microsoft Data Migration Assistant tool for migration.

Fundamentals of Networking / Windows Operating System /Change Management System:

TCP IP protocols, Client server Data Transmission process.

Architecture design with Windows servers and Linux servers.

Weekly meetings for approvals of RFC for any Changes, Upgradations, Releases and Go Live tasks

Possess sound exposure in Administration:

Installation of Windows Cluster, SQL Server Cluster configuration and setup of Always on High Availability and upgrading of Microsoft SQL Server software and related products.

Good knowledge in preparing Disaster Recovery documentation, planning and testing.

Expertise skills on SSIS, SSRS and House Keeping by archival of Huge data and Shrink methodology.

Working on SSAS DataMart Installation and configuration to generate complete Reports.

Experience in extracting, transforming and loading of data from excel, flat files, Oracle to MS SQL server by using DTS import/export utility, and using a component Attunity for Smooth data transfer SQL server integration services.

Monitoring ETL join failure communication and interface load on database

Experience in troubleshooting and resolving Always On issues, database integrity issues, performance issues, blocking and deadlocking issues.

Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.

Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Database mirroring, Replication.

Monitoring Storage - Validate that have enough storage on the drives to support databases clean-up of growing tables within Db and Planning RFC accordingly.

Setup of Reports and Reports Framework with SSO authentication to SQL reporting Services.

Knowledge of Jenkins setup, Automation of Jobs, SSIS package execution and Network support.

Development – ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes).

SQL Database Operational support to tech users and Develop advanced queries by using T- SQL.

IIS/ ETL / Tomcat Application with Deployment exposure

Planning for Releases and Upgrade of Application with DB enhancement periodically.

Strong Understanding on Full Build Deployment and Db Script Execution within stipulated Downtime window.

Worked on PowerShell script to automate execute the SQL scripts.

Knowledge on Worker process, Application pool with Reading and Configuration of Web config file and troubleshooting application end issue.

Creation and maintenance of connectivity between Website and database through database connection String and binding to database users.

Understanding of Interface connectivity between severs for reports and data transfer through interface services.

Good Knowledge of Networking concepts like telnet, ping and Active Directory with DNS creation.

Automation Tool:

Hands on Jenkins for Automation of scripting and T-SQL Queries for automated Deployments.

Hands on Experience on SQL Agent and SSIS packages for automating jobs and maintenance.

Migration of 5 TB data from Oracle to SQL server though SSIS packages.

Trainings:

Health care corporate training with Corporate standards of HIPPA certified.

Trained in SQL Database.

SQL Performance Tuning.

Ticketing Tool KARMIC, Jira and CISM.

Azure DBA and Migration Process

Project: DXC Technology

DXC Technology runs mission-critical systems with the latest technology innovations to deliver better business outcomes and new levels of performance, competitiveness and experiences for our customers. The Enterprise Technology Stack includes modern workplace, IT outsourcing, cloud and security, applications, and analytics and engineering. The criticality of the IT estate is top of mind for customers across all industries. They need to manage previous investments in enterprise infrastructure and also move some of their IT estate to the cloud. Our focus is on IT modernization including on-premises and cloud, data-driven operations and workplace modernization. DXC is in a perfect position to help customers manage their IT estate with the scope and scale of services in the Enterprise Technology Stack. The company’s global scale, talent and innovation platforms serve 6,000 private and public-sector customers in 70 countries.

DXC is a recognized leader in corporate responsibility and ranked among the world’s best corporate citizens. DXC is a Fortune 500 company and represented in the S&P 500 Index.

Roles & Responsibilities:

Monitoring the database Always On setup.

Working on Azure Cloud.

Checking for Daily Healthy Checkup of Server and Keeping all databases online.

Troubleshooting for Deadlock issues and keeping an eye on Lock types occurring in database.

Managing all the servers/environment of Production.

Installation and patching the SQL Server 2016 and 2019.

Reporting server installation and configuring for all clients.

Project: ZeoMega Infotech Private Limited

HealthCare Domain:

Population Healthcare management systems

Project : As an Product Based organization I majorly take care of Healthcare Procut in and Out of Production setup starting from Lower environment to clients Go Live activities for Database into Production and continues to deliver, the industry’s leading population health management platform, Jiva, including utilization management, case management, and disease management. Our end-to-end, interoperability-enabled platform is rapidly deployable, highly scalable, and facilitates collaboration among healthcare stakeholders.

Roles & Responsibilities:

Checking for Daily Healthy Checkup of Server and Keeping all databases online.

Working on Performance Improvement of Server and Checking Fragmentation of pages.

Monitoring the database Always On setup.

Troubleshooting for Deadlock issues and keeping an eye on Lock types occurring in database.

Managing all the environment from Local to Production.

Installation and patching the SQL Server 2014 and 2016.

Deployment of Database artifact on the environments using Puppet-3 and Puppet-6.

Reporting server installation and configuring for all clients.

Having experience on Jenkins automation and deployment automation.

Project: Mercedes-Benz Research and development

ABOUT DAIMLER:

The Daimler Group is one of the biggest producers of premium cars and the world’s biggest manufacturer of commercial vehicles with a global reach. They provide financing, leasing, fleet management, insurance and innovative mobility services. Based in Germany, Daimler AG along with its business units Mercedes-Benz Cars, Daimler Trucks, Daimler Financial Services, Mercedes-Benz Vans and Daimler Buses, is a global leading producer of premium passenger cars and the largest manufacturer of heavy and medium-duty trucks in the world.

ABOUT MBRDI:

Mercedes-Benz R&D India (MBRDI), headquartered in Bengaluru was founded in 1996 as a captive unit to support Daimler’s research, IT and product development activities. Today, MBRDI has become a key entity for all future mobility solutions through C.A.S.E for building autonomous and electric vehicles. Our competencies in engineering and IT have progressed to using AI, AR, Big Data analytics and other modern technologies to provide seamless connectivity. It is one of the largest global R&D centers outside Germany, employing close to 5000 skilled engineers; and has established itself as a valuable center to all business units and brands of Daimler worldwide.

Deployment of Database artifact on the environments using Puppet-3.

Experience in Installing and Configuring the Oracle.

Managed Backup plans and disk space issues

Keeping track of all the database and instance name and managing on Excel sheet

Giving Roles and permission to Logins and Users

Worked on WebEx for the dissuasion with Clients and fixing the issues.

Changing the recovery models whenever necessary like Simple recovery model for shrink the database.

Worked on Installation and configuration Transactional Replication.

Installation of SQL and Oracle server and creation of the Database.

Academics Profile and Qualification:

Bachelor of Engineering from Shibani Institute of Technology affiliated to BPUT Odisha, India in the year 2013

Pre-University Education from Baripada College, Odisha.

High School from Rairangpur Govt High School, Odisha.

Skills:

Enthusiastic to learn new technology, Flexible to work in every possible aspect

Excellent Written and verbal communication skills.

Good problem-solving techniques, Quick Learner & hard worker.

Good team player, Effective Communicator

Declaration:

I hereby declare that the above-mentioned details are true to the best of my knowledge.

Place: Bangalore Anubhab Dash

Contact this candidate