Sr SQL Server DBA/Developer
Resume:
Monil Modi
Brooklyn,NY *****
Ph:-347-***-****
Email id:-*********@*****.***
PROFESSIONAL SUMMARY
Over 3+ years of IT experience in Database Administration, and Support of MS SQL Server 2005 and MS SQL Server 2000 in Production, Test, Development and Replication & Cluster Server Environments.
Conversant with all phases of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation
Hands on Experience in installation, configuration of MS SQL Server 2000 on Windows NT/2003 servers and also worked on migration from SQL Server 2000 to SQL Server 2005.
Experience with high availability systems, 100+ GB databases, hundreds of databases in a highly transactional environment with proper data Archive and Purge processes
Proficient in Designing and Documentation of SQL Server Strategies and plans.
Experience in database backups/restoration and recovery of NT server/SQL Servers
Strong working knowledge with 32 bit/64 bit Windows 2000/2003 servers, Itanium servers
Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP, DTS and SSIS utilities.
Hands on experience and knowledge on high availability SQL Server solutions, Replication and database mirroring.
Experience in configuring, administering and maintaining Replication.
Experience in performance monitoring and performance tuning by implementing efficient schemas, Optimizing queries, Tuning indexes and Database Consistency Checks using DBCC Utilities.
Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.
Experience in working with version controlling tools for managing SQL scripts and changes that are going to production.
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, production and Disaster Recovery (DR) environments.
Experience in Installing and Configuring Failover Clustering for high availability in Active/Passive or Active/Active and also combined clustering and database mirroring (SQL Server 2005)
Setup, Reconfigured, and Monitored log shipping of production databases and also carried out role changes, role reversals, and positioning the monitor server.
Experience in resolving database performance issues, database capacity issues and distributed data issues.
Enough experience in data-flow, DTS package design and construction.
Utilized DTS packages to schedule and create processes to migrate data feeds from various systems into normalized SQL Server schemas.
Good experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
Hands on experience on using Microsoft Reporting Services.
Experience in providing good 24x7 - Production support.
Excellent analytical & interpersonal communication skills, able to work both in teams and individually.
TECHNICAL skills:
Operating Systems Windows 2003 server, Windows 2000 Server, Windows 2000 Advanced server, Windows NT 4.0, Windows XP.
Hardware IBM Compatibles, Compaq Servers.
Languages C,C++, PL/SQL,T-SQL , HTML , XML .
RDBMS SQL Server 2005/ 2000 /7.0, MS Access.
Application Crystal Report, Visual Studio, MS Office 2003, MS outlook, Lotus Notes, Rational Clear case.
Database
Query Tools MS SQL Server Query Analyzer, SQL Profiler, ETL, SQL Server Management Studio, Enterprise Manager.
PROFESSIONAL EXPERIENCE:
MCSAM MANAGEMENT, LLC, Brooklyn, NY SEP2009- PRESENT
Responsibilities:
• Involved as an MS SQL Server 2005/2000 Administrator and responsible for requirement analysis, design, document, development, enhancement and support of MS SQL Server databases.
• Maintaining Reporting services on MS SQL 2000/2005 platform.
• Involved in Architectural design for the databases and database tables and capacity planning.
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Designed and developed DTS packages in SQL 2000 and SSIS packages, SSRS and SSAS in SQL 2005.
• Implemented data partitioning for new SQL server 2005 databases (Created partition function, partition scheme mapped to a partition function and created the table on the partition scheme)
• Implemented and administrating SQL Server Snapshot replication and transactional replication.
• Developed T-SQL stored procedures as a part of database maintenance plan for new SQL Server 2005. Used system stored procedures and DBCC commands.
• Performed all aspect of database administration, including backup, recovery and Replication for SQL 2005.
• Extensively involved in Developing and Enhancing of Custom Queries extracting data from Source System and wrote required enhancements on Existing DTS Packages.
• Rebuilding the Indexes at regular intervals for better performance.
• Tuned SQL queries and Stored procedures using SQL Profiler and Index Tuning Wizard.
• Scheduled jobs and alerts using SQL Server Agent. Administrating Microsoft MOM 2005 and database.
• Involved in database and log backups & restoration, backup strategies, scheduling.
• Backing up master & system databases and restoring them when necessary.
• Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Respond to trouble tickets assigned to me and fix any database issues promptly Update and work on projects that I have been assigned to as a resource from the Database Management team
Environment: MS SQL Server 2005/2000, T-SQL, Win 2003, IIS, FTP, DTS, SSIS, Oracle 9i, VB, ASP, XSL, XML Web Services, JavaScript, CSS, IIS 6.0 and MS SQL Reporting Services.
SAC Capital Advisors, LLP, Stamford, CT Feb 2007-Aug2009
SQL Server DBA
SAC is a private multi-strategy, assessment firm. I maintained their databases which consisted of 57 MS SQL servers.
Responsibilities:
Installed, managed, maintained and administered 57 MS SQL Servers (2000, 2005) and MS SQL Replication Servers on clustered SAN environment.
Performed backups, login security, maintenance, and growth monitoring on both MS SQL Server and Sybase servers.
Performed logical and physical database design, performance tuning, and capacity planning.
Provided 24x7 production supports for the Portia, Open Trader and Sales Page (MS SQL Server) applications.
Wrote maintenance plans, extracted data, advanced partitioning, performed backup, restores and disaster recovery.
Built and monitored warm standby databases using the MS SQL Server and Sybase Replication Server.
Managed SQL Servers and database security and permissions.
Wrote stored procedures for server managing purposes.
Reviewed and optimized developers stored procedures.
Performed all system upgrades, including Thomson’s Portfolio Management and Trading System software, Sales Page software, Solaris upgrades and Sybase release upgrades.
Assisted developers in tuning Visual Basic applications to work better with the databases.
Performed data modeling (ErWin) and monitored integration with other systems (OASYS, DTC, FMC Recon, Client Billing, etc.)
Wrote user reports on Crystal Reports to retrieve information from the Sales Page database.
Worked closely with the Thomson and Sales Page account managers on financial contracts and obligations.
Set up all business applications at the Disaster Recovery site.
Assisted vendors that use MS SQL Server and Sybase as the primary database system for their products with installing the SQL Server and Sybase, and setting up basic security.
Applied patches and Service Packs for each server after a trial period on the test network.
Monitored logs.
Environment:
.
MS SQL SERVER 2000, 2005, DTS, Lite Speed Backup Software, Veritas Indepth, Windows 2003 server.
EDUCATION:
MS in Software Engineering
Contact this candidate