Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Languages
Timeline
Generic

Mohammed Sohail Uddin

Atlanta,USA

Summary

More than 17+ Years of experience in Information Technology as a Database Administrator, Database Developer and as a Software Programmer. Experienced as System DBA / Application DBA / Production Support DBA / Hadoop Administrator / Cassandra DBA Experience in Installing, configuring, and managing SQL Server databases on various versions (2008-2022) on multiple platforms including Windows and Linux. Proficient in performing performance tuning and optimization of SQL queries, stored procedures, and indexes to improve database performance. Experience in resolving Database Performance Issues and Database Capacity Issues. Experience in Developing and implementing database backup and recovery strategies to ensure business continuity and disaster recovery. Experience in managing database security by implementing appropriate authentication, authorization, and auditing mechanisms. Hands on Experience in Writing & Debugging Stored Procedures, Triggers, Views and functions. Proficient in Implementing high availability and disaster recovery solutions such as AlwaysOn Availability Groups, Database Mirroring, Windows Clustering, LogShipping and Replication. Experience in Installing, configuring, and managing SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) Experience in implementing Enterprise ETL Solutions using SQL Server Integration Services (SSIS) Experience in Creating, Deploying, Scheduling and Troubleshooting Complex SSIS Packages. Experience in Migrating and Upgrading SSIS Packages across the versions. Experience with SSIS Catalogs. Experience in designing, creating, and deploying of cubes using SSAS. Experience in Designing and Building SSRS Reports using Data Tools and Report builder. Solid understanding of database architecture, data modeling, and schema design in SQL Server environments. Experience in Migrating and Upgrading SQL Server Environments across the different SQL Server Versions. Handled multiple medium to large scale projects with minimal direction and supervision. Experience in providing on-call support 24x7 for critical database issues. Proficient in Installing and configuring Hadoop cluster using Cloudera Manager (CDP) and Ambari (HDP). Proficient in Managing Hadoop services including HDFS, YARN, Hive, Impala, HBase, Kafka, Zookeeper and other services. Skilled in Performing capacity planning, performance tuning, and optimization of Hadoop clusters.

Detail-oriented individual with exceptional communication and project management skills. Proven ability to handle multiple tasks effectively and efficiently in fast-paced environments. Recognized for taking proactive approach to identifying and addressing issues, with focus on optimizing processes and supporting team objectives.

Overview

19
19
years of professional experience
1
1
Certification

Work History

SQL Server DBA / Hadoop DBA / Cassandra DBA

