Learn Data Skills
Beta
Afroze Mohammed

Afroze Mohammed

Senior SQL Database Admin

NA | Texas

Technologies

My Portfolio Highlights

My New Course

Introduction to SQL

My New Course

Introduction to SQL

Insights whisperer, uncovering hidden gems in the vast realm of information.

My Work

Take a look at my latest work.

course

Understanding Data Engineering

course

Introduction to SQL

course

Intermediate SQL

course

Understanding Data Engineering

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Intermediate SQL
Joining Data in SQL

My Work Experience

Where I've interned and worked during my career.

Heidelberg Materials North America | Mar 2016 - Apr 2025

Senior Database Administrator

N/A

Data Transformation Corporation | Aug 2007 - Jul 2015

Senior Software Engineer

Responsibilities: Administered multiple SQL instances in production, test, and development environments. Monitoring table, disk utilization, and database fragmentation on a daily basis. Designed and maintained business continuity/disaster recovery procedures for databases Consolidated and virtualized dozens of SQL servers Reviewing, planning, testing and installing database security patches and service packs. Design, document, and promote security "best practices", policies, standards and protocols. Migrating application code and objects from development/test environments to production. Working with development and systems teams to perform application and database tuning. Migrating Databases from MS Access and SQL Server 2000/2005/2008 to SQL Server 2008 R2 / 2012. Implemented and maintaining database and application monitoring. Implemented new SQL Server 2012 features like Always On, data compression, Contained Databases, etc. Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc. Evaluating and implementing data modeling, database administration, and database backup and recovery tools. Setting up and monitoring transactional and snapshot replication, database mirroring, log shipping. Review of physical and logical database design Creating processes and procedures for application code and database object migrations. Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS). Evaluating applications performance and optimizing applications by tuning insufficient queries. Creating complex stored procedures, triggers, cursors, tables. Preparing various reports on SQL servers health for management. Daily routine DBA tasks (maintenance, optimization and backup jobs) 24x7 Production Database on Call Support
Show More

Data Transformation Corporation | Feb 2004 - Jul 2007

Software Engineer

Responsibilities: Maintained database objects like Stored Procedures, Functions, Triggers, Indexes and Views using T-SQL in SQL Server 2005 Involved in performance tuning of the database and T-SQL queries using Execution Plan. Designed reports using SQL Server 2005 reporting services. Involved in performance tuning of the database and T-SQL queries using Execution Plan. Good experience in Debugging Stored Procedures and Triggers and Troubleshooting database issues. Performed administrative activities like creating User logins with appropriate roles, granting and denying login privileges, monitoring the user accounts, creation of groups, granting database and application roles to users and groups. Good experience with creating alerts, schema management, database reorganization, data loading, database maintenance and optimization. Performed Backups and restored databases Configured Log shipping to create standby environment. Worked on Linked and Remote Servers to run queries between SQL server and other data sources using ODBC, OLE DB drivers. Recovering the databases from backup in disasters. Implementing Point-In- Time Recovery solutions Experienced in optimizing the database by creating various clustered, non- clustered indexes and indexed views Environment: MS SQL Server, TSQL, SQL Server Integration Services, SQL Server Reporting Services 2005, Enterprise Manager, Query Analyzer, Windows Server 2003.

Manpower | Sep 1999 - Feb 2004

Software Engineer

Involved as part of a team in the design, development and testing of various software applications. Responsibilities: Designed and developed user interface in Java for a 32-bit client and web pages in Perl for the web client. Developed software modules and functions as part of maintenance and enhancements to the DUAT and OASIS applications. Environment: HP-UNIX, C, SQL Server, TSQL, Socket programming, JAVA, Perl, JavaScript, HTML, Visual Café, Windows NT

My Education

Take a look at my formal education

Master’s Degree, Computer Science in Computer ScienceCity University of New York-College of Staten Island | 2000
BE, Electronics and Communications Engineering in Electronics and Communication EngineeringOsmania University | 1996

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free