Sql Server Us Citizen

Quadeerullah Mohammed

SUMMARY OF QUALIFICATIONS:

Over 15 years of experience in database administration and architect for very large and complex databases in SQL Server 2022/2019/2017/2016/2014/2012/2008R2

Strong T-SQL programming skills.

Performance Tuning SQL Server environment and Query Tuning expert.

Dynatrace and Solar wind monitoring experience.

Migrating on prem to AWS and Azure

Support and Administer AWS/Azure

Strong Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools. Performing Database Health Checks.

Experience with backups, restores and recovery models

Thorough understanding of best practices in SQL security

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server

Experience working with Windows Server, including Active Directory

Well versed in HADR strategies including database replication, failover clustering, database mirroring and Log Shipping.

Experience in implementing operational automation using scripts.

Experience in SSIS and SSRS support

Monitor SAP Hana databases

Coordinated with developers overseas and provided recommendations.

Involved in various phases of product design,development, analysis and administration.

Dev ops and Python knowledge

Versatile Team player with proven Problem-solving skills. Possess excellent interpersonal communication skills & technical documentation skills. Works independently as well as in team.

TECHNICAL SKILLS:

Operating Systems: MS Win2008/2012, Red Hat Linux, MS-DOS

Languages: TSQL, C, FORTRAN, Pascal, HTML &UNIX Shell Scripting, VB 6, Active X, Macros, MDX, PowerShell

Web Technologies: HTML, DHTML, JavaScript, Perl, ASP, XML, VBScript, Jscript, Apache

Web Server, IIS, and iplanet

Databases: MS SQL Server 2019/2017/2016/2014/2012/2008/2005/2000,SAP HANA, Oracle

Software: Service Now, Azure Storage Explorer, Azure Database Migration Service, SSMS,

ServiceNow, TRACKIT, JIRA, Sybase Power Designer, DB-Artisan

Networking: TCP/IP, Cisco Routers, JDBC, ODBC, HTTP, CGI, NIS, and DNS.

B.I tools Cognos Enterprise Business Suite, CognosPowerplay Reports/Impromtu/Web/ Reportnet, Cognos Transformer, Cognos Configuration manager/Access Manager, ProClarity 5.2, MS Analysis Services, MS Data Analyzer, OLAP, Informatica 6.1

EDUCATION:

Master of Science in Computer Science, City University of New York. U.S.A

Bachelor of Science in Electronics & Communication Engineering Osmania University.

CERTIFICATIONS:

Microsoft Certified Solution Engineer in Cloud (AZURE)

Microsoft Certified Solution Engineer (MCSE) Data platform (SQL Server 2012)

Microsoft Certified Solution Associate (MCSA)

Microsoft Certified IT Professional (MCITP)

Microsoft Certified Technology Specialist (MCTS)

Certification as Microsoft Database Administrator (MCDBA)

PROFESSIONAL EXPERIENCE:

TUSC Chicago, IL October2008 –Present

Solution Architect/Senior Database Administrator

Administer/manage a Database environments in SQL Server 2022/2016/2014/2012/2008/2005/2000

Architecting solutions.

Develop/manage SQL Server Manage Service practice.

AWS Aurora DB management and Postgre

Migrate to Azure SQL Database or provision a new SQL database.

Backup and restore Azure SQL Databases.

Manage and Migrate AWS and Azure

Support AWS and Azure environments.

Monitor and administer Postgres environment.

Hands on Production Support DBA for mission critical 24/7 OLTP/OLAP databases.

DB refresh of environments.

Monitor and administer SAP Hana databases

Managed linked servers

Monitoring using Idera, Dynatrace and SolarWinds database tools.

Supporting SSIS and SSRS environments. TFS file server support. SSDT tools support

Working with Service Now and TRACKIT ticketing system and change control.

Implemented DR and Backup/Recovery strategies.

Extensive hands-on experience in Performance monitoring and Tuning long running queries and database performance issues.

Implemented DR/HA and load balancing using replication, mirroring, log shipping, always on and clustering solutions.

Plan, design, and coordinate projects which support 24X7 database services in alignment with global IT strategies.

Migrated SSIS Packages.

Manage outsourced operations ensuring outsourcer complies with all contractual obligations to provide services, meets all Service Level Agreements (SLA’s) and delivers excellent services and customer service.

Plan, design and coordinate projects which support 24X7 database services in alignment with global IT strategies.

Manage the full life cycle of technologies; ensure services delivered to support global applications are reliable, innovative and cost effective.

Manage and approval of policies, procedures, standards and documentation relating to database technologies.

Establish and maintain data security and integrity controls; participate in quality control audits to ensure standards are maintained.

