Sql Server Management

Farooq Mohammed

**********@*****.*** 972-***-****

SummaryAbove 4+ years of Professional experience as MS SQL Server DBA in development and production environments.Experience with Microsoft SQL Server 2000/2005/2008 Database Installation and Administration on multiple instances, editions and version upgrades.Hands on experience in backup and restoration of databases, automating Administration, Security maintenance, and troubleshooting client-server applications.Experience with T-SQL in creating triggers, stored procedures, tables, user defined functions, views, indexes, constraints and data integrity checks.Good experience with implementing High Availability of database servers using Database mirroring, Log Shipping, Replication and Clustering.Experience in working with ETL tools like SQL Server Integrating Services, Informatica.Experience in working with reporting tools like SQL Server Reporting Services.Knowledge of Visio, Erwin/ERStudio 7.0 Data Modeling Tools for database designKnowledge of high availability SQL Server solutions, including SQL Server clustering, Log shipping, Database Mirroring and Replication and third-party software like SQLLiteSpeed, VERITAS, BMC SQL-Backtrack for Performing Backup and Recovery.Extensive experience with SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indexes and statistics and query plans. Solid experience in DTS package design and construction and Knowledge of Bulk copy and BCP utilities, Migration of DTS packages to SSIS and Migration of SQL 200 Data cubes to SQL 2005. Flexible and able to handle multiple tasks simultaneously and develop exceptional relationship with co-workers, management, technical/non-technical staffs, clients and various end-users.On call support to the clients in making them understand the problems and help in solving those problems faced by them.Extensive experience with Storage, Space Planning, Capacity planning, including system storage allocation, on-going capacity analysis and planning future storage requirements. Managed 100GB-1TB sizes of databases. Experience with establishing and maintaining security integrity controls in conjunction with the applications and security groups and assist in the design and implementation of development, testing, QA and production environments.Develop and implement policies and procedures and standards for preserving the integrity and security of data, reports and access. Experience with software development life cycle (SDLC) and project management methodologies.Self-starter/team player with excellent communication, organizational, presentation, troubleshooting, systems analysis, project management and documentation skills.

EducationUniversity of Missouri – Kansas City (UMKC)

Master of Science in Electrical Engineering 12/08

GPA: 3.91Jawaharlal Nehru Technological University (India)

Bachelor of Science in Electronics &Communication Engineering 5/06

GPA: 3.85

Certification

Microsoft certified Technology Specialist in SQL Server 2005: Implementation and Maintenance (MCTS 70431)

Technical Skills

SQL Server Tools : SQL Server Management Studio, Business Intelligence

Development Studio, SQL Profiler, SSIS, SSRS, SSAS.

ETL Tools : DTS, SSIS, Informatica Power Center 7.1/6.2

Programming Languages : C,C++,T-SQL,VBscripts,Asp.NET, C#, VB.NET

Visual Studio, UNIX Shell Scripting,

RDBMS : SQL Server 6.5/7.0/2000/2005/2008, Oracle 10g/9i

Productivity Applications : MS Office, MS Project, Erwin, Visio, MS FrontPage, Crystal

Reports

Operating Systems : Windows 2003/2000 server, XP / 2000 / NT 4.0 / 98, UNIX

Web Technologies : HTML

Hardware tools : MATLAB, PSpice, Silos, Opnet, Cadence, Mentor Graphics,

DFT Tools

Processors : 8085, 8086 micro processors

Professional Experience

Veritis Group Inc, Irving TX June 2011 - Present

