Mohammad Alam Email & Phone Number

Bethesda, Md, Us

Joined as a Senior Software Engineer in Revenue Management/IT Application Development Department of Marriott International and will work on databases.

Medford, Massachusetts, Us

Responsible for Cloud database architect, design, development, management, administration, high availability, scalability, reliability, security, upgrade, migration, disaster recovery, maintenance, support, business requirements activities for Production, Non-production databases for Engineering, Business Software Systems, Operations, Customer Support, DWH departments, digital roadside platform company on Cloud System (AWS, Heroku). PostgreSQL: 14/13/12/11, Postico, PgAdminMySQL: 8/5.7AWS EC2, RDS, Aurora: Primary, Read Replica, Management Console, CloudWatch, Performance Insights, Cross Region Replication, Failover/Disaster Recovery, Pg_bouncer, Redis, Heroku, Pipelines, Datadog, Terraform, Github, CI/CD, Rollbar, Ruby on Rails, Docker, Looker, Fivetran, Salesforce, Snowflake DWH, Tonic Subsetting tool.Database Regional Fail-over/High Availability Solutions: AWS RDS Cross-region Replication: Setup, maintenance and monitoring. Cross Region Disaster Recovery, Strategies and Procedures: planning, implementation and testing of AWS RDS Cross region disaster recovery for Production, Non-production databases.Database Diagnostics and Performance Tuning: monitoring of long running queries with execution/explain plan, query analysis, index analysis, database parameters analysis tuning and recommendations.Database Monitoring & Alerting: Database monitoring and alerting by Datadog, apply by Terraform, CloudWatch. Database monitoring of key components like CPU utilization, Disk IO, Queue depth, Memory, Space utilization, Rows insert/delete/update, dead rows, index scans, sequential scans.Database Backup & Recovery: Database AWS RDS daily automatic backup, retention, S3, recovery.Database Support for Software release: Database changes, PR review/approval.Database Security & Access.Database Installation & Patches.Database Upgrade & Migration.Database Performance Tracking.Fivetran ELT Tool, Looker BI: setup, maintenance.Tonic.ai Subsetting Tool: setup, support.

Winston-Salem, Nc, Us

Responsible for database architect, design, development, management, administration, high availability, scalability, reliability, security, maintenance, support, business requirements activities for production, non-production databases for Business Software Systems, Operations, Engineering, Customer Support, DWH/BI departments of E-commerce company.Database Migration from On-Premises to Cloud (AWS/OCI).Oracle:DB Fail-over/High Availability Solutions:Golden Gate Replication setup, maintenance, monitoring in heterogeneous DB environments.Standby/Active Data Guard,Snapshot Standby setup, maintenance, monitoring.OEM 13c setup, maintenance, monitoring of OEM, Agents.DB, Query Diagnostics,Tuning by OEM,Diagnostic/Tuning pack, AWR,ADDM,ASH, Sqlt, Explain plan.DB Backup,Recovery. DB Disaster Recovery Strategies/testing.DB, Schema refresh, restore/recovery. DB Design, development, objects changes, deployment, support for Software releases.DB security, access rights, profiles, roles, auditing, baselines.DB Installation, Patches of Oracle DB S/w 19c/18c/12c/11g. DB Upgrade, Migration from Oracle 11g to 12c. Pre/post upgrade plan, gather stats,SQL execution plan, forcing plan.DB Upgrade with zero downtime by Golden Gate replication.DB Space Utilization management & tracking.DB Performance Reviewing, Tracking.MySQL: Installation, setup,DB/objects creation,backup/restore, security,replication, DR,monitoring, maintenance.MS SQL Server: Installation,cluster,HA setup, DB/objects creation, backup/restore, security, replication,DR, monitoring, maintenance.PostgreSQL: Installation,setup,DB/objects creation,backup/restore,security,replication, monitoring, maintenance.Cassandra: Installation, setup, administration, replication,DCawareness,gossip,repair,keyspaces, compaction, nodetool, CQL.Couchbase: Installation, setup, administration, replication, XDCR, rebalancing, indexing, buckets, views, shard, N1QL.Hadoop: administration.Data Governance.Automation of jobs.

Tempe, Arizona, Us

