Sql Server Active Directory

MD HUDA

Mobile: 347-***-**** Email: *******@*****.***

OBJECTIVE

Certified SQL Server DBA having more than Fifteen (6) years of SQL DBA experience and over Eighteen (18) years of IT experience. Process detail oriented, analytical, and troubleshooting experience in various Microsoft products e.g. SQL Server (2000, 2005, 2008, 2008R2, 2012,2014,2016,2017 and 2019). Administrating databases, performing upgrades, and migrating databases. Design and develop data models from requirement gathering and data analyzing business requirements. Solid working experience in managing large databases in 24/7 environments including backup/recovery, performance tuning, troubleshooting experience using different Microsoft tools. Depth knowledge and experience in Stored Procedures, Triggers, Functions, Constraints and Views and Strong business and technical vision with effective people skills, ability to manage multiple complex projects.

EXPERTISE:

• Strong experience on Windows Operating Systems (2022/2019/2016/2012/2008).

• Managed MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 4 Nodes.

• Experience working with production support and 24/7 on call environments.

• Working experience on AD (Active Directory), File Permissions, File Share Administration, Users Administration. Installed, configured and Administered Active Directory.

• Strong Knowledge on the phases of Software Development Life Cycle (SDLC) including requirements gathering, testing, defect tracking, management, and reports.

• Deployed Databases in Test Develop and to Production environments, all SDLC process maintain Agile Scrum, waterfall.

• Experienced in working as a client-server, web-based and stand-alone architecture.

• Strong Database Administration skills related to applications running on Multiple Clustering in Physical, Virtual and Cloud environments.

• Strong work experience and knowledge with SQL Server Database High availability using Replication, Database Mirroring, Log shipping, clustering and always on.

• Excellent knowledge and hands on experience in Migrations from on-premises to Azure IAAS and PAAS servers

• Database Monitoring, Performance Tuning using DMV, Query Optimization, Backup/Recovery, Security Management.

• Database Monitoring: Proficient in use Index Fragmentation, Disk I/O, Identified resource intensive Queries.

• Upgraded databases from SQL Server 2000 to SQL Server 2005/2008 and SQL Server 2005 to SQL Server 2008/2008R2 and SQL Server 2008, 2008R2 to SQL server 2012/2014/2016/2017/2019.

• Expertise in troubleshooting Production Database issues and performance issues.

• Have extensive experience with Backup tool like LightSpeed&AVAMAR and SQL Native.

• Hands on Experience on SQL Server Service pack upgrades.

• Knowledge of ITIL Process involved in Incident, Problem and Change Management.

• Coordinated with onsite teams and worked closely with offshore team. TECHNICAL SKILLS

Database: SQL Server 2019/2017

Operating System: Windows Server 2019/2016/2012R2/2008R2/2003R2 and Linux Languages: SQL, T-SQL, Quest Lite Speed, PowerShell Integration

Services

SSIS (SQL server Integration services)

PROFESSIONAL EXPERIENCE

FEDERAL DEPOSIT INSURANCE CORPORATION August 2023 - Current Database Administrator

Responsibilities:

• Installed and configured SQL Server using ConfigurationFile.ini with CMD on Non-Prod & Production Environments (SQL server 2012/2014/2016/2017/2019).

• Experience in developing, monitoring, extracting, and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.

• Excellent in High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge, and union all.

• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)

• Worked on Production servers and managed large verity of databases with 24/7 on call support.

• Daily activities included resolving incident tickets, determining the root cause of problems, and identifying the solutions, checking alerts, monitoring databases, checking error logs, checking the log file size, and freeing up disk space shrink log files.

• Creating logins and assigning proper permissions to the created logins, mapping logins to the database and granting appropriate permissions, Transfer Login, Fix Orphan Users and Perform Security Audits.

• Help developers improve the performance of that query by tweaking it or modifying indexes and changing some configuration.

