Siddiqua Anjum San Diego, CA SUMMARY High proficiency with almost 6+ years of experience in Database Administration, System Analysis, Security and Support of MS SQL Server 2005, 2000, 7.0 in Production, Testing, Development, Replication and Cluster Server Environments. Expert in installation, upgrade and configuration of MS SQL Server and databases in clustered and Non-clustered environments. Experience in upgrading of SQL Server from version 2000 to 2005 and 2005 to 2008. Excellent Experience in MS SQL Server configuration, Backup and Recovery and Managing Security. Experienced in implementing different types of Replication Models like Snapshot, Merge and Transactional. Configuring Fail over cluster environments. Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2. Experience in Performance Tuning using tools like SQL Profiler and Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities. Experienced in data migration between homogeneous & heterogeneous systems using various tools (DTS Import Export Data, DTS Packages and SSIS). Experience in enrolling users, maintaining security policies, use of DTS/SSIS packages. Good Knowledge on SSIS (SQL server Integrated Services), SSRS (SQL server Reporting Services) & SSAS (SQL Server Analysis Services). Good understanding of different types of Replication models like Snapshot, Merge and Transactional. Excellent skills in creating and configuring Transaction replication and Tuning. Experience in other Database like MS Access. Extensive experience in Capacity planning, Performance tuning, backup and restore procedures. Experience in creating Jobs, Sending Alerts using SQL Mail. Experience in working with Reporting tools like Microsoft Reporting services. Creation and maintenance of Databases, creating Roles and managing user permissions, resolving deadlocks. Hands on experience in Troubleshooting database issues. Experience in implementing RAID 1-5 & 10 technologies. Experience working with Windows 2003/2000 and NT server. Implemented customized log shipping for SQL Server 7.0 and built in log shipping with SQL Server 2000/2005. Implemented proactive monitoring scripts for production databases. Extensive experience with various Object Oriented languages(, C++, C) Extensive experience with IIS (Internet Information Services) 5.0/6. Excellent interpersonal, Analytical and Communication skills. EDUCATION: Bachelor of Engineering (Electrical Engineering), University Of Osmania , India TECHNICAL SKILLS: Operating Systems Windows2003 / Windows2000 Advanced Server, Windows NT 4.0 / 3.51, UNIX/LINUX RDBMS MS SQL Server 2005, 2000, 7.0, MS-Access Languages C, C++, T-SQL, XML, HTML Script and VB Front End MS Visual Basic OLAP Tools MS OLAP Services Manager Version Control Tools Rational Clear Case, Visual Source Safe Hardware Compaq Proliants 8000, 6500, 6000, 5000 Servers, Dell Poweredge 6650 Good Application Experience in Setting up Active/passive clustering Setting up Replication using MS SQL Server 2005, SSIS/DTS (Data Transformation Services) Administration of MS SQL Server 2005,2000,7.0 PROFESSIONAL EXPERIENCE: KPMG, Montvale, NJ Feb’10- Till Date SQL Server DBA Responsibilities: Installed SQL Server 2005 with SP2 in production and development environments. Migrated SQL Server 2005 databases to SQL server 2008 using Backup-Restore, Detach-Attach, and Copy Database Wizard. Creating Back up Strategies, and scheduling them for execution. Configured and administered SQL Server Clustering (active/active, active / passive) with multiple nodes. Resolved locking and blocking issues. Designed and implemented Disaster Recovery Procedures like Log Shipping and mirroring between production and DR servers. Running Index tuning wizard, implementing Log Shipping. Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications. Connected SQL servers remotely using Terminal services. Created operators and alerts in getting notifications. Created users and assigned permissions. Created the SSIS packages for executing the required tasks. Created the Jobs and scheduled for daily running. Defined report layouts including report parameters, Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005/2008. Working and utilizing DMV’s DMF’s with SQL Server2005 sp2. Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS. Implemented and maintained policies, procedures and standards to ensure security and integrity of test and production data. ENVIRONMENT: MS SQL Server 2008/2005, T-SQL, Windows 2003 Advanced Server/NT,SSMS,SSIS, SSAS, SSRS,SQL Profiler, Database Maintenance Plan Wizard, Performance Monitor, The Seaport Group, New York, NY Jan’10 - Feb’10 Database Administrator (Clustering project) Responsibilities: Involved in a month long project for setting up Active passive cluster on SQL 2000 Setup SQL server 2008 Active/passive cluster for their trading application. Designed and configured the DAS D storage device for optimal performance. Involved with Migration from their current SQL2005 to SQL 2008 cluster environment Complete implementation and documentation of the scripts and procedures Involved. Performance tuning and setting up appropriate system configuration setting for optimal performance Setup Database mirroring from the Clustered Database onto DR site. Environment: MS SQL Server 2008, Windows 2008 R2, HP DAS D Archbrook Laguna, Carlstadt, NJ May ’09- Dec’09 SQL Server DBA Responsibilities: DBA for Financial Accounting system MAS 500 ERP Involved with performance tuning of various Inventory explorer views. Converted ORACLE Databases to SQL 2005 and carried out the whole migration. Installed SQL server 2008 in production environment. Extensively Involved with Migration from SQL 2005 to SQL 2008. Configured Synchronous Database Mirroring of ILS Databases to the DR site using SQL 2005 Configured Log shipping from Production to Disaster Recovery server for Production MAS 500 database in SQL 2005. Extensive Performance tuning of Queries and System Hardware configuration For Better system Performance for MAS500 Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates. . Extensive performance tuning, and optimization of procedures and queries designed for inventory and shipment reports. Developed Various Reports Using SSRS Migrated and tested DTS packages to SQL Server 2005 Integration Services and configured various XML configuration files for SSIS packages.. Dewey & LeBoeuf LLP New York, NY Oct 08 – April 09 SQL Server DBA Dewey & LeBoeuf LLP is an international law firm headquartered in New York with more than 1,400 lawyers in 14 countries and has 24 offices across four continents with an extraordinary breadth of practice and extensive industry experience. Responsibilities: Maintaining various databases on Production and development environments using SQL Server 2005/2000. Converted Oracle database to SQL 2005 and converted all schemas and system objects. Backup of SharePoint related databases in SQL 2005 and set up recovery models for the same Created transactional replication Configured third Passive node in an active/active SQL 2005 cluster setup Extensively involved in maintenance tasks such as database backup, replication verification, Installing/Configuring various reporting servers using SQL 2005 reporting services Created various SSIS/DTS packages for executing the required tasks. Setup transactional replication for database for various global offices. Involved with server upgrade project. Updated various SQL servers to Current Services packs (Both SQL 2005 and SQL 2000) Environment: MS SQL server 2005/2000, Windows 2003/2000, Diagnostic Manager, Reporting Services, IIS. Client: PartnerRe, Greenwich, CT Oct’ 06 - Sept 08 SQL Server DBA Responsibilities: DBA for claims workflow system’s (CWS) project. Configured Active/Active Clustering for failover on production server. Involved in system maintenance task, such as automated backup daily, weekly and monthly Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running. Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system. Performance tuning, and optimization of procedures and queries. Rebuilding indexes on various tables Installed and configured SQL Server 2005 in a Test Environment and migrated & tested a few databases. Migrated and tested a few DTS packages to SQL Server 2005 Integration Services. Environment: MS SQL server 2000, MS SQL Server 2005, Windows 2000 Client: Move/Homestore, Westlake Village, CA Oct’ 04 - Aug’06 SQL Server DBA Responsibilities Responsible for MS SQL Server 2000, configuration, tuning and provided support to all Production, development and clustered servers. Performed all aspects of database administration, including data modeling, backups and recovery. Configured Transactional replication between Primary Server and three Read–Only servers, with separate Distributor server and experience in troubleshooting replication problems. Additionally, designed and implemented a disaster recovery system. Configured the Log shipping and created the Standby server. Running Index tuning wizard and rebuilding indexes for faster query response. Data migration using DTS services across different databases like Oracle, MS access & flat files. Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts). Prepared Estimates for Database, table size growth. Created documentation to install SQL Server, apply service pack, hot fix and clustering installation. Expertise in Security Issues such as creation and granting permissions on various Objects. Preparing the reports for the day-to-day as well as weekly/monthly purposes. Environment: MS SQL-Server 2000, DTS, SQL Diagrams, Windows 2003 Server, MS Access, MS Analysis Services, MS Reporting Services, HTML.
Pages to are hidden for
"Siddiqua Anjum"Please download to view full document