Responsible for database design, management, administration, high availability, scalability, reliability, security, maintenance, support and business requirements activities for production, non-production databases for Business Software Systems, Operations, Engineering, Customer Support and Data Warehouse departments of identity theft protection company.Oracle:Database Fail-over/High Availability Solutions:Setup, maintenance, monitoring of RAC on ODA with two nodes, standby/active data guard with nodes, standby DG at DR site with nodes, ASM, Snapshot Standby, DG Broker, OEM 12c.Database Diagnostics and Tuning:Database and query tuning by OEM 12c, Diagnostic &Tuning pack, AWR, ADDM, ASH,Sqlt, etcDatabase Backup and Recovery Strategies and Procedures: Database weekly full backup, daily incremental backup, restore/recovery/refreshDatabase Support for Software release:Database design, development, deployment and support for software/apps release.Database Security and Access:Database access rights, security, profiles, roles, password management, encryption, wallet, SOX, auditing and baselines.Database Installation and Patches:ODA/Database patches, OEM patches, etc.Database Space Utilization: Management and tracking of space utilization of databases.MySQL:MySQL installation, setup, database creation, objects creation, backup/restore, security, active/passive replication, DR, monitoring, maintenance, support, etc without AWS & with AWS.MS SQL Server:MS SQL server installation, cluster, high availability setup, database creation, objects creation, backup/restore, security, replication, DR, monitoring, maintenance, etc.NoSQL/MongoDB: setup, maintenance, administration.Hadoop:Installation and setting up of Hadoop 2 on two nodes cluster.

Mendota Heights, Mn, Us

Reporting to CIO and mentoring/leading highly motivated DBA team members and providing technical leadership with solid hands-on experience. Responsible for database design/architect, development, management, administration, availability, scalability, reliability, security, maintenance, support and business requirements activities for production, staging and development databases on 24x7x365 basis for Business Software Systems, Operations, Engineering, Customer Support and MIS/DWH departments of SasS company.• Customer Care Support and Escalation: OPS on Call (on rotation basis) • Database Fail-over/High Availability Solutions: Oracle Data Guard/Active DG, Golden Gate Replication, Advanced, Streams• Database Migration/move: From Sun StorageTek Disk to NetApp Disk • Database Server Migration: From Sun E2900 server to Sun T5-4 server by presenting disk/LUN in NetApp storage• Database Diagnostics and Tuning: • Monitoring of database status and performance by Scripts/Cron jobs/Tools• Automatic generation of DB AWR reports by cron job• Centralized server for all cron jobs of all DB servers• Tuning of database Performance like database Memory/IO/CPU tuning, Contention/Locking, Waits, SQL/PL/SQL tuning by using Scripts/Cron jobs/Tools• Database Table and Index Partitioning and maintenance• Database Backup and Recovery Strategies and Procedures:• Hot/Online backup by RMAN, catlogdb, FRA, Cold & Export/Data Pump backup • Database Recovery strategies & procedures• Database Cloning: Database refresh/cloning by RMAN• Database Support for Software release: Database design/development/deployment• Database Security and Access• Data Archival/Purge• Database Space Utilization: Management/tracking• Database Upgrade and Migration• Materialized views for MIS/DWH - BI Tools: Pentaho/Data Source/Microstrategy • MySQL: Installation/setting up of MySQL• MongoDB: Installation and setting up of MongoDB• Co-ordination with software developers/testers/OPS/customer care

Covington, La, Us

Responsible for database design/architect, development, management, administration, availability, scalability, reliability, maintenance, support and business requirements activities for production, staging/test and development for Production, Lab/Test and Development Databases on 24x7 basis for Business Software Systems, Engineering Ground Operations Control Center, Globalstar Systems Planning Center, Accounting Finance & Billing, Data Warehouse departments.Summary of qualifications: -Mentoring/managing/leading DBA team members-Well and in-depth experience in Management/Administration, Tuning, Development and Support of very large volume and multiple Databases in Production, Lab/Test and Development environments on 24x7x365 basis-In-depth experience in Database Design, Installation, Upgrade, Patches, Migration, Cloning, Partitioning, Data Archival, Data Load, Backup & Recovery by scripts/RMAN-Broad experience in Fail-over/High Availability solutions like Replication (Advanced/Multi Master, Basic, Hot Standby, Streams), GoldenGate, Data Guard (Physical and Logical), Active Data Guard, Snapshot Standby, Real Application Cluster (RAC), ASM-In-depth experience in Diagnosing and Performance Tuning of Database: Memory, I/O, CPU, Contention, Locking, SQL, PL/SQL, Applications, Database Grid Control, AWR, ADDM, SPA, Tkprof, Sqlt-Database SOX Compliant, Auditing, OS, Applications Baselines-Strong experience in Oracle databases on UNIX, Linux and Windows environments.-Experience in Administration and Support of Systems, Applications and Software Development -Strong communication and analytical skills with very good experience in problem solving.-Management/administration of Apps DBA activities-Also worked for MySQL,PostgreSQL and MS SQL Server Database Administration activities

Clients: Per-Se Technologies, San Jose, CA, NetForce Inc, San Francisco, CA, Quantum Corporation, Colorado Springs, CO Responsible for Oracle Database Management/ Administration activities for development, test and production databases at different client sites.

Reston, Virginia, Us

Project/Client: Reliance Refinery Project for Reliance Petroleum Ltd. (RPL), Jamnagar, India Magic-World Theme Park Project, Dubai, UAE, Redhill/Millennium Power Project, Philippines.Responsibility: Oracle DBA/ Automation Technologist.Responsible for Oracle Database Management/ Administration activities for development, test and production databases for different projects/sites.