• Experience in monitoring and tuning SQL Server database performance using SQL Profiler, Extended events, DMVs, and Windows Performance Monitor.

• Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server 2012 to SQL SERVER 2017/2019.

• Excellent knowledge and hands on experience in Migrations from on-premises to Azure IAAS and PAAS servers.

• Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud

• Import and Export data within Azure Cloud environment.

• Worked with developer teams to release the application deployment in DEV and Production environment.

• Upgraded an On-Premises database from SQL Server 2012/2014 to "Azure SQL DB" and "Azure SQL DB Managed Instance".

• Experience and managing very large Database Backup, Recovery and Disaster Recovery Procedures.

• Setup Jobs, Maintenance plans for backups, rebuilding indexes, check server health, alert, notifications.

• Configured SSL Certificate on SQL server standalone and AG.

• Coordinating Implementation of Performance and tuning actions with application teams.

• Managing Scheduled tasks for the servers and automated all maintenance activities.

• Accepting user requests and solving by working around within the Service Level agreement.

• Adding necessary space to the data files and log files on database space alert incidents by generating the capacity reports on its organic growth.

Cloud Computing: AWS,AZURE

Third-Party Tools: Toad for SQL Server, Alarm Point and Cyber Ark, CPM, Data services portal.

Hardware/Storage: SAN, RAID

Networking: Active Directory, TCP/IP, DHCP/DNS.

Virtualization

software

Microsoft Hyper-V, VMware, Oracle VM Virtual Box

• Configured Monitored Supported and Troubleshooting of Transactional Replication for multiple databases on Geo-graphically separated cluster environments to provide High Availability and Disaster Recovery Support and troubleshooting for Transactional replication.

• Using Power shell to write automation scripts to automate the processes and do migration of VMs, daily SQL server database health check, Installing SQL server, Applying SPs, and maintenance jobs.

• Good knowledge of High Availability (HA), Always on,SQL Server failover clustering and Disaster Recovery (DR) options for MSSQL Server. Documented HA and DR strategies and actively Participated in DR test.

• Applying service pack on cluster, VMs, Always-on high availability groups and standalone servers.

• Ensuring high availability of the database & verifying all instances are up and running.

• Monitoring SQL server error logs and event viewer logs for errors and issues.

• Worked Extensively on ETL process using SSIS package.

• Great ability to create and manage various database objects like tables and views. DEFENSE HEALTH AGENCY December 2021 – July 2023

Database Administrator

Responsibilities:

• Installing and configuring SQL Servers and MYSQL on Non-Prod & Production Environments.

• Provided 24*7 on-call support for production systems.

• Managed more than 40 DBAs (Offshore) and assigned Incident tickets, change tickets, Weekend tasks, DR Test tasks and make sure that all the tasks are added in the share point and distributed them.

• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node.

• Worked Production servers and managed large verity of databases (21 TB DB).

• Daily activities included resolving incident tickets, determining the root cause of problems, and identifying the solutions, checking aler01ts, monitoring databases, checking error logs, checking the log file size and freeing up disk space shrink log files.

• Creating logins and assigning proper permissions to the created logins, mapping logins to the database and granting appropriate permissions, Transfer Login, Fix Orphan Users and Perform Security Audits.

• Applied Transparent Data Encryption to protect security across multiple servers Encrypted data and log files using transparent data encryption (TDE) solution.

• Responsible for creating, modifying, and managing tables, Index (Clustered/Non-Clustered), Constraints (Unique/Check), Views and Stored Procedures.

• Experience and managing very large Database Backup, Recovery and Disaster Recovery Procedures.

• Coordinating Implementation of Performance and tuning actions with application teams.

• Managing Scheduled tasks for the servers and automated all maintenance activities.

• Accepting user requests and solving by working around within the Service Level agreement.

• Hands on experience on multiple international Servers on Korea, Mexico, China, MLI and India Prod.

• Maintaining the Servers by doing the regular health checks.