Norfolk Southern Railway
11.2023 - Current
  • Installed, configured, and maintained SQL Server databases on various versions (2008-2022) on multiple platforms including Windows and Linux.
  • Installed, configured, and maintained SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
  • Implemented high availability and disaster recovery solutions such as AlwaysOn Availability Groups, Database Mirroring and Windows Clustering.
  • Performed performance tuning and optimization of SQL queries, stored procedures, and indexes to improve database performance.
  • Developed and implemented database backup and recovery strategies to ensure business continuity and disaster recovery.
  • Managed database security by implementing appropriate authentication, authorization, and auditing mechanisms.
  • Collaborated with development teams to design and implement database schema changes and troubleshoot production issues.
  • Conducted database health checks, capacity planning, and provided recommendations for future growth.
  • Provided on-call support for critical database issues.
  • Installed and configured Hadoop cluster using Cloudera Manager (CDP) and Ambari (HDP).
  • Managed Hadoop services including HDFS, YARN, Hive, Impala, HBase, Kafka, and Zookeeper.
  • Performed capacity planning, performance tuning, and optimization of Hadoop clusters.
  • Designed and implemented backup and recovery strategies for Hadoop cluster using Commvault Backup Solution.
  • Monitored Hadoop cluster using various tools such as Cloudera Manager, Ambari, Datadog and custom scripts.
  • Performed CDP security configurations with Ranger, Kerberos, Knox and Atlas.
  • Installed Workload XM Clusters, monitored workloads on WXM Cluster.
  • Troubleshoot and resolved complex Hadoop issues related to data ingestion, processing, and storage.
  • Worked with cross-functional teams to support Upgrades and Enhancements to Hadoop clusters.
  • Worked closely with Cloudera Support to address support tickets.
  • Provided on-call support for critical Hadoop issues.
  • Installed and configured Cassandra cluster on Linux environments.
  • Managed Cassandra services including Cassandra Query Language (CQL), DataStax OpsCenter, and DataStax Studio.
  • Performed capacity planning, performance tuning, and optimization of Cassandra cluster.
  • Worked on backup and recovery strategies for Cassandra cluster using DataStax Backup and Disaster Recovery.
  • Monitored Cassandra cluster using various tools such as DataStax OpsCenter and custom-built scripts.
  • Familiar with Troubleshooting and resolving Cassandra issues related to data modeling, replication, and consistency.
  • Worked with cross-functional teams to design and build Cassandra clusters.
  • Environment: MS SQL Server 2022 / 2017 / 2016/2014/2012/2008 R2/SQL Server 2008/SQL Server 2005/2000, Windows 2012/2008/2003 Servers, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, Windows Clusters, VMWare, PowerShell, Cloud Computing, MS BI Dev Studio, Microsoft.Net Frame work, Hadoop, Hdfs, Kudu, Spark, MapReduce, Yarn, Hive, Sqoop, Kafka, Linux, Ansible, HBase, PostgreSQL, Kerberos, Python, Shell Scripting, Tableau, Spotfire, DataStax Enterprise, Cassandra nodetool, DataStax DevCenter, DataStax OpsCenter, DataStax Studio, Grafana and Prometheus.

SQL Server DBA / Hadoop DBA / Cassandra DBA

Open Systems
05.2015 - 11.2023
  • Install and patch SQL Server 2022 /2017 / 2014/ 2008R2 SSDS, SSAS, SSIS and SSRS.
  • Administer, Support and Troubleshoot SSDS, SSAS, SSIS and SSRS environments.
  • Manage change control for code promotion on Microsoft database resources.
  • Participate in on-call rotation to provide 24/7 operational support.
  • Provide operational support for 3000+ databases across 600+ SQL Instances.
  • Troubleshoot service problems; determine root cause and provide resolutions.
  • Produce documentation as needed on database standards and policies.
  • Monitor database performance and derive solutions for performance problems.
  • Provide guidance on good database design and implementation practices to Developers.
  • Perform capacity planning for database systems.
  • Perform and ensure database backups and restores.
  • Participate in DR testing and execution.
  • Participate in team environment to share workload and responsibilities as circumstance warrants.
  • Ensure compliance with database policies and procedures.
  • Perform object creation and alteration according to established change control procedures.
  • Maintain working knowledge of relevant operating system, network and storage principles relating to database platforms.
  • Installed and Configured Hortonworks Data Platform (HDP) and Cloudera Data Platform (CDP).
  • Installed and Configured Hadoop Ecosystem (MapReduce, HDFS, Kudu, Sqoop, Hive, Kafka) both manually and using Ansible, Ambari Server\ Cloudera Manager
  • Enabled security to the cluster using Kerberos and integrated clusters with LDAP/AD at Enterprise level.
  • Worked on YARN capacity scheduler by creating queues to allocate resource guarantee to specific groups.
  • Implemented Hadoop stack and different bigdata analytic tools, migration from different databases to Hadoop (Hdfs). Responsible for adding new ecosystem components, like spark, kudu, Knox with required custom configurations based on the requirements.
  • Installed and configured Knox gateway to facilitate easy access for 3rd party tools in Kerberos environment. Secured the directories with ACL's and Encryption Zones
  • Restricted the User Access on the data using Ranger by providing adequate read/write permissions.
  • Installed and configured Kafka Cluster with additional zookeeper services
  • Helped the team to increase cluster size. The configuration for additional data nodes.
  • Integrated BI and Analytical tools like Tableau and Spotfire with Hadoop Cluster
  • Worked with Ranger, Knox configuration to provide centralized security to Hadoop services.
  • Expertise with NoSQL databases like HBase.
  • Responsible for Upgrades and Migrations in both HDP and CDP environments.
  • Provided support for Monthly OS Patching.
  • Implemented SSL \ TLS for Hadoop Cluster.
  • Supported in setting up R&D environments and updating configurations for implementing scripts with Sqoop. Worked on tuning the performance queries.
  • Planning and implementation of data migration from existing staging to production cluster.
  • Worked on 24/7 on call support for the production cluster.
  • Environment: Hadoop, Hdfs, Kudu, Spark, MapReduce, Yarn, Hive, Sqoop, Kafka, Linux, Ansible, HBase, PostgreSQL, Kerberos, Python, Shell Scripting, Tableau, Spotfire
  • Installed and configured Cassandra cluster on Linux environments.
  • Managed Cassandra services including Cassandra Query Language (CQL), DataStax OpsCenter, and DataStax Studio.
  • Performed capacity planning, performance tuning, and optimization of Cassandra cluster.
  • Worked on backup and recovery strategies for Cassandra cluster using DataStax Backup and Disaster Recovery.
  • Monitored Cassandra cluster using various tools such as DataStax OpsCenter and custom-built scripts.
  • Familiar with Troubleshooting and resolving Cassandra issues related to data modeling, replication, and consistency.
  • Worked with cross-functional teams to design and build Cassandra clusters.
  • Environment: MS SQL Server 2022 / 2017 / 2016/2014/2012/2008 R2/SQL Server 2008/SQL Server 2005/2000, Windows 2012/2008/2003 Servers, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, Windows Clusters, VMWare, PowerShell, Cloud Computing, MS BI Dev Studio, Microsoft.Net Frame work, Hadoop, Hdfs, Kudu, Spark, MapReduce, Yarn, Hive, Sqoop, Kafka, Linux, Ansible, HBase, PostgreSQL, Kerberos, Python, Shell Scripting, Tableau, Spotfire, DataStax Enterprise, Cassandra nodetool, DataStax DevCenter, DataStax OpsCenter, DataStax Studio, Grafana and Prometheus.

