Sql Server Database Administration
Resume:
Fereydoon Hamidi
********@*****.***
Summary:
Over 15+ years of experience in Database Administration and Developer for very large and complex databases SQL Server 2000 – 2019.
Programing language (VB .NET, C sharp .NET, FoxPro, PHP, Python, JAVA, ASP .net, HTML)
NoSQL database (Mongo DB, HBASE)
Hadoop Ecosystem
Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
SQL server HA (FCI, AG), Log shipping, Replication, Mirroring
Windows server Failover Clustering
Oracle virtual box
Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
Expertise in T-SQL writing stored procedures, triggers and functions.
Administering SQL Server High Availability and Disaster Recovery strategies.
Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
Experience in Disaster Recovery Planning and Security Management operations.
Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
Troubleshoot performance problems, fine-tuning of databases and index Analysis.
Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
Data Warehouse (SSIS, SSAS,SSRS).
Power BI Suite.
ODI (Oracle Data Integrator)
Informatica
Microsoft Azure
EPIC Clarity
EPIC Caboodle
EBS
QlikView, PowerBuilder
Oracle's E-Business Suite
SQL Server Migration Assistant (SSMA) for Oracle .
Technical Education
BS Computer Engineering, South Tehran Azad University, Iran,1994
Microsoft Certified Professional (MCP)
MCSA (SQL Server 2012 )
CompTia A+
CCNA
Epic Clarity
Technical Expertise
Databases:
MS SQL Server 2000-19, Oracle 8i, 9i (9.2.0.5, 9.2.0.6), 10g, 11g, MySQL, ODI, PostgreSQL,
Programming:
Python, PHP, R, Visual Basic, VB .NET, C, C++,C# .net, Java, JavaScript, Visual FoxPro .NET, Visual Studio 2019,
DBA:
database administration of MS SQL Server 2008, 2014
Operating System:
Windows 2008/2016 Advanced Server, NT & Windows 10, 7, Linux
BI Tools
Power BI, Power Apps, Microsoft Teams Apps, SharePoint, Power Automate, Tableau
Reporting Tool
SSRS, Jasper Studio, Crystal Report
ETL Tools
MS SQL SSIS, Python
Professional Experience
Title : Information Technology Specialist III
Client : Virginia Employment Commission
Duration : August 2021 to Feb 2025
Responsibilities
Design, Develop and maintain secure, consistent and reliable ETL solutions supporting critical business processes across the various Business Units.
Ensure data solutions are compliant with enterprise security standards.
Work in complex multi-platform environments on multiple project assignments.
Develop and perform tests and validate data flows and prepare ETL processes to meet complex business requirements, including designing and implementing of complex end-to-end solutions using BI platforms.
Coordinate with analysts and developers to ensure jobs designed and developed meet minimum support standards and best practices before migration into the production environment.
Partner with various infrastructure teams, application teams, and architects to generate process designs and complex transformations to various data elements to provide the Business with insights into their business processes.
Uses strategies such as Indexing and partitioning to fine tune the data warehouse and big data environments to improve the query response time and scalability.
Define and capture metadata and rules associated with ETL processes.
Assist production support team in providing resolutions to production job failures, data issues and performance tuning
ETL Development and Process Support.
Strong understanding of Data warehousing (Dimensional Modeling, ETL etc.) and RDBMS concepts.
Experience with Talend ETL tool, SQL, Stored Procedures and Table Design.
Experience in SQL Query optimization and ETL Data loading Performance.
Experience in Hadoop Platforms on components like HIVE, KAFKA, NiFi, Spark.
Experience in Snowflake Cloud Data warehouse.
Experience in shell scripting.
Experience with cloud technologies (AWS, Azure, GCP).
Experience with Azure Data Factories, SSIS, Azure Synapse Analytics and Azure Stream Analytics.
Title : Application Database / Datawarehouse Developer
Client : University of Florida (Urban Regional Planning)
Duration : September 2020 to September 2021
Responsibilities
Design, Develop and maintain secure, consistent and reliable ETL solutions supporting critical business processes across the various Business Units.
Ensure data solutions are compliant with enterprise security standards.
Work in complex multi-platform environments on multiple project assignments.
Develop and perform tests and validate data flows and prepare ETL processes to meet complex business requirements, including designing and implementing of complex end-to-end solutions using BI platforms.
Coordinate with analysts and developers to ensure jobs designed and developed meet minimum support standards and best practices before migration into the production environment.
Partner with various infrastructure teams, application teams, and architects to generate process designs and complex transformations to various data elements to provide the Business with insights into their business processes.
Uses strategies such as Indexing and partitioning to fine tune the data warehouse and big data environments to improve the query response time and scalability.
Define and capture metadata and rules associated with ETL processes.
Assist production support team in providing resolutions to production job failures, data issues and performance tuning
ETL Development and Process Support.
Strong understanding of Data warehousing (Dimensional Modeling, ETL etc.) and RDBMS concepts.
Experience with Talend ETL tool, SQL, Stored Procedures and Table Design.
Experience in SQL Query optimization and ETL Data loading Performance.
Experience in Hadoop Platforms on components like HIVE, KAFKA, NiFi, Spark.
Experience in Snowflake Cloud Data warehouse.
Experience in shell scripting.
Experience with cloud technologies (AWS, Azure, GCP).
Experience with Azure Data Factories, SSIS, Azure Synapse Analytics and Azure Stream Analytics.
Title : Senior Database Engineer
Client : University of Maryland (School Of Medicine) Baltimore, MD
Duration : November 2015 to Feb 2020
Responsibilities
Using Microsoft DevOps for code management tools.
Developed SAS table templates and coding protocol to process and analyze clinical trial data.
Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing.
Build and automated Power BI reports.
Created multiple Canvas Apps in Power Apps synced with Power Automate.
Created Multiple Notification Flows using Power Automate.
Experience in developing new Power Apps model and canvas driven apps as well as enhancing existing apps.
Develop and implement SharePoint applications.
Design SharePoint environments.
Manage SharePoint accounts as necessary.
Create report from EPIC Clarity
Develop Application with Python.
Writing Script to load data to database (PHP, PYTHON).
Strong technical knowledge in SQL Server BI suite (ETL, Reporting, Analytics, Dashboards) using SSIS, SSAS, SSRS and various 3rd party tools.
Designed and developed table structures, stored procedures, and functions to implement business rules.
Generated PL/SQL and Shell scripts for scheduling periodic load processes.
Designed and Created the Process flows, ER-Diagrams, High Level architecture diagrams.
Designed and developed complex Interfaces using oracle data integrator (ODI) that involved Slowly Changing Dimensions, Error handling, SCD types, Golden gate Change Data Capture and Business logic implementation.
Created ODI design documents from the existing Informatica mappings.
REDCap
Optimize database systems for performance and reliability.
Perform database maintenance and troubleshooting activities.
Test database systems and perform bug fixes.
Develop database functions, scripts, stored procedures and triggers to support application development.
Provide technical assistance to resolve all database issues related to performance, capacity and access.
Ensure data integrity and quality in database systems.
Maintain standard policies for database development activities.
Identify and rectify database errors in a timely manner.
Create physical and logical database models as per the business requirements.
Prepare documentation regarding database design, configuration, and change management tasks.
Mentor database administrators to manage the company databases effectively.
Perform data back-up and archival on regular basis.
Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and Data Stage and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.
Team player with excellent communication and problem-solving skills.
Using C sharp to create windows application and connect to database(MySQL, MS SQL Server, PostgreSQL).
Title : Senior IT Specialist
Client : Commonwealth Catholic Charities (Over than 300 client and state wide branch), Richmond, VA
Duration : November 2013 to May 2015
Responsibilities
Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) and SSAS.
Create winform with VB .Net and C# .net .
Rebuilding / Monitoring the indexes at regular intervals for better performance.
Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).
Expert in implementing the snapshot isolation and DDL triggers.
Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).
Coded Oracle PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
Environment: Oracle PL/SQL, SQL Server 2008/2012 Enterprise, Windows Server 2008, windows XP, Windows 7, .NET, Microsoft SharePoint, Crystal Report.
Title: Senior SQL Server Developer with SSIS Data Warehouse
Client : Red (Cross) Society (Pharmacy Distribution branch with over 400 staff)
Duration : September 2010 to September 2013
Responsibilities
Perform business analysis, technical analysis, systems design, application software programming.
Restructuring the stored procedure,designing, coding and developing the same using the T_SQL Programming .
Programing with VB .Net to create winform .
Transferring the data (ETL) to Data warehouse by SSIS.
Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
Managed the migration of SQL Server 2000 databases to SQL Server 2005.
Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
Rebuilding the indexes at regular intervals for better performance.
Rebuilding the indexes at regular intervals for better performance.
Expertise in SQL Server Reporting Services and SQL Server Analysis Services.
Complete documentation about the database. Recovering the databases from backup in disasters.
Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.
Data conversion from flat file to intermediate tables using SQL*Loader,Data mapping
Worked on various backend Procedures and Functions using Oracle PL/SQL
Environment: Oracle PL/SQLSQL Server 2008/2005, .Net Framework 2.0, C#.Net, JavaScript,, Windows 2000, Windows 2003 Server, MS-Access.
Contact this candidate