Shafir Rahman
Senior Database Administrator & System Administrator at Jevin Inc- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
0
/5.0 / Based on 0 ratingsFilter reviews by:
Experience
-
Jevin Inc
-
Software Development
-
1 - 100 Employee
-
Senior Database Administrator & System Administrator
-
Apr 2021 - Present
- Administrator, optimize, and maintain SQL Server 2016 environments - Implement automated index rebuild, statistics update, and backup maintenance solution - Administrator, Troubleshooting issues, Maintain Windows Server 2012 environments - Administrator, optimize, and maintain SQL Server 2016 environments - Implement automated index rebuild, statistics update, and backup maintenance solution - Administrator, Troubleshooting issues, Maintain Windows Server 2012 environments
-
-
-
Shirtee.com | Shirtee.Cloud
-
Germany
-
Technology, Information and Internet
-
1 - 100 Employee
-
Senior Database Administrator & SQL Developer
-
Nov 2020 - Present
SQL Server Database Administrator | Business Intelligence Developer, working on a daily basis in SQL Server 2000-2019 environments, which support requirements for over 128 countries. Experience and responsibilities include the following: o Manage immensely Business integral and mission-critical Microsoft Dynamics AX ERP Databases, Business Intelligence Databases, Macola Progression Databases, Microsoft SharePoint Databases, etc. o Methodically identify and resolve complex underlying causes of Microsoft SQL Server problems, using a vast variety of techniques and tools o Business Intelligence Architecture via Developing with the MSBI Stack (Power BI, SSIS, SSRS, SSAS) o Write ETL scripts and job to extract data from numerous heterogeneous data sources, Update the data in Staging Tables, then Load the data into Fact and Dimension Tables for Reporting o Reduced an existing ETL process execution time from 8 hours to 20 minutes, providing a drastic down time window for system patches, upgrades, etc. o Develop T-SQL Stored Procedures used to query data within Business Intelligence Databases to provide data for DATAZEN Mobile BI Analytical Dashboards and KPIs o Azure SQL Database o SQL Server Development (Complex Queries, Stored Procedures, Dynamic SQL, Functions, Parameterized Queries, Index Creations, etc.) o Create and/or update SQL Server Objects (tables, views, indexes, Columnstore indexes, stored procedures, functions, etc.) o Performing DBA duties including: SQL Server installations, database backups, database restores, creating maintenance plans/jobs, performance tuning, implementing/maintaining Database security, and capacity analysis o Proactively monitor the database systems to ensure secure services with minimum downtime Show less
-
-
-
Freelancer.com
-
Australia
-
IT Services and IT Consulting
-
1 - 100 Employee
-
SQL Server Developer Freelancer
-
Mar 2020 - Present
SQL Server DBA, Database Development, Data Warehouse Development, Business Intelligence, and Training Consulting Services. SQL Server DBA, Database Development, Data Warehouse Development, Business Intelligence, and Training Consulting Services.
-
-
-
Upwork
-
United States
-
IT Services and IT Consulting
-
300 - 400 Employee
-
SQL Server Freelancer
-
May 2019 - Present
-
-
-
QTMS by AAA Communications
-
United States
-
IT Services and IT Consulting
-
1 - 100 Employee
-
SQL Server DBA & SQL Developer
-
Apr 2019 - Present
- Administer, optimize, and maintain SQL Server 2005, 2008, 2012, 2016 environments - Develop SSIS packages to automate ETL procedures and data processing - Design SSAS data warehouse and partitioning strategy to perform analytics and reporting - Create standard parameterized SSRS reports utilizing subscriptions for report delivery - Implement automated index rebuild, statistics update, and backup maintenance solution - Administer, optimize, and maintain SQL Server 2005, 2008, 2012, 2016 environments - Develop SSIS packages to automate ETL procedures and data processing - Design SSAS data warehouse and partitioning strategy to perform analytics and reporting - Create standard parameterized SSRS reports utilizing subscriptions for report delivery - Implement automated index rebuild, statistics update, and backup maintenance solution
-
-
-
-
SQL Server DBA & Business Intelligence Developer
-
Apr 2012 - Present
SQL Server DBA & Business Intelligence Developer with extensive experience in all versions of SQL Server 2000 - 2019, supporting requirements for over 128 Countries Globally. SQL Server DBA & Business Intelligence Developer with extensive experience in all versions of SQL Server 2000 - 2019, supporting requirements for over 128 Countries Globally.
-
-
-
New Universe Coporate Clothing (PVT) Ltd.
-
Sri Lanka
-
Retail Apparel and Fashion
-
1 - 100 Employee
-
IT System Administrator & Network Administrator
-
Mar 2015 - Aug 2017
Developed and produced custom SQL queries, as well as reports within the SCCM SQL server database. Managed 6,000+ Windows Machines and 1,500+ Apple devices. Installed, configured, and maintained all network infrastructures across 23 locations including Avaya and Nortel Systems. Administered over 60 Windows 2003, 2008, 2008 R2, 2012 and Mac servers consisting of both physical and Microsoft Hyper-V virtual. Proactively monitored web traffic via Barracuda Web Filter. Developed and produced custom SQL queries, as well as reports within the SCCM SQL server database. Managed 6,000+ Windows Machines and 1,500+ Apple devices. Installed, configured, and maintained all network infrastructures across 23 locations including Avaya and Nortel Systems. Administered over 60 Windows 2003, 2008, 2008 R2, 2012 and Mac servers consisting of both physical and Microsoft Hyper-V virtual. Proactively monitored web traffic via Barracuda Web Filter.
-
-
-
-
LAN Service Technician
-
May 2007 - Aug 2008
Troubleshoot and repair all technology-based equipment at 23 locations, which includes 7,500+ machines. Installed, repaired, maintained, and upgraded desktops, laptops, printers, VoIP phones, access points, projectors, iPads, and many other devices as well. Assisted staff and students with technology equipment. Served a leading role in migrating numerous schools from Windows XP to 7. Led and completed numerous projects, as delegated from Management. Resolved 2,000+ end user support tickets. Troubleshoot and repair all technology-based equipment at 23 locations, which includes 7,500+ machines. Installed, repaired, maintained, and upgraded desktops, laptops, printers, VoIP phones, access points, projectors, iPads, and many other devices as well. Assisted staff and students with technology equipment. Served a leading role in migrating numerous schools from Windows XP to 7. Led and completed numerous projects, as delegated from Management. Resolved 2,000+ end user support tickets.
-
-
Education
-
ESOFT Metro Campus
Bachelor of Science (B.S.), Computer science -
ESOFT Metro Campus
Bachelors, Bachelor of Engineering (B.Eng.), Software Engineering