SQL Server DBA / BI Developer

Mavrick Software and Telecom Services Inc.
01.2015 - 05.2015
  • Responsible for Administrating Production, Development and Test SQL Servers.
  • Installed, Configured and Patched SQL Server 2012 in Production, Development and Test Environments.
  • Installed and configured SQL Server 2000/2005/2008/2012 with required Service Packs and patches in both Cluster and Standalone environments.
  • Prepared the Servers for implementing HADR AlwaysOn Solution by effectively implementing Prerequisites on each replica.
  • Implemented High Availability and Disaster Recovery Solution using Failover Cluster Instance.
  • Implemented HADR AlwaysOn Solution using Availability Groups on 6 Nodes matrix.
  • Configured and Monitored Availability Groups.
  • Upgraded and Migrated SQL 2000 \ 2005 \ 2008 Databases to SQL 2012 Environment.
  • Migrated DTS \ SSIS Packages from SQL 2000 \ 2005\ 2008 to SQL 2012 Environment.
  • Performed day to day Database Maintenance tasks Database Monitoring, Backups, Space Management and Resource Utilization.
  • Designed and Created databases, tables, Indexes, views, stored procedures and triggers as per requirements.
  • Implemented different Replication topologies.
  • Responsible for Troubleshooting SQL Server Performance bottlenecks.
  • Responsible for Gathering and Analyzing SQL Server Performance Metrics and providing efficient solution to resolve them.
  • Managed SQL Server Analysis Servers, involved in different OLAP deployments.
  • Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
  • Installed, Configured and Supported SQL Server Reporting services in SQL 2012 Environment.
  • Worked on different SQL Server Reporting Services Projects.
  • Served as interface between application and infrastructure teams for Developing requirements, managing demand and monitoring performance.
  • Provided technical support to internal developers and external clients.
  • Collaborated on the full technical lifecycle from architecture to support of Client Data Environment.
  • Environment: MS SQL Server 2012 / 2008 R2 / SQL Server 2008 / SQL Server 2005 / 2000, Windows 2012/ 2008 / 2003 Servers, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, Windows Clusters, VMWare, PowerShell, Cloud Computing, SAN, Avamar Net Backup, Oracle, MySQL, MS BI Dev Studio, IIS, WebSphere, J2EE, Java, JSP, Servlets, Struts, Microsoft.Net Framework and Transact-SQL.