Develop and document Data Architectural solutions and recommendations.

Consolidate environment.

Provide proactive database support monitoring system and best practices.

Implement and Administer DRP solutions.

Administered log shipping, mirroring, Clustering and always on

Implement and recommend Microsoft best practices.

Document Backup and Recovery Test plans.

Document Migration process.

Performance tune SQL Server environment.

Performance tune SQL Server query tuning.

Manage Database environment and perform health checks.

Recommend and implement disk space management plans.

Configure SQL Server using Microsoft best practices.

Performing project planning, implementation, documentation and testing.

Mentor clients on various best practices.

Recommended and implemented coding best practices.

Performance tune client code and recommended optimal solutions.

Provides high level recommendations to manage hardware, applications and databases.

Coordinated with developers overseas and provided recommendations.

Schawk May2007 –September2008

DBA

Administer/develop a Data warehouse in SQL Server 2000/2005

Migration of SQL Server 2000 to 2005.

Manage data warehouse environments, projects and team.

Monitor and administer Postgres environment.

Database Performance tuning and Design.

Install and configure Databases. And applied patches.

Managed more than 100 instances and provided remote 24/7 DBA support.

Worked with Database of sizes 1TB or greater.

Coordinated with developers overseas and provided recommendations.

Provides high level recommendations to manage hardware, applications and databases.

Recommendations for buying infrastructure in the enterprise.

Create high level report for higher management.

Provide training and mentoring to staff.

Manage MS Clustering environment.

Optimize the data warehouse.

Capacity management and performance tuning recommendations.

Administer/manage replication and log shipping.

Disaster recovery planning. Clustering.

Design and develop ETL process to populate data in data warehouse.

Performance tune data warehouses and OLAP. System level and database level performance tuning.

Created Olap models in MS Analysis Services.

Design/manage DTS packages to perform various ETL needs.

Performance tune MS Analysis Services like memory settings, partitioning and logging.

Implemented efficient Capacity management planning for the data warehouse.

Performing project planning, implementation, documentation and testing.

Write scripts MDX, Transact-SQL, store procedure, PL/SQL for the processing of analytical data into dimension and fact tables. Create/modify changes to Measures, Calculations, KPI, Data Sources and Data Source Views, Cubes/Virtual Cubes etc.

Document the procedures for administering the OLAP environment and create technical documents based upon business requirements for the modification or addition of aggregates, storage, cubes, dimensions, data sources and mining models.

Environment: SQL Server 2000, 2005, Windows 2003/2000, 64 bit

Carnyx Communication July 06 –May200

Business Intelligence lead/DBA

Administer/develop a Data warehouse SQL Server 2000/2005

Migration of SQL Server 2000 to 2005.

Manage datawarehouse environments, projects and team.

Database Performance tuning and Design.

Install and configure Databases. And applied patches.

Managed more than 50 instances and provided remote 24/7 DBA support.

Worked with Database of sizes 1TB or greater.

Coordinated with developers overseas and provided recommendations.

Provides high level recommendations to manage hardware, applications and databases.

Recommendations for buying infrastructure in the enterprise.

Create high level report for higher management.

Provide training and mentoring to staff.

Manage MS Clustering environment.

Optimize the data warehouse.

Install SharePoint and performance point server 2007

Capacity management and performance tuning recommendations.

Administer/manage replication and log shipping.

Disaster recovery planning.

Planned ETL development using DTS and informatica.

Cognos BI Suite implementation and development of reports using reportnet.

Design and develop ETL process to populate data in data warehouse.

Performance tune datawarehousesand OLAP. System level and database level performance tuning.

Created Olap models in MS Analysis Services.

Design/manage DTS packages to perform various ETL needs.

Performance tune MS Analysis Services like memory settings, partitioning and logging.

Implemented efficient Capacity management planning for the data warehouse.

Performing project planning, implementation, documentation and testing.

Write scripts MDX, Transact-SQL, store procedure, PL/SQL for the processing of analytical data into dimension and fact tables. Create/modify changes to Measures, Calculations, KPI, Data Sources and Data Source Views, Cubes/Virtual Cubes etc.

Document the procedures for administering the OLAP environment and create technical documents based upon business requirements for the modification or addition of aggregates, storage, cubes, dimensions, data sources and mining models.

Environment: Oracle, SQL Server 2000, 2005, Windows 2003/2000, 64 bits, Cognos,informatica, ProClarity.

OLGC Feb 06- Jul06

Lead DBA

Design develop and administered Oracle 8i, SQL Server 2000 and DB2 databases &Data warehouses.

