Abid Sadiq

**** ****** **, ********** **, ***** : advcwg@r.postjobfree.com

Summary

Has professional experience as an application, web developer, middleware software and Database Administrator. Effective multi-tasker with a positive outlook. A team player, who is also adept at tackling solo projects. Able to see the big picture while attentive to details. Self-starter—able to address tasks with a minimum of supervision and able to manage workloads under tight deadlines. Quick to acquire new skills and adapt to new technologies. Excellent written and verbal communications skills.

Experience and Skills:

Since 1994, I have been employed as a contractor at the Department of Transportation. I am currently employed by SAIC.

Currently a Database Administrator in a SQL Server, Oracle, MySQL and NoSQL database environment. I have been a DBA since 2002 and play a key role in DOT database management. My responsibilities include the following:

Install and configure database instances, applying all the security rules of DOT.

Patching these instances on a regular basis.

Write scripts that set alarms if any of the databases are down.

Refresh Non-production databases on regular basis.

Install and configure SQL Server Always on Availability Group.

Database mirroring.

Can sync databases between Azure and on premises databases.

Performance management and tuning SQL queries.

Administrator of SAP Business Object, BMC Control-M and Power BI.

Install and configure Azure SQL Managed Instance Server and Azure Synapse Analytics Data Warehouses.

I have extensive experience with .NET, Java and VBScript, JavaScript, PowerShell, Python, TSQL and Oracle SQL. I have a thorough knowledge in ETL services and have written ETL packages (SSIS) on the premises and for the cloud using Azure Data Factory. I have strong expertise in SAP Business Objects and BMC Control-M scheduling software.

Some of my past accomplishments include the following:

Designed data models for the new application and improved the existing models.

Designed survey systems (HSIP), Financial system FMIS (Fiscal Management Information stem), TMAS (Travel Monitoring Analysis System). VSW (Vehicle Size and Weight Enforcement). FAF (Fuels & FASH). Partition tables and Some of these database tables has more than 10 billion records. Now these databases are moving to the Azure cloud.

Partition tables and manage GIS data.

Migrated databases to Azure Cloud and on AWS cloud.

Migrated Oracle 12 C databases to Oracle 19C.

Expert in Oracle OEM

Expert in Control-M (scheduling tool)

Operating Systems: Windows, UNIX and Linux

Employment History

The following are all contracting companies that provided service to the Department of Transportation

SAIC, Senior DBA, 07/20– present

ActioNet, Senior DBA, 04/18– 07/20

Sevatec, Senior DBA, 04/13–04/18

Indus Corporation, DBA, 05/02–04/13

Signal Corporation, Senior Systems Analysts, 03/97 – 05/02

Anstec Inc, Systems Analyst, 08/94–03/97

•RMS & Associates, Inc. Programmer, 04/92 – 08/94

•NCCS Consultant, Consultant, 08/83 -04/92

Education

•BSc, Lander University, SC Greenwood, 05/1983.

•Taken and completed numerous training courses (including course related to cloud).

Security Clearance

•Security Clearance: Position of Public Trust (SF-85P)

Citizenship

US Citizen

Projects done at the Department of Transportation (1994 – present)

Migrated databases to Azure Cloud and on AWS cloud

- Created Azure SQL Managed Instance, Azure SQL Database, Azure Server Elastic Pool databases, installed SQL Server Instance on Azure VM; and provide ongoing management of them

- Migrated several databases from on-premises to the Azure cloud. Addressed migration issues and successfully solved them (such as the number of files in a database, SSIS packages). Worked closely with the Microsoft team on the migration issues.

- Created the SQL Server high availability on Azure VM instances. Have extensive expertise on Azure Data Factory.

- Created the databases sync between on premises and cloud.

- On AWS, I have migrated the SQL Server and Oracle databases to EC2 servers.

VTRIS – Detail available - https://www.fhwa.dot.gov/ohim/vtrisdoc.pdf

Design the database (Oracle - Coded the data entry screen in C# and reports are done in Crystal reports)

HPMS – Detail information about the system - https://www.fhwa.dot.gov/policyinformation/hpms.cfm

Initially design the database in Oracle but later converted to SQL Server – This database includes GEO tables too. Some tables have more than 3 billion records. Tables are partition on 2 keys, year + state. SSIS packages are included in this software for ETL. Established the database mirroring.

FMIS – FMIS is FHWA's system for managing federally funded highway projects within the Federal-aid Highway Program. Staffs of FHWA Division Office and State DOTs are assigned FMIS access and levels of project approval authority. Established the database mirroring.

https://www.transportation.gov/mission/budget/financial-management-and-information-systems

The system converted from main frame to Oracle and now it is in SQL Server database.

I was team member of these conversion teams.

System in OLTP and accessible through browser. The database has Geo information too.

The coding done C# and reports are designed in Business Object.

TMAS – Detail information - https://www.fhwa.dot.gov/policyinformation/tmguide/

Size of the database is > 2 TB. Batch processing system. Reports are design in HTML. Coded in C#. Database is in SQL Server and mirrored. SSIS packages are included in this software for ETL. Established the database mirroring. We are moving this application to cloud and moving the data to Azure Synapse Analytics Data Warehouse.

MFASH – Detail information - https://data.amerigeoss.org/sr_Latn/dataset/motor-fuels-and-financial-analysis-system-for-highways-fuels-fash-d1145

Database is in oracle. Coded in C# and reports are in Crystal Report writer.

NBI – Detail Information - https://www.fhwa.dot.gov/bridge/nbi.cfm

Application coded in C# and Database is in Oracle and reports are designed in Business Object and HTML, database tables are partitioned.

UPACS – Detail information - https://fhwaapps.fhwa.dot.gov/upacsp/tm?transName=MenuSystem&action=buildHTML

Application coded in Java, database is in Oracle.

HSIP – Designed the database – Detail information https://safety.fhwa.dot.gov/hsip/

Application coded in C#, reports design in Business Objects.

Remedy – BMC software and database installed on SQL Server. Has Failover cluster and HA.

Web databases – A lot of small databases for inhouse – Cold Fusion, MySQL. NoSQL (MongoDB)

Has worked on inhouse small applications too.

BMC ControlM administrator

SAP Business Object administrator and Power BI.

Has knowledge in PowerShell scripting, can automate day to day databases maintenance jobs.

Currently maintaining more than 10 Fail over Cluster (SQL Server, Oracle).

Backup, Restore, Rebuilding the indexes, Performance tuning etc.

1983 – 1992

Lead the software house and did a lot of projects as consultant.

Financial system – Payroll, General ledger, Bank deposit and withdrawal program for the cashier.

Book inventory, FIFO inventory, etc.

Contact this candidate