Technology Specialist / SQL Server DBA / BI Developer

Yash Technologies
05.2014 - 12.2014
  • Administered and provided support for SQL SERVER 2012/2008R2/2008 and 2005 in production, development, and test environments.
  • Developed SSRS reports and SSIS ETL packages.
  • Managed DataMart and Cubes.
  • Responsible for administrating production, development and testing of SQL servers.
  • Installed, configured and patched SQL servers in production, development and test environments.
  • Installed and configured SQL Server 2005/2008/2012 with required service packs and patches in both cluster and standalone environments.
  • Performed day to day DB administrative tasks which included: DB Performance Monitoring, DB Errors and Alerts Monitoring, Troubleshooting T-SQL Queries, Store Procedures, SQL Jobs, DTS, SSIS, SSRS, BCP, DBCC, SQL Server Security, Linked Servers and Space management related issues.
  • Designed, developed, implemented and automated data pruning task for several business-critical databases.
  • Developed PowerShell Script as needed for monitoring and administrative purposes.
  • Migrated and upgraded SQL Server Databases from SQL 2005 to SQL 2012 version.
  • Migrated and upgraded SSIS Packages from SQL 2005 to SQL 2012 version.
  • Designed, developed and deployed many SSIS Packages for business ETL needs.
  • Worked on developing SSRS reports against Data Cube by using MDX queries.
  • Designed and modified SSAS DataMart Cube as per business requirement.
  • Performed POC for implementing AlwaysOn FCI and Availability Groups in SQL 2014 Server
  • Took initiatives to modernize non-standard models, processes, and implementations.
  • Environment: MS SQL Server 2012/2008 R2/SQL Server 2008/SQL Server 2005/2000, Windows 2012/2008/2003 Servers, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, Windows Clusters, VMWare, PowerShell, Cloud Computing, MS BI Dev Studio, Microsoft.Net Framework

SQL Server DBA / BI Developer

Attorney General's Office of OHIO
11.2012 - 04.2014
  • Responsible for Administrating Production, Development and Test SQL Servers.
  • Installed, Configured and Patched SQL Server 2012 in Production, Development and Test Environments.
  • Installed and configured SQL Server 2000/2005/2008/2012 with required Service Packs and patches in both Cluster and Standalone environments.
  • Prepared the Servers for implementing HADR AlwaysOn Solution by effectively implementing Prerequisites on each replica.
  • Implemented High Availability and Disaster Recovery Solution using Failover Cluster Instance.
  • Implemented HADR AlwaysOn Solution using Availability Groups on 6 Nodes matrix.
  • Configured and Monitored Availability Groups.
  • Upgraded and Migrated SQL 2000 \ 2005 \ 2008 Databases to SQL 2012 Environment.
  • Implemented Auditing for SQL Databases.
  • Responsible for Storage Capacity Planning for SQL Servers.
  • Restored Databases using Recovery Advisor.
  • Implemented FileTable strategy for efficiently storing the data off of the Databases.
  • Performed POC for Implementing Columnstore Indexes.
  • Implemented Encryption for SQL Databases.
  • Migrated DTS \ SSIS Packages from SQL 2000 \ 2005\ 2008 to SQL 2012 Environment.
  • Performed day to day Database Maintenance tasks Database Monitoring, Backups, Space Management and Resource Utilization.
  • Designed and Created databases, tables, Indexes, views, stored procedures and triggers as per requirements.
  • Implemented different Replication topologies.
  • Responsible for Troubleshooting SQL Server Performance bottlenecks.
  • Responsible for Gathering and Analyzing SQL Server Performance Metrics and providing efficient solution to resolve them.
  • Managed SQL Server Analysis Servers, involved in different OLAP deployments.
  • Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
  • Installed, Configured and Supported SQL Server Reporting services in SQL 2012 Environment.
  • Worked on different SQL Server Reporting Services Projects.
  • Served as interface between application and infrastructure teams for Developing requirements, managing demand and monitoring performance.
  • Provided technical support to internal developers and external clients.
  • Collaborated on the full technical lifecycle from architecture to support of Client Data Environment.
  • Environment: MS SQL Server 2012 / 2008 R2 / SQL Server 2008 / SQL Server 2005 / 2000, Windows 2012/ 2008 / 2003 Servers, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, Windows Clusters, VMWare, PowerShell, Cloud Computing, SAN, Avamar Net Backup, Oracle, MySQL, MS BI Dev Studio, IIS, WebSphere, J2EE, Java, JSP, Servlets, Struts, Microsoft.Net Framework and Transact-SQL.