Develop CognosReportnet reports and administer Cognos framework manager.

Production support DBA 24/7 for SQL Server 2000 and DB2.

Setup DRP environments. Setup log shipping and replication.

Install and configure clustering environments.

Manage Data warehouses and BI.

Oracle Performance tuning and Design.

Install and configure Oracle. And applied patches.

Performances tune the huge data warehouse databases.

Managed more than 50 instances and provided remote 24/7 DBA support.

Worked with Database of sizes 1TB or greater.

Design,Develop,Performance tune OLAP (Analysis Services cubes).

Mentor and train associate database administrators and developers.

Perform deployments in live environment as needed and provide 24/7 support to the production environment.

Backup and restore databases on live, development or quality assurance servers as needed.

Recommended different strategies to optimize the environment. Suggested efficient backup methods and system tuningmethods.

Perform routine database maintenance like dbccchecks and software upgrades.

Develop, test and execute disaster recovery plan as needed.

Prepare environments to Migrate databases.

Create and modify relational and dimensional data models.

Tune SQL Server configuration settings, memory, queries, physical and logical database design.

Environment: DB2 UDB, SQL Server 2000, 2005, Windows 2003/2000, 64 bits, Cognos, informatica, ProClarity, DB2, AIX, HP UNIX

(Markettrends) Nov 05 – Feb06

CognosReportnet Consultant

Responsibilities:

Develop Business reports using Reportnet

Develop data design and models and defined relationships.

Develop Data Models using Framework Manager. Created calculations, macros using

Vb scripts and expressions.

Published packages, implemented object level security and data level security.

Maintained Internet Information Services for the Web Portal.

Customized and maintain Cognos Connection and Cognos Configuration.

Install and administered Cognos Enterprise suite.

Documented various business models and requirements.

Implemented security and maintained groups, roles, users using third party authentication like active directory.

Created complex reports using Reportnet. Created various kinds of reports like

Bursting reports, multipage reports, drill through reports, hyperlink reports, charts

Crosstabs and line reports and added prompts and filters to the reports according to

Business requirements.

Scheduled reports to run in different formats excel,pdf and html.

Install reportnet SDK.

Train business users in CognosReportnet, Query Studio and Cognos Web Portal.

ZFPIT Dec 02 – Nov2005

System Analyst/Cognos Business Analyst

Responsibilities:

Install/Configured various B.I tools like CognosPowerplay Enterprise Server, Configuration Manager, CognosPowerplay, ReportNet, Access Manager, Upfront Manager, metrics manager, Proclarity Analytics Server/Desktop/Web, Analysis Services for various Business Analysis needs.

Set up CognosReportNet portal. Created Models in Framework Manager

Design reports and cubes in ReportNet.

Creating different format business reports, charts, currency conversions and calculated measures.

Design queries using Cognos Impromptu.

Implemented MOLAP & ROLAP models for storage of the cube. Partitioned the cubes, created calculated members & measures using the Analysis Manager.

Implemented dimensional modeling (star schemas, snowflakes, and parent-child).

Implemented security features in the OLAP cubes and manage users in cube reports.

Develop of the ETL design document and transformation rules

Develop multidimensional Cubes for statistics system. Restore Cube Database in Analysis Manager.

Design, administer & maintain SQL Server2000 on Win2000/2003 clustered environments.

Design, administer & maintain DB2 and Oracle 9i/10g Databases on UNIX, Linux, Windows

Design and implement clustered databases with fail-over capabilities

Design/Administered Enterprise Datawarehouses& Data Marts for various Businesses needs.

Data modeling reverse engineering, DFD, ERD using Sybase Power Designer.

Providing T-SQL statement tuning & optimize data loading process.

Develop Stored Procedures, Triggers, Materialized View, User Defined Functions (UDFs), and packages.

Develop Business Reports and Statistical reports using T-SQL and B.I tools like CognosPowerplay, Reportnet, Proclarity, Data Analyzer, Dashboards. Create MDX for various cube analysis & reporting.

Used XML spy to create xml schemas to validate various xml documents.

Implemented MOLAP and ROLAP model for storage of the cube. Partitioned the cubes

Create, monitor and maintain user accounts, access and database security

Provide support for copying/cloning production database environments to development

Develop scripts to migrate data from multiple sources. Manage Linked Servers.

Replication between SQL Server, Oracle and DB2. Troubleshoot database problems as required.

Identify data discrepancies, data quality issues to ensure data consistency and integrity

DTS (Data Transformation Services) and Informatica to schedule various task and load Data.

Managing Users, Roles & Monitoring and Detecting Lock.

Monitor/Tune Databases, T-SQL, Index tuning. Allocate database system storage for optimum l/0.