• Adding necessary space to the data files and log files on database space alert incidents by generating the capacity reports on its organic growth.Using Power shell to write automation scripts to automate the processes and do migration of VMs, daily SQL server database health check, Installing SQL server, Applying SPs, and maintenance jobs.

• Good knowledge of High Availability (HA), Always on and Disaster Recovery (DR) options for MSSQL Server. Documented HA and DR strategies and actively Participated in DR test.

• Performed DR Testing Drill (Disaster Recovery procedures) between production databases with DR databases every week.

• Hands on experience on SQL server decommissioning process (Retired all Legacy SQL Server).

• Applying service pack on cluster, VMs, Always-on high availability groups and standalone servers.

• Ensuring high availability of the database & verifying all instances are up and running.

• Monitoring SQL server error logs and event viewer logs for errors and issues.

• Installed Failover Clustering on multiple nodes on Active-Passive and Active-Active environments.

• Configured, managed, and troubleshooting the Log Shipping.

• Preparing Health checks and ticket status reports as per client request.

• Hands on experience of ticketing tools like BMC Remedy and Service Now.

• Worked on emergency change requests and incident tickets. Acknowledge Incidents ticket and resolve them on time.

• Deploying and managing many SSRS reports in BIDS for users by gathering and analyzing the requirements, validating the accuracy of the report’s output, and deploying it on SharePoint.

• Designing and deploying SSIS Packages to extract, transfer and load (ETL) data from flat files to SQL Server using Business Intelligence Development Studio.

• setup, Automated testing, Notification, LDAP/AD user management, Automated. PERFICIENT INC. LAFAYETTE, LA February 2019 – Nov 2021 Junior Database Engineer

• Configured & Maintained business continuity applying Database High-Availability/Recovery Solution of Mirroring, Log Shipping, Replication & Clustering & Concepts on Always On

• Performed DR Testing Drill (Disaster Recovery procedures) between production databases with DR databases every week.

• Hands on experience on SQL server decommissioning process (Retired all Legacy SQL Server).

• Applying service pack on cluster, VMs, Always-on high availability groups and standalone servers.

• Ensuring high availability of the database & verifying all instances are up and running.

• Monitoring SQL server error logs and event viewer logs for errors and issues.

• Installed Failover Clustering on multiple nodes on Active-Passive and Active-Active environments.

• Configured, managed, and troubleshooting the Log Shipping.

• Preparing Health checks and ticket status reports as per client request.

• Hands on experience of ticketing tools like BMC Remedy and Service Now.

• Worked on emergency change requests and incident tickets. Acknowledge Incidents ticket and resolve them on time.

• Deploying and managing many SSRS reports in BIDS for users by gathering and analyzing the requirements, validating the accuracy of the report’s output, and deploying it on SharePoint.

• Designing and deploying SSIS Packages to extract, transfer and load (ETL) data from flat files to SQL Server using Business Intelligence Development Studio.

• setup, Automated testing, Notification, LDAP/AD user management, Automated.

• Attended weekly/monthly meetings with DBA, Project Manager technical issues & solution. FEDERAL RESERVE BANK. ST. LOUIS June2018 - Jan 2019 Test Automation Engineer

● Performed and developed testing in development environments.

● Analyzed business requirements and functional documents, created the test strategy document that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing.

● Drafted Test Plan which included testing objectives, testing phases, scenarios and test environment after a thorough analysis of the business rules.

● Performed both manual and automation testing.

● Developed an Automation framework using Selenium Web Driver.

● Used Selenium WebDriver for writing test scripts for regression test coverage.

● Designed a hybrid framework using TestNG and Page Object Model for Automation.

● Created Cucumber Feature files for writing scenarios.

● Wrote Page Objects for accessing objects across various pages of application to give modularity to the framework.

● Extended TestNG framework by adding some helper attributes and methods.

● Implemented Automated execution of tests (nightly and need based) using Maven.

● Implemented Cross Browser and Cross Platform testing with Selenium WebDriver.