SQL Server DBA / BI Developer

Cardinal Health Inc.
03.2009 - 11.2012
  • Supported SQL Servers in Production, Development and Test Environments.
  • Responsible for Managing and administrating more than 690 SQL Servers in Prod\Stage\Dev environments.
  • Managed very large databases and server over 5+ TB and server over 8 TB.
  • Installed and configured SQL Server 2000/2005/2008/2012 with required Service Packs and patches in both Cluster and Standalone environments.
  • Managed clustered environment in Active – Active and Active – Passive environment.
  • Build and configured HP Polyserve as a High Availability and Disaster Recovery Solution.
  • Consolidated and Migrated SQL DB environments on to PolyServe environment.
  • Supported mission critical Enterprise application database.
  • Performed day to day Database Maintenance tasks Database Monitoring, Backups, Space Management and Resource Utilization.
  • Implemented High Availability solutions using DB Mirroring, LogShipping, and Windows Clustering.
  • Performed POC for implementing SQL 2012 HADR.
  • Monitored the database objects growth, managed the extents growth and monitored the excessive fragmentation of Indexes and took remedial steps.
  • Optimized schema, performance, and capacity planning of various data transformation processes.
  • Worked on creating SQL traces using SQL Profiler Wizard and also efficiently used the PerfMon utility and other performance utilities to capture the hardware and performance bottlenecks.
  • Responsible for Designing Databases and Database Objects.
  • Implemented Log Shipping and Database mirroring between different SQL Instances.
  • Implemented various types of Replication Models like Snapshot, Merge and Transactional in 2000/2005/2008 prod environments.
  • Managed SQL Server Analysis Servers, involved in different OLAP deployments using MDX queries.
  • Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
  • Wrote MDX queries and expressions for use in Front End BI Applications.
  • Optimized cubes for better query performance.
  • Extracted data from XML files.
  • Processed cube to perform incremental updates.
  • Migrated SQL 7/ SQL 2000 environments to SQL 2005 / SQL 2008 / SQL 2008 R2 environments.
  • Environment: MS SQL Server 2012 / 2008 R2 / SQL Server 2008 / SQL Server 2005 / 2000, Windows 2003 Server, Windows Server 2008, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, Windows Clusters, HP PolyServe, VMWare, SAP, Business Objects, MicroStrategy, PowerShell, Cloud Computing, SAN, Veritas Net Backup, Avamar Net Backup, , Informatica, DataStage, Oracle, DB2, Teradata, MySQL, Ignite Confio, Tivoli Monitoring tools, Clarify CRM, MS BI Dev Studio, IIS, WebLogic, WebSphere, J2EE, Java, JSP, Servlets, Struts, Microsoft.Net Frame work and Transact-SQL.

Computer Programmer / SQL Server DBA/Developer

