Sajjad Ahmed

• Created complex solutions to fit client and business requirements
• Analyze the system for possible business solutions/bugs/upgrades
• Performance Tuning, Upgrade/Migration/Patch/Installation
• High Availability Solutions – Alwayson Availability Groups and Replication
• Configuring and troubleshooting SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• Transparent Data Encryption (TDE)
• Work with technical and non-technical client requirements directly by designing, developing, and implementing web applications
• Installation and configuration of SSRS
• Migration of SSRS from 2014 to 2019
• Creation, maintenance, updates and troubleshooting of SSIS

· Environment: Visual Studio, SQL Server(2008R2-2012-2014,2017,2019,2022)

• Administering multi Terabytes Databases on different locations
• Upgrade / migrate servers in merge replication from SQL server 2014 to 2019
• Downgraded server(s) from SQL Server 2019 to 2014 with impacting the merge replication between multi TB databases on 14 production servers
• Reporting from different and remote location/Platforms
• Query Optimization for different new or existing module using Query-Execution Plans, Index Utilization, procedure Cache Utilization and Normalization Techniques
• Establishing and Maintaining Backups on Local and Remote Media
• Ad-hoc Reporting
• Performance Monitoring Using Performance Monitor, DBCC Commands, Maintenance Plans
• Install upgrades and patches to existing databases servers
• Monitoring Application Related Jobs and Data Replication Activities
• Work on conflicts occur during replication cycles
• Installation of SQL Server Software and Related Products
• Performance monitoring of Server and Database
• Implement and act in accordance with organization's information security and privacy policies
• Ensure compliance with information security responsibilities specific to your job role
• Protect assets from unauthorized access, disclosure, modification, destruction or interference

Environment: Visual Studio, SQL Server (2008R2-2012-2014,2017,2019)

· Collaboration with system architects, software architects and others to understand business or industry requirements

· Working on Azure Managed Instances. Taking backups of production databases on Azure BLOB storage.

· Managing ALWAYSON Availability Groups on different locations.

· Upgrade servers in availability groups and apply patches.

· Performing transactional replication on Azure Managed Instance from traditional SQL server databases.

· Assess technical proposals requesting changes or upgrades to the existing databases

· Plan new designs for integration into a database structure, using knowledge of the characteristics of the systems being added to the structure

· Develop database architectural strategies at the modeling, design implementation stages to address business or industry requirements

· ETL to AWS S3 bucket using parquet files

· Transactional replication on Azure managed instance (Azure Cloud)

· Determine technical solution feasibility by evaluating workflows problem definition requirements usage models proposed solutions

· Implemented high level security policies for user accounts, passwords, roles and privileges across the enterprise database environments.

Environment: MS SQL Server (2017, 2019), Azure Managed Instances

· Lead the enterprise data center transition/migration project from databases perspective and managed the SAN allocation strategy for all the enterprise SQL Server databases. Cluster architecture diagrams, replication architecture diagrams and other related documents

· Designed and implemented 5 node active/active load balanced and highly available SQL Server 2019 FCI cluster.

· Implemented high level security policies for user accounts, passwords, roles and privileges across the enterprise database environments.

· Migrated SQL Server 2012 to SQL server 2019 including transactional replication between 7 servers.

· Install upgrades and patches to existing databases servers

· Designed a thorough backup and recovery strategy for all major production systems. This initiative involved the design and development of scripts used for physical backups. Also included in this effort was the development of various recovery strategies that included media failure, user failure, and partial and complete recovery.

· Established the Database Administrators Procedures. This outlines all standards for the DBA Group including installing SQL Server, creating databases, DBA tools, administration and monitoring, naming standards, coding standards for T-SQL, policies, practices and procedures.

· Automated monitoring infrastructure by using T-SQL scripts. This allowed our operational DBA team to efficiently gather database metadata, exceptions, and performance statistics of enterprise wide SQL Server instances.

· Finalized and documented several business rules for data integration tasks that led to designing and development of SSIS packages and related ETL scripts.

· Database physical/logical structure as required to overcome space issues.

· Database capacity planning

· Serve as the initial contact person for all SQL support queries and administration

· Day-to-day database system administration, including daily checklists, backup verification, log review, security maintenance, performance tuning

· Worked on merge replication between 15 servers, one publisher, one re-publisher and 13 subscribers.

· Install upgrades and patches to existing databases servers

· Reviews, tests, recommends and installs upgrades of database software

· Implemented database Replications in SQL Server 2008, 2014 for High Availability, DR and Reporting.

· Weekly maintenance of servers using scripts and execute those scripts via SQL job

· Implemented high level security policies for user accounts, passwords, roles and privileges across the enterprise database environments.

· Review, test, update and document detailed disaster recovery/business continuity plans for key production SQL Servers (database mirroring, replication, alwayson) in a VM/SAN environment and Backing up and restoring databases

· Configuration of SQL Server merge or transactional replication

· Hands on experience on Database Mirroring and log shipping and alwayson groups

· Upgrade, configure and maintain server and database monitoring software to baseline system performance and proactively identify (and remedy) potential issues. Resource monitoring and capacity planning

· Performs data analysis and other reporting tasks. This involves data investigation and cleansing

· General understanding of PowerShell

· General knowledge of PostgreSQL, MYSQL RDMS

• Monitoring and optimizing the performance of the database
• When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or optimizing queries and index Implementation
• Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
• Allocating system storage and planning future storage requirements for the database system
• Document the company’s database environment
• Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.

• Assisted in development of different Module for MTBC’s end users
• Collaborated with business support professionals to provide full system maintenance
• Designed and implemented stored procedures for certain certification
• Data migration from other databases (FoxPro, Access, Med Soft) to SQL Server through SQL (Import/Export) wizard or by scripting complex queries as well
• Worked on the data import for the Acquisitions getting signed up with MTBC
• Day to Day, weekly and monthly Reporting
• Mail Server Configuration
• Query Optimization, Roles and weekly maintenance with schema changes
• Delivered database deployment through the whole system lifecycle