● Developed and implemented robust MVC Pattern based Keyword Driven, Selenium Page Object Model Framework with Selenium WebDriver using Object Oriented Programming Java and open source unit test framework TestNG.

Environment/Testing Tools: Windows 10, Jira, Postman, Selenium Webdriver, Cucumber, Java CENTENE CORPORATION. ST. LOUIS, MO September 2017 – May 2018 Senior Application Software Engineer (Automation)

● Created Test Plans and Test Strategy which describes the features and functions to be tested.

● Implemented quality software best practices to develop test strategy, test plan, test data, test case and test automation and actively participate in process improvements.

● Introduced and implemented Automation Testing Framework to the organization.

● Implemented API Testing to the organization.

● Introduced and implemented open source web test tool Selenium and WebDriver for Cross Browser testing.

● Built an automated test suite to increase the automation coverage for the regression test cycle.

● Implemented a wide range of functional testing using various QA Automation Test Framework like Keyword Driven, Data Driven and Behavioral Driven Testing concept to ensure the code reusability and code maintainability.

● Implemented Cross Browser and Cross Platform testing with Selenium WebDriver.

● Developed and implemented robust MVC Pattern based Keyword Driven, Selenium Page Object Model Framework. with Selenium WebDriver using Object Oriented Programming Java and open source unit test framework TestNG.

● Created detailed periodic status reports for senior management to keep them posted on implementation progress

● Ensured the conceptual integrity of the system.

● Contributed to the creation and execution of user interface and software application test plans.

● Tracked the bug and enhancement requests as they are entered into bug tracking systems.

● Participated in project development meetings to provide guidance on testing issues.

● Integrated automation executions with CI process (Jenkins) so scripts are executed each time a build is kicked off.

Environment/Testing Tools:Windows 10, Mac OS, SQL server 2000, Agile, Jira, SoapUI, Selenium, Java MASTERCARD. ST. LOUIS, MO May 2013 – Aug 2017

QA Engineer

● Prepared and implemented Test Plan, planning, tracking and prioritizing project deliverables.

● Arranged the Hardware and software requirement for Test Setup. Escalated the issues about project requirements (Software, Hardware, Resources) to Project Manager/Test Manager.

● Analyzed requirements kept track of the new/changing requirements of projects.

● Attended regular client calls and discussed the weekly status with the client.

● Sent Status Reports (Daily, Weekly etc.) to the client.

● Single point of contact between Development and Testers for iterations, testing and deployment activities.

● Maintained QTP scripts and their execution, debugging.

● Created/Reviewed Test Scripts, andimplemented automation framework using QTP.

● Executed test scripts/test cases from Quality Center; Created/Reviewed/Tracked Test Cases in the Quality Center.

● Wrote SQL queries for testing the mapping of UI fields to backend fields.

● Maintained Test Assets (Requirements, Test Scripts, Test Cases, Test Execution, Defects) in Quality Center.

● Verified requirements coverage by developing Master Test plan, Test strategy, Critical Test Scenarios and Test Scripts with business analysts, project manager and test supervisors.

● Used Quality Center as the test repository and used it for executing the test cases and scripts and logging and generating various reports and graphs for further analysis.

● Used Selenium WebDriver for writing test scripts for regression test coverage.

● Designed a hybrid framework using TestNG and Page Object Model for Automation.

● Implemented Cross Browser and Cross Platform testing with Selenium WebDriver.

● Developed and implemented robust MVC Pattern based Keyword Driven, Selenium Page Object Model Framework with Selenium WebDriver using Object Oriented Programming Java and open source unit test framework TestNG.

Environment/Testing and Tools:Windows 10, Quality Center, QTP, Selenium, UiPath, Java, JIRA, Rally EDUCATION:

Bachelor of Computer Science & Engineering (2009)

Clearance: Public Trust

CERTIFICATION:

RPA Developer Advance (UiPATH)

CompTIA Security+ ce Certification

Contact this candidate