Database AdministratorInstalling, configuring, maintaining and administering multiple instances of MS SQL server 2000/2005/2008, and applying service packs.Creating databases, tables, views, stored procedures, schema objects, triggers, performance tuning and optimization, monitoring control process, permission and security policies.Automated and enhanced daily administrative tasks including backup and recovery, performance monitoring, ad-hoc queries, disaster recovery, space sizing and capacity management plan.Successfully designed, developed and maintained more than 50 DTS packages that include backup, data appending to existing tables, automatic attachment and emailing to clients, File upload to client site, XML export of the data and many other process.Created many SQL Server jobs and alerts running at different times of the day and maintained them along with fixing the issues involved. Experience with SQL Profiler & Perfmon. Experience with Query Optimization, Performance Tuning, & Effective SQL Server configuration for better performanceInteracted with developers and system analyst to communicate various business processes among them.Experience in testing, transferring & troubleshooting the DTS packages to SQL 2005 SSIS (Integration Services) and deploying them on SQL ServerExperience in upgrade/ migration from MS SQL Server 2005 to SQL Server 2008. Created Database Maintenance Plans. Installed and configured SQL Database Mail for SQL Server and also setup Snapshot/Transactional Replication and DB Mirroring.Monitored the performance of MS SQL Server, services and fine tuned configuration parameters using SQL Profiler.Employing indexing strategies and optimizing them using SQL Profiler and database engine tuning advisor.Proper use of Indexes to enhance the performance of individual queries.Designing and developing various types of reports using MS SQL Server Reporting Services (SSRS)

Veritica Inc Irving, TX Jan 2009- June 2011

Programmer AnalystDesigned and developed database infrastructure and SQL Server 7.0/2000 databases for the individual departments of the hospital and the central database repository.Developed ER diagrams ( physical and logical using Visio ) and mapping the data into database objects to enable schema management and understanding of db architectureCreated Database Maintenance Plan for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing. Designed, developed and tested DTS packages for extracting the required data, transforming it and then exporting the data.Query optimization and performance tuning. Writing triggers and stored procedures and optimizing it.Worked on creating User Interface Web Forms using Web Server Controls and User Controls. Created User Interface using Window Forms for Administrator Module.Proper use of views to prevent unauthorized access.Using the database maintenance wizard to keep the performance of the server at acceptable levels.Extensive use of triggers to implement business logic and for auditing changes to critical tables in the database.Creating users, roles and giving appropriate permissions to the members as part of the security implementation.Database creation; writing database performance tuning scripts, backup planning and implementation with Database restore activity.Creating and managing schema objects such as tables, views, cursors, indexes, procedures dynamically for any tables, triggers and maintained Referential Integrity.

City of Kansas City, Missouri June 2008- August 2008

InternInternship with the Facilities Department, General Services Conducted research on small wind turbines

University Of Missouri Kansas City Jan 2008 - Dec 2008

Graduate Teaching AssistantTutored Undergraduate Students In Electronic Circuits LabStudied Characteristics of Operational-Amplifier, Transistors and DiodesGrader under the professor for Verilog Hardware Description Language Course

University Of Missouri Kansas City Sept2007 – Dec 2008

Technical Lab AssistantAssisting students and helping out with their problems in the LabInstalled and configured Instances of SQL Server 2005 in the LabPerformed regular backups and scheduling of jobs.Wrote T-SQL Scripts and created different database objects.

Sinertel Solutions, INDIA June 2006- Nov2006

SQL Server DBAWorked as a Mid-level SQL Server Database Administrator in Sinertel Solutions, Bangalore, India.Responsible for Installation, Maintenance Of Database, designing Backup Policies.SQL server Upgrade from SQL 2000 to SQL 2005.Installation of service packs and security patches for MS-SQL Server 2005.Creating and managing schema objects such as tables, views, cursors, indexes, procedures dynamically for any tables, triggers and maintained Referential Integrity.Database and log backups and restoration, backup scheduling the backups. Query optimization and performance tuning. Writing triggers and stored procedures and optimizing it.Managing the use of disk space, memory and connections. Running DBCC consistency checks, fixing data corruption in application databasesMonitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.Implemented database mirroring and log shipping to provide extra fault tolerance.

AchievementsWas awarded the prestigious Chancellor’s Non Resident Award for merit by UMKCActive Volunteer in Association for India’s Development, Kansas City Chapter

Contact this candidate