Vaptech Inc.
04.2008 - 03.2009
  • Worked on both side by side and in-place SQL Database upgrades.
  • Worked with Application teams in converting DTS Packages to SSIS Packages and resolved different package migration issues.
  • Created SSIS packages to clean and load data to data warehouse.
  • Created package to transfer data between OLTP and OLAP databases.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
  • Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMS using SQL 2005 \ 2008 BIDS and deploy the data; scheduled the jobs to do these tasks periodically.
  • Extensively analyzed, maintained and documented complex relational database structures to ensure successful implementation as well as optimal performance.
  • Installed and Administered SQL Server Reporting services in SQL 2005, SQL 2008 and SQL 2008 R2 environments.
  • Consolidated SSRS environments using Scale-In deployments.
  • Designed and Developed reports using SQL Server Reporting Services for DB Administration purposes.
  • Created reports by extracting data from cube.
  • Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
  • Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports.
  • Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
  • Created report models and deployed on report server.
  • Created standard report Subscriptions and Data Driven report Subscriptions.
  • Created report snapshots and cache for better performance.
  • Worked on different SQL Server Reporting Services Projects.
  • Worked with onshore and offshore teams to provide subject matter expertise.
  • Provided technical support to internal developers and external clients.
  • Collaborated on the full technical lifecycle from architecture to support of Client Data Environment.
  • Environment: MS SQL Server 2012 / 2008 R2 / SQL Server 2008 / SQL Server 2005 / 2000, Windows 2003 Server, Windows Server 2008, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, Windows Clusters, HP PolyServe, VMWare, SAP, Business Objects, MicroStrategy, PowerShell, Cloud Computing, SAN, Veritas Net Backup, Avamar Net Backup, , Informatica, DataStage, Oracle, DB2, Teradata, MySQL, Ignite Confio, Tivoli Monitoring tools, Clarify CRM, MS BI Dev Studio, IIS, WebLogic, WebSphere, J2EE, Java, JSP, Servlets, Struts, Microsoft.Net Frame work and Transact-SQL.

Research Assistant / Teaching Assistant

Texas A&M Agriculture and Health Science Center
01.2007 - 12.2007
  • Worked on both side by side and in-place SQL Database upgrades.
  • Worked with Application teams in converting DTS Packages to SSIS Packages and resolved different package migration issues.
  • Created SSIS packages to clean and load data to data warehouse.
  • Created package to transfer data between OLTP and OLAP databases.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
  • Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMS using SQL 2005 \ 2008 BIDS and deploy the data; scheduled the jobs to do these tasks periodically.
  • Extensively analyzed, maintained and documented complex relational database structures to ensure successful implementation as well as optimal performance.
  • Installed and Administered SQL Server Reporting services in SQL 2005, SQL 2008 and SQL 2008 R2 environments.
  • Consolidated SSRS environments using Scale-In deployments.
  • Designed and Developed reports using SQL Server Reporting Services for DB Administration purposes.
  • Created reports by extracting data from cube.
  • Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
  • Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports.
  • Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
  • Created report models and deployed on report server.
  • Created standard report Subscriptions and Data Driven report Subscriptions.
  • Created report snapshots and cache for better performance.
  • Worked on different SQL Server Reporting Services Projects.
  • Worked with onshore and offshore teams to provide subject matter expertise.
  • Provided technical support to internal developers and external clients.
  • Collaborated on the full technical lifecycle from architecture to support of Client Data Environment.
  • Environment: MS SQL Server 2012 / 2008 R2 / SQL Server 2008 / SQL Server 2005 / 2000, Windows 2003 Server, Windows Server 2008, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, Windows Clusters, HP PolyServe, VMWare, SAP, Business Objects, MicroStrategy, PowerShell, Cloud Computing, SAN, Veritas Net Backup, Avamar Net Backup, , Informatica, DataStage, Oracle, DB2, Teradata, MySQL, Ignite Confio, Tivoli Monitoring tools, Clarify CRM, MS BI Dev Studio, IIS, WebLogic, WebSphere, J2EE, Java, JSP, Servlets, Struts, Microsoft.Net Frame work and Transact-SQL.

