MOHAMMED ALAM

*** ****** ******, ********, ** ***33. Tel: 347-***-****. adl6c4@r.postjobfree.com US CITIZEN

PROFESSIONAL SUMMARY:

Managing team of direct reports and offshore resource of engineering, database operations QA, and system operation team.

Act as senior technical resource, prioritize tasks, resolve complex problems, and participate in strategy discussions.

Maintain awareness of the department budget, influence budget planning, and model the financial impact of decisions.

Professional attitude with ability to prioritize work, multi-tasker, flex between changing priorities, and strong time management which is critical in our rapidly changing environment.

Define long-term strategy and prioritize strategic and technical tasks, including project task delegation, tracking and follow-through on quarterly and annual goals, annual performance reviews, coordination of technical training.

Write, maintain and enforce all data-related procedures and protocols, based on industry needs and best practices.

Highly effective incident management skills, including incident communications, root cause identification, triage and mitigation.

Collaboratively define and drive product strategy, vision and evangelize to internal stakeholders with Operations and Product Development teams as well as Data Architects to assure adherence to operational objectives.

Very well experience using an in Incident Management tool such as OpsGenie and experience with build and deploy tools such as TeamCity and Octopus.

Subway – Franchise World Headquarters (Milford, CT) July 2017 - Present

Technical Database Manager

I am a technical database manager that provide guidance and technical support for all SQL Server production and non-production databases, services, and infrastructure, both in house and cloud resident. Administers Microsoft SQL databases, PostgreSQL, E-Commerce and other applications in running in on-prem and cloud over 100 tbs of data in production.

Strong experience migrating multi-terabyte database migrations from OLD VCE to vMax Flash IO to SQL Server 2016/2019 which resulted performance enhancement by 10 folds.

Performed over 500s database server migration and SQL installations and configuration for MSSQL server 2012\2014\2016\2019, troubleshooting installation issues.

Migrated database servers from SQL Server 2012 to SQL Server 2016/2019 in Windows Server 2012R2/2019 over 100TBs.

Managing both database operation and engineering team ensuring goal setting, career development, performance management and other people management duties.

Proactively working toward analyzing databases workloads and identify opportunities for system performance optimizations.

Experience handling high pressure situations track and resolve production incident and resolving incidents within defined SLA.

Provide leadership, architectural recommendations and implementation plans for potential long-term database scalability, performance improvements, and support for a hybrid infrastructure.

Experience establishing and monitor data security and governance policies and procedures.

Experience working on improving databases performance, security, and automating mundane work to improve the process and working with PII/CCPA/GDPR data privacy requirements.

Implemented best monitors database performance and changes necessary to maintain acceptable performance levels. Ensures the availability and recoverability of all databases.

Expertise in implementing RDBMS architecture, DB Design & implementation of HA/DR Cluster, Performance Tuning, supporting DB Appliances and Practicing and implementing DB standards.

Have expertise and knowledge in building automation day to day DBA tasks solutions using any scripting language such as t-sql, PowerShell and Python in the cloud and on-prem.

Experience with provisioning/monitoring/maintaining of AWS RDS and open source databases.

Strong experience in leading projects with clear timelines and deliverables to balance priorities and on time and within budget.

Provide on call support for critical production systems and share technical expertise, providing technical mentorship and cross-training to other peers and team members.

Experience writing SQL queries, analyzing query performance using query plans and tuning query performance.

Work closely with the Development, Product and PMO teams to accomplish cross-departmental projects and initiatives.

Experience working with ETL technologies using Matillion tool and postgreSQL/Redshift dbs in AWS.

Sr. Level Knowledge of Microsoft SQL Server including Clusters, Availability Groups, Performance and Tuning, Backup and Disaster Recovery and Security.

Developed disaster recovery and business continuity processes, to meet established RPO and RTO requirements. Periodically test disaster recovery capability.

Architecture and provisioned MongoDB/Azure/Sitecore SQL Databases both in Azure Cloud.

Extensive experience designing and developing database technologies and provided production support in a global organization with 1000+ databases using Azure SQL Database, SQL Server, MySQL, Redis, Cosmos, PostgreSQL, MongoDB, Redshift, and Dynamo databases.

Expertise in SQL Server / SSAS / SSRS / SSIS / SQL Server CLR / NoSQL (OLAP and OLTP).

Expertise managing SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.

Expertise in designing and implementation of Azure cloud databases, high-availability solutions, AlwaysOn Availability Group, replication, encryption, and disaster recovery solutions.

Share expertise with team members providing technical mentorship and cross-training as needed.

Expert experience of SQL performance tuning techniques including query plan understanding and management, SQL tracing, DB stats, indexing techniques, statistics using native tool and third party tools.

Architect and implemented all database system monitoring using SentryOne and DBSentry both on-prem and cloud infrastructure and db system in AWS using cloud watch.

Migrated OLD VCE to new Flash storage vMax and benchmark using number of different tools to measure performance capacity.

