Pramod Kasi Email Address

Lead SQL Server Database Administrator

MARTA was created in 1965 to provide safe, convenient and reliable transit service for the Metro Atlanta region.\r\n\r\nMARTA is the 9th largest public transportation system in the US and North America operating bus, rail and paratransit service for more than 430,000 passenger trips every week day. \r\n\r\nMARTA is primarily funded by a 1% sales tax levied by our member jurisdictions - the City of Atlanta, Clayton and DeKalb counties. \r\n\r\nMARTA is vital to the success of metro Atlanta's economy, the preservation of our environment and the quality of life in our region. According to a University of Georgia study, MARTA is responsible for about $2.6 billion in economic activity every year.

• Experience in Production Support and Database Administration using Microsoft SQL Server 2019, 2017, 2014, 2012, SQL 2008 R2, 2008, 2005, 2000 and 7.0. •Implemented Always On Availability Groups. (MSSQL Server 2017, 2014 and 2012) •Implemented AWS (Amazon Web Services), expertise in migrating on-Premises SQL to RDS,EC2. Implemented Audit solutions using Athena, SNS topics, S3. Worked gitlab, cdkbricks, Terraform, Bespin process CI/CD , deployed EC2 instances, modified EC2 instances for cost savings, added FSX storage and modified throughout values using CI/CD. Worked on Cloudwatch, deployed metrics collection for performance tuning and optimisation and used Aws systems manager service. Migrated to Azure VM’s from on-prem to Azure. •Experienced in creating and maintaining SSIS packages, created reports using SSRS. • Managing SharePoint 2013 and SharePoint 2010 SQL Server 2008R2, Installed and Configured Active\Passive Clustering windows 2008 Stretch Clusters for High Availability SharePoint. and Installed SQL Server 2008R2 in Clustered Environment. •Managed SSAS. •Implemented MSSQL Server fail over clustering, Log shipping, Database Mirroring and Replication. •Experienced in T-SQL, SQL* Plus. Developed and optimized stored procedures, triggers, functions, cursors and ETL packages. •Experienced with Windows system administration. •Basic knowledge of TCP\IP network troubleshooting. •Experienced in creating and maintaining SSIS packages, created reports using SSRS. •Experienced on monitoring tools like Microsoft Systems Center Operations Manager (SCOM) and Microsoft Operations Manager (MOM). •Working experience on Data Warehousing and Business Intelligence. •Experience in creating and maintaining Disaster recovery processes. •Experience in extracting and transforming MSSQL data using DTS Import Export Data, Bulk Insert, BCP and DTS Packages, configuring XML support in IIS. •Experience in Healthcare, Financial, Pharmaceutical Transportation and Communication Industries •Experience in logical and physical data modeling using Erwin. •Ensured databases are secured and SOX complaint. •Posses strong analytically and Project Management Skills, Good Leadership skills and Communication skills. Specialties: Azure administration, Azure user management, Azure Storage , AWS database migration, Managing S3, EC2, routing tables, cloud front , Database Replication, Mirroring, log shipping, Clustering Services, CDC, SSRS and SSIS in SQL Server 2017, 2014, 2008R2 2008,2005 and DTS in 2000 MSSQL.