Sql Server Data

ALI NASEER

SQL Server Database Administrator

Itasca, IL 470-***-**** ****.******@*****.*** linkedin.com/in/ali-naseer/

Experienced SQL Database Administrator skilled in High Availability (HA) and Disaster Recovery (DR) options. Expertise in Production Servers with server configuration, performance tuning and maintenance with outstanding trouble-shooting capabilities. Creative approach to problem-solving with the ability to focus on details while maintaining the “big picture”.

SKILLS

Databases: MS SQL Server 2014, 2012, 2008, 2005, Redshift

Programming: SQL, C#.NET, JavaScript, HTML

DBA: Database Administration of MS SQL Server 2014, 2012, 2008, 2005

Operating System: Windows Server 2008R2 / 2012, Windows XP, Windows 7, Windows 8, Windows 10

Tools: SAN, Visual Studio 2008, 2012, SSRS, SSIS

Other: Index Management, Knowledge Writing TSQL

PROFESSIONAL EXPERIENCE

Discovery Health Partners

SQL Database Administrator 2018 - Current

Comply with HIPAA Compliance and Security Policies and Procedures.

Develops a methodology for the ongoing assessment of database performance and the identification of problem areas.

Develops a security scheme for the database environment, as well as assisting in disaster recovery if necessary.

Provides leadership during the development and enhancement of production applications including working with applications, technical support, and operations during the design, development, and implementation of applications.

Work with the transaction processing area to develop both the physical and the logical database administration functions and assists in the development of our processing database and computing environments.

Work with others in IT to build a logical database area and provide technical guidance during all phases of the development process.

Work with vendors in evaluating and implementing new technologies.

Transaction processing environment for capacity assessment and planning.

Experience working with Windows server, including Active Directory.

Working on AWS Cloud Servers and make sure all backups are moved to S3 bucket to store historical backups in case of any Client needs.

Experience in Redshift, to import Data for company Data Scientist to Analyze the client Data.

M3 ACCOUNTING + ANALYTICS 2014 - 2018

SQL Database Administrator

Collaborated with NetOps to design and implement process to securely copy data from production domain to QA or Dev Domains for testing, resulting in improved productivity, efficiency and security.

Installed and supported SQL Server Database, ensuring their performance, availability and security.

Developed and created stored procedures, advanced queries, triggers, view and functions for databases.

Pro-actively monitored database systems to ensure secure services with minimum downtime.

Implemented and released database changes as submitted by the development team.

Created SSIS/SSRS packages.

Developed and implemented security and non-security patches based on company approved maintenance schedule.

Collaborated with team to ensure that associated hardware resources were allocated to the databases, providing for high availability and optimum performance.

Provided database performance testing, capacity planning, SQL server clustering, database security configuration and database continuity.

Worked on SAN for Data Replication and make sure all Database backup volumes are available.

CONTRACT POSITIONS 2013 - 2014

Project Manager (AT&T)

Created and ran multiple existing retention and transfers Business Object queries daily/weekly/monthly; prepared reports in Excel using Pivot Tables to show results.

Developed expertise in the logic utilized in existing Business Objects queries; edited and created new queries as required.

Utilized .NET, ASP, Visual Studio, SQL 2008R2, SSIS/SSRS to develop a website and display multiple of their existing reports online for the field to use.

Contractor (Amazing Herbs)

Installed SQL Server 2008 / 2012 on Windows 7 and Windows Server 2012.

Created database and database objects including tables, stored procedures, views, triggers, rules, defaults, user-defined data types and functions

Utilized SSIS to produce a data warehouse for reporting.

Conducted code-walkthroughs; reviewed peer code and documentation

Designed SSIS packages to extract, transfer and load (ETL) existing data into SQL Server from different environments.

Provided client with a cohesive approach to creating, ordering and managing materials with a single point of access to all documents.

SQL Server/ETL Developer (Chick-Fil-A, Inc.)

Designed and developed SSIS packages, store procedures, configuration files, tables, views and functions; Implemented best practices to maintain optimal performance.

Used Visual Studio 2012 to create web pages on ASP.Net under C#. Created user web configuration to ensure web page privacy.

Produced Data Warehouse for reporting utilizing SSIS (SQL Server Integration Services)

Prepared reports in SQL Server Reporting Services (SSRS).

Implemented complex transformations by creating custom transformation processes and utilizing built-in procedures.

PLUS MATERIALS 2010 – 2013

SQL Database Administrator

Installed SQL Server 2005 / 2008 on Windows 7 and Windows Server 2008R2; applied service packs and security fixes.

Created database and database objects including tables, stored procedures, views, triggers, rules defaults, user-defined data types and functions.

Implemented DBCC consistency checks; corrected data corruption in user databases.

MALANI, INC 2006 – 2010

Stored Procedures, user-defined functions, view, TSQL scripting for complex business logic.

Utilized Joins and sub queries to create complex queries involving multiple tables from different databases.

Optimized the database by creating various clustered, non-clustered indexes and indexed views

EDUCATION

London School of Advanced Studies, London, UK

B.S. Computer Science, 2005

East London University, London, UK

Certificate in Business Information Systems, 2006

Contact this candidate