Planning and Implementing Database Backup and Recovery. Defining DB Maintenance Plans.

Managing Tablespaces& Containers in DB2 UDB, Oracle. Configure HIS, Loading Data SQL Server to DB2. Provide DTS/stored procedures troubleshooting/Administration and support.

Train/support users on features of BI functionality. Created forecast models in Cognos and Proclarity.

Experience in dimensional modeling (star schemas, snowflakes, and parent-child.

Configured IIS server and Active Directory to authenticate users of the Cognos.

Prepare Technical Documentation and Business Requirements Documents.

Environment: DB2 UDB, SQL Server 2000, 2005, Windows 2003/2000, 64 bits, Cognos, Proclarity, Oracle.

Telcordia Technologies (formerly Belcore (bell labs)) New Jersey U.S.A Apr ’00 – Nov ’02

System Performance Analyst

Lead Database, System administration (Oracle DBA)

Responsibilities:

Install/Configured Oracle 8i/9i on Sun Solaris, Linux and Windows NT.

Created (data models/generated DDL/Oracle Database). Participate in data policy, Business Rules & procedure development. Experience in data modeling with IDEF0/IDEF1X models, data reuse & data standardization across multiple systems. Administered a DataWarehouse environment.

Designed Data models (logical and physical model) using ER/Studio 5.1 and other design tools.

Created logical reports. Created the database using the designed schema. Remodelled Schema.

Install/admin DB2 on Linux as part of a 4 months project.

Provisioning the Oracle 8i database. Partitioning the oracle 8i tables. Monitor Space management.

Implemented VeritasNetbackup for scheduling new backups, testing restore, creating classes, pools

Performance tune the DB by collecting statistics by UTLBSTAT /UTLESTAT scripts & modifying appropriate init.ora parameters & also by SQL trace, analyze command, explain plan, TKPROF

Providing tips to developers to optimize the queries. Provided application programmer support.

Reconfigured/monitored/allocated rollback segments. Removed Chained rows.

Creating database storage structures (Tablespaces), primaryobjects (Tables, Views & Indexes).

Create PL/SQL store procedures, packages, functions & DB Triggers for various tasks.

SQL*Loader Utilities to load data from operating system files. Export/Import utilities. Performed Hot/Cold backups. Develop/Deploy/Monitor Backup/Recovery procedures. Configured Legato Storage Manager, Solstice Backup Suite &VeritasNetBackup, and Sun Enterprise 3500 Server.

Install/manage/Administered SQL-Server-2000. Performed data transformation by DTS. Managed SQL Server log shipping. SQL Server Profiler to monitor the server on a query basis or event basis.

Install/Maintained/Configured Sun Ultra/Enterprise Servers, Linux, HP-UX System and AIX

Managed User/Group account & Peripherals system. Allocating quotas & file permissions.

Administered the disc usage and maintenance of file system. Manage/administered Veritas Volume Manager & Solstice Admin/Disk Suite. Network management in NIS, NIS+, NFS, DNS.

Creating/Customizing Perl and shell scripts and automating tasks using cron jobs and at jobs.

Evaluation of new software and hardware to recommend necessary upgrades.

Performed System Backups and recovery. Wrote korn shell scripts to automate backup.

Worked on Veritas Net backup and Solstice Admin/backup suite. Scheduled daily & weekly backups using cron jobs. Performed Disaster recovery at the time of system crash.

Implementation and Provision of security and auditing according to business requirements.

Install ss7 gateway & HP openView, Appcenter, glance plus, netstat, ITO & MGTS. Familiar with Telecommunications Protocols. Monitoring memory leaks of Win NT/2000. Manage Active directory.

Troubleshoot Hardware/Network issues. Install/Upgrade Network Applications. Setup & manage Printing Services. Monitored software performance issues & resolved associated problems.

Installing Sun Solaris 7 and 8, configuring network. Install & configured Apache webserver.

Installing patches/packages/Perl/DBI & DBD modules for database connectivity and performance.

Adding and managing Sun systems clusters using Application Management GUI and ITO.

Work with other team members to coordinate architecture (platform) and feature development through the design, development and unit test phases considering the business model.

Wrote technical documents, business requirement documents and performance results documents.

Help Desk 24/7 production support & phone support for various System and software issues.

Environment: SQL Server 2000/Oracle 8i, Sun Solaris, HP UNIX

AWARDS:

Employee of the Month Award RoltaTusc.

Employee Recognition Award TelcordiaTechnologies (Bell Labs) New Jersey U.S.A.

Appreciation Award for teaching faculty in City University of New York.

Contact this candidate