Experience working with Muelsoft/TangoDB with SQL Server as a micro-services.

Work extended or flexible schedules when necessary or when requested by Management.

Built a process of production environments including the requirement for high availability and team oriented 24x7 support capabilities.

Creative Mobile Technologies Inc., (LIC-NY) Aug. 2015 to July 2017

Lead Database Administrator

Performance is a key to success in Creative Mobile Technologies, having to work with very large databases and keep the performance level high is great achievement without unexpected outage.

Expertise in promotes data standards, system procedures and security policies, and best practices, the entire different environment such as Dev/QA/Staging/UAT/Prod environments and QA & release control, and access/rights certifications.

Proactively investigate defects or problems, work with infrastructure and external vendors to identify solutions and support any fixes that are required as part of service improvement.

Implement best practices through the Change Management procedure and other standard practices in installing, configuring and supporting databases and related items in Test and Production environments.

Ensure service uptime is prioritized and all faults, incidents and problems are responded to in an efficient manner without negatively impacting SLAs and reporting metrics in place.

Ferrandino and Sons Inc. (Farmingdale, NY) Oct. 2014 to July 2015

Sr/Lead SQL Server Database Administrator

Enterprise Reporting, AlwaysOn High Availability Group setup with 3 nodes Setup, Procurement Subsystem.

Worked closely with development, BAs and SMEs to create DBs, Tables, and Indexes for projects, which helped increase profitability through billable services and automation.

Migrated databases from physical location to dedicated data center primary resource for the installation, upgrading, and administration of SQL Server 2014 and 2012 instances on physical and VM (Hyper V) machines in all environments.

Berkadia, PA (The Berkshire Hathaway) July 2012 to Oct. 2014

SQL Server Database Specialist (Contract)

Managed REMEDY Backend Server for Performance tuning with high Availability with DB size of 3.0 TB.

Experience creating documentation of installation procedures, monitoring procedures, security policies, configuration changes, migration procedures, and best practices for development teams.

Major responsibility to support Production, Development, Staging (QA), and UAT for maintaining 160 SQL Servers and PeopleSoft 8.1.

Redgate’s SQL Data Compare) is used for checking the Databases & synchronizing of the Databases.

EDS, Virginia Oct. 2008 to June 2012

SQL Server DBA (Contract)

Monitors and addresses database server performance issues to include running SQL profiler, identifying long-running SQL, advising development teams to improve performance, optimizing performance using techniques including indexing and schema normalization/de-normalization, capacity planning, and server resource usage.

Experience working knowledge of SQL Server Clustering, data replication to include log shipping and database mirroring required Changed the connection strings in connection manager and tested the Package.

Citi Group, NJ Oct. 2007 to Sept. 2008

SQL Server DBA (Contract)

Monitoring the server for High availability of the SQL Server Databases.

Manages and performs detailed functional development and testing of database server administration maintenance scripts to include: backups, index defragmentation, database consistency checks, and log checks.

Tested and Implemented procedures to detect poor database performance, collecting required information, and root cause analysis.

Environment: MS SQL Server 2016/2014/2012/2008R2/2005/2000/6.5,T-SQL,SSIS, SSRS, Report Builder, RedGate Compare 10, BCP, SQL Profiler, Log Shipping, Replication, Mirroring, Clustering Windows Server 2008R2 and Windows Server 2003, Windows 2012/R2, .Net Framework, C#.Net, JavaScript, MS TFS, MS-Access, SharePoint 2010, Oracle 11g, PeopleSoft 8.1, ASP.Net frame, JAMS 5.4. Solarwinds, ApexSQL, SentryOne, Datawarehouse, OLAP and OLTP. Dell Kase, TFS, Foglight, Precise3, Bitlocker, keepass, Thycotic, Basecamp, Citrix, Dynamix, minion, Data domain (Dell EMC) and MS Visio

Specialties: SQL Server, Azure SQL Database, SiteCore, Snaplogic, Movibity, Microsoft Azure implementation, MongoDB, Redis, Cosmos, Redshift, PostGreSQL, MySQL, DynomoDB, B2B, SaaS, Microservices, Tableu, Sitecore. AlwaysOn Availability Groups, Performance tuning, Capacity Planning, SSIS, SSAS, SSRS, Windows 2012R2, SAN Replication, DR, Clustering, Azure, AWS, SolarWinds(DPA/DPM), SentryOne, DBSentry, PAL, Data Masking (redgate), Delphix, Erwin.

Education/Certification

Bachelors in Mathematics and Biophysical Science with Minor in Philosophy, from Medgar Evers College, City University of New York, New York. (2007).

Microsoft Certified Technology Specialist (MCTS)

Leadership Skills/Members

Student Government Association (SGA) Vice-President 2006-2007 @ Medgar Evers College, CUNY.

Members of PASS and other SQL Server Database Administration/Development communities.

Member of SQLSaturday and run SQL Users group in NYC Chapter.

Contact this candidate