Education

Master’s - computer science

Texas A&M University-Kingsville
Kingsville, TX

Bachelor’s degree - computer science

JNT University

Skills

  • SQL Server Tools: Management Studio, Profiler, Tuning Advisor, Data tools, Activity Monitor, Configuration Manager, Idera SQL Diagnostic Manager, Ignite Confio, Log Parser, Windows PerfMon Utilities and SQL Server PerfMon utilities
  • RDBMS: MS-SQL Server versions (2008-2022) Oracle (11g – 19c), IBM DB2, Teradata, MySQL, PostgreSQL, and MS Access
  • Hadoop Eco System: HDFS, MapReduce, Yarn, HBase, Hive, Hue, Sqoop, Kafka, Knox, Spark, Solr, Kudu, Atlas, Ranger, Schema Registry, SMM, Zookeeper, CDH, HDP, Ambari, Cloudera Manager, Kerberos OS
  • Cassandra NoSQL: DataStax Enterprise, Cassandra nodetool, DataStax DevCenter, DataStax OpsCenter, DataStax Studio, Grafana and Prometheus
  • Software Tools: Ansible, NoMachine, Commvault, Visual Code, TSM, Active Directory Search, DNS, F5 load balancer, Kerberos, MS SQL Server Reporting Services, Crystal Reports, Business Objects, Spotfire and Tableau
  • High Availability Solutions: Microsoft Clustering, VMWare, Kubernetes, and Containers
  • Cloud & Operating Systems: Amazon Web Services, Microsoft Azure, Windows OS and Redhat Linux
  • Languages: T-SQL, Windows Scripting, Power Shell Scripting, Shell Scripting, Cassandra Query Language, PSQL, R, Python, Java, VB Script, JavaScript, YAML
  • Team collaboration
  • Multitasking Abilities
  • Team leadership
  • Excellent communication

Accomplishments

  • Designed and implemented Always On Availability Groups across production clusters, achieving 99.99% uptime for critical applications.
  • Lead many mission critical upgrade and migration projects.
  • Reduced average query response time through index optimization, query tuning, and partitioning strategies.
  • Automated daily health checks and alerting using Ansible and PowerShell, reducing manual effort by 60%.
  • Developed backup and disaster recovery strategy using native SQL tools

Certification

  • Administering a SQL Database Infrastructure (70-764)
  • Administering Microsoft SQL Server 2012 Databases (071-462).
  • Microsoft Certified Professional in SQL SERVER 2005 (70-431).
  • Administrating Cloudera Private Cloud Base
  • DS201: Foundations of Apache Cassandra and DataStax Enterprise
  • AWS Cloud Practitioner
  • Microsoft Azure Administrator

Languages

T-SQL, Windows Scripting, Power Shell Scripting, Shell Scripting, Cassandra Query Language, PSQL, R, Python, Java, VB Script, JavaScript, YAML

Timeline

SQL Server DBA / Hadoop DBA / Cassandra DBA

Norfolk Southern Railway
11.2023 - Current

SQL Server DBA / Hadoop DBA / Cassandra DBA

Open Systems
05.2015 - 11.2023

SQL Server DBA / BI Developer

Mavrick Software and Telecom Services Inc.
01.2015 - 05.2015

Technology Specialist / SQL Server DBA / BI Developer

Yash Technologies
05.2014 - 12.2014

SQL Server DBA / BI Developer

Attorney General's Office of OHIO
11.2012 - 04.2014

SQL Server DBA / BI Developer

Cardinal Health Inc.
03.2009 - 11.2012

Computer Programmer / SQL Server DBA/Developer

Vaptech Inc.
04.2008 - 03.2009

Research Assistant / Teaching Assistant

Texas A&M Agriculture and Health Science Center
01.2007 - 12.2007

Bachelor’s degree - computer science

JNT University

Master’s - computer science

Texas A&M University-Kingsville

Similar Profiles

CREATE PROFILE
Mohammed Sohail Uddin