Sql Server Manager
Resume:
Sumeer Vij
SQL Server Database Admin
Mobile: 646-***-****
Home: 718-***-****
Email: ********@*****.***
***-** ***** *****, *** Floor • Jamaica, NY – 11434
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Objective:
To obtain a Database Administrator position with opportunity for rapid promotion and challenges including creating problem solving and administrative skills to achieve maximum profits.
Summary:
Over twelve years of IT experience in SQL Database Administration, System Analysis, Design & Support of MS SQL Servers 2012, 2008R2, 2008, 2005, 2000 Production, and QA & Development environments including Replication and Cluster Servers.
Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2012/2008/2005/2000.
Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
Expert in creating Index, views, complex stored procedure, User Defined Functions (UDF), and effective triggers to facilitate efficient data manipulation and consistent data storage, implementing different complex and critical business needs.
Have good experience with partitioned schemas, partitioned tables and indexes, creating Filegroups using SQL Server 2008 R2, 2008, and 2005.
In-depth knowledge of T-SQL (DDL and DML) to perform batch processing and implement business logics into backend.
Good experience with SQL Server 2005 online Indexing and Recoveries features.
Expertise in T-SQL writing stored procedures, triggers and functions.
Good experience with implementing DR solution, High Availability of database servers using Database mirroring and replications and Log Shipping.
Using new features of SQL Server 2008 like Log compression, transparent data encryption TDE, Policies, Performance data collector, Auditing.
Experience in creation of logins, users and configuring permissions and assigning roles to users. Good understanding of Normalization /De-normalization, Normal Form and database design methodology.
Worked on logical and physical database modeling with UML and ERWIN tools.
Expert in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.
Expert in extracting and transforming data using ETL SSIS packages, DTS packages, Import Export Data.
Good knowledge of SSRS software installation, configuration, and maintenance of SSRS reporting environments, UAT, Staging and production.
Good knowledge in developing and designing reports through SSRS.
Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
Troubleshoot performance problems, fine-tuning of databases and index Analysis.
Worked on SQL Server 2008 migration from SQL Server 2005.
Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages.
Good experience with Analysis Services, Reporting Services, and SQL Server Clustering.
24 X 7 Production Database on Call Support.
Education:
Pace University 09/2008 – 06/2010
Masters of Science – Computer Information Systems
Concentrating on Database Management & Technology
Farmingdale University 09/2002 – 12/2007
Bachelor of Technology – Computer Systems
Specializing in Database system designs, Networking & C++ programming
Certifications:
Microsoft Certified Solutions Associate (MCSA) Anticipated – Dec 2016
Work Experience:
CBS Local, New York, NY 11/2013 – Present
Role: Senior SQL Server DBA
Responsible for implementing DR Solution which would create a duplicate replication set of all Production Databases between Primary to DR site.
Created Replication DR Solution using CA ArcServe RHA Manager tool in Staging, and Production environment. Verified several scenarios during implementation process which would provide replica and high availability during Failover disasters.
Implemented a standalone server for Crystal Reports for reporting and managed the SAP Crystal Reports Console by providing access to users to customize the exited reports and create new reports as per their requirements.
Worked in building Adhoc Reports, Parameterized Reports, Linked Reports, Toggle Reports, and Reports with Sub Reports using SSRS.
Worked on Linux Platform which ran Tungsten technologies that supported MySQL Databases backups, replication between Master and Slave nodes.
Worked in upgrading CentOS 6 to Ubuntu 14.04 on Linux Platform nodes and install MySQL Databases and setup replication via Tungsten software between Master, Slave, and Relay node in DR site.
Created High Availability solution for MySQL Databases using Tungsten software between Master node to Relay node in remote location.
Worked on MySQL Database migration over to MS SQL Server Database for several databases and coordinated well with the developers with various issues during this migration process.
Worked in creation of logins, users and configuring permissions and assigning roles to users during creation of new databases in MS SQL Server 2008 R2, and migration of existed databases from MySQL over to MSSQL Server.
Worked in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent.
Audited MS SQL Server and MySQL Users & Permissions on quarterly basis.
Created maintenance plan for regular scheduled Transaction log backup, Full backup (Separately in remote server), Check database, Reorganize index, Rebuild Index, Update Statistics and Cleanup task.
Frequently Monitor Connections, Locks and Database Performance using Performance Dashboard. Used Idera Monitoring Manager software to monitor all SQL Server in Production environment.
Reviewed and optimized SQL queries, stored procedures, functions, Indexes, views and Triggers and worked closely with all Developers.
24 x 7 Production Database on Call Support. Responsible for 24x7 critical production support for 25 SQL Servers and 25 MySQL Servers.
Disc Graphics, Inc, Hauppauge, NY 07/2013 – 10/2013
Role: Senior SQL Server DBA
Work with Senior Database staff by maintaining databases for test and production purposes for assigned projects.
Responsible for creating SSRS Report development of a new Solar Soft database for the Management team.
Write Stored Procedures & User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
Created, implemented, deployed and maintaining a reporting suite of standard reports while also customizing many reports to meet individual user’s needs.
Development of custom scripts and stored procedures for data import and manipulation.
Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS.
Designed and developed Drill down and Drill thru parameterized reports using SSRS.
Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports using Visual Studios and deployed the reports.
Scheduled reports for Daily, Weekly, Monthly reports on sales and marketing information for various categories and regions based on business needs using SQL Server Reporting services (SSRS)
Documenting & maintain SSRS Reporting/Database and technology process flow diagrams.
Responsible for improving performance by creating/using Indexes efficiently, implementing queries as Stored Procedures, managing locks, and working efficiently with Transactional SQL queries, creating procedures using SQL scripting.
Created stored procedures for Automatic Scripting to backup transaction logs, flush/grow/shrink log files, maintain archive of objects.
Create jobs, SQL Mail, Alerts and Schedule SSIS Packages using SQL Server Agent and Report abnormal discrepancies to the Database Manager.
Importing data into SQL Server DB from Extract tool and analyzing data for reporting purposes.
Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures.
Epiq Systems, Inc, New York, NY 01/2013 – 06/2013
Role: Senior SQL Server DBA
Work with Senior Database staff by maintaining databases for test and production purposes for assigned projects.
Responsible for supporting & troubleshooting issues with database using SQL Server 2005, 2008, 2012 Enterprise Edition.
Responsible for Building database servers, applying necessary hot fixes and/or SPs.
Responsible for Upgrading the SQL Servers, configuring the server parameters, backing up and restoring system and user databases.
Create user databases, create of maintenance plans and jobs, user creation and maintenance, database log space monitoring and maintenance and Monitor all database backups and report any failures of this process
Responsible for improving performance by creating/using Indexes efficiently, implementing queries as Stored Procedures, managing locks, and working efficiently with Transactional SQL queries, creating procedures using SQL scripting.
Responsible for SQL scripting to manage databases, applications and operating systems and Responsible for implementing SQL clustering, Database Mirroring and log-shipping processes.
Create jobs, SQL Mail, Alerts and Schedule SSIS Packages using SQL Server Agent and Report abnormal discrepancies to the Database Manager.
Create reports for clients based upon their requirements during the Bankruptcy processes using Crystal Reports.
Analyze & generate reports required by the Senior Management staff.
Importing data into SQL Server DB from Extract tool and analyzing data for reporting purposes.
Responsible for installations & configurations of database software, and various applications.
Monitor systems & responsible for availability which include data loads, imports & exports, file transfers, etc.
Scherago International, Jersey City, NJ 10/2011 – 12/2012
Role: Database Admin/Systems Manager
Support software migration projects and take ownership of web-based CRM, reporting, meeting/conference applications.
Responsible for developing database & supporting Web-based CRM systems.
Responsible for working with third-party systems developers for the Company’s Advertisement systems.
Responsible for supporting & troubleshooting the Advertisement systems and Responsible for supporting meeting/conference expos applications.
Responsible for Upgrading the SQL Servers 2005 to 2008 and 2012 Enterprise Edition, configuring the server parameters, backing up and restoring system and user databases.
Responsible for Building database servers, applying necessary hot fixes and Service Packs.
Responsible for creating user databases, creating of maintenance plans and jobs, user creation and maintenance, database log space monitoring and maintenance.
Responsible for improving performance by creating/using Indexes efficiently, implementing queries as Stored Procedures, managing locks, and working efficiently with Transactional SQL queries, creating procedures using SQL scripting.
Responsible for SQL scripting to manage databases, applications and operating systems and Responsible for implementing SQL clustering, Database Mirroring and log-shipping processes.
Responsible for providing mission critical system support in a 24/7 environment and Responsible for SQL Server 2005 DB overall performance, tuning and backup/recovery of the database.
Market Data Services Ltd. (MDSL), New York, NY 07/2010 – 10/2011
Role: Database Analyst/Helpdesk Analyst
Manage MDSL Helpdesk environment by handling daily issued tickets by the MDSL users & clients all over the financial market in the world.
Assist MDSL users & clients with their technical issues over the MDSL products such as MDS2000.
Assist users over the phone with their problems rose at their Citrix session and MDSL products.
Create/Edit/Delete helpdesk logins & Client’s Citrix login (MDM/TEM/RPM) on the company/manager page based on the ticket request.
Responsible for supporting & troubleshooting issues with database using SQL Server 2000/2005.
Responsible for all production & development backups for disaster-recovery situations. Plan for systems growth and monitor capacity usage for new hardware or software requirements and communicate these capacity requirements to management.
Assist users with their Citrix accounts via Active Directory & Citrix presentation server console.
Assist users with MDM interface, TEM interface tools. Developed strong customer service skills.
Create reports for clients based upon their requirements for their MDM, TEM & RPM accounts using Crystal Reports.
Responsible for all production & development backups for disaster-recovery situations. Plan for systems growth and monitor capacity usage for new hardware or software requirements and communicate these capacity requirements to management.
Modell’s Sporting Goods, Inc, New York, NY 6/2006 – 07/2010
Role: Jr. Database Administrator/Database Analyst
Responsible for maintaining and supporting legacy systems which include on UNIX mainframe/OS compatible programs.
Responsible for both manage and support all Production, Development and Staging instances of Oracle Version 7x to 11g.
Responsible for supporting & troubleshooting issues with database using SQL Server 2000/2005.
Develop and maintained logical schema, physical records, and SQL queries for Oracle applications databases
Analyze & generate reports required by the Senior Management staff.
Responsible for installations & configurations of database software, and various applications.
SSRS software installation, configuration, and maintenance of SSRS reporting environments, UAT, Staging and production.
Monitor systems & responsible for availability which include data loads, imports & exports, file transfers, etc.
Responsible for restoring database using RMAN methods for backups and recovery manager.
Locate and correct problems involving file operations, I/O operations, and SQL*Net Modules of Oracle RDBMA on IBM UNIX.
Responsible for all production & development backups for disaster-recovery situations. Plan for systems growth and monitor capacity usage for new hardware or software requirements and communicate these capacity requirements to management.
Work with Citrix framework by installing various applications and giving access to Vendors, District Managers over extranet connection.
Work on JDA application such as JDA Allocation, JDA Enterprise Planning, and E3 Replenishment application. Responsible for all the installations of the new systems implemented within the organization & provided user-support for any user-login issues, data load issues, and application-related issues.
Work on NSB applications including Planning, Allocation & Replenishment. Managed all of the data load, and maintenance of these applications. Managed the Loss Prevention data load on the application known as Aspect 7.0 & 8.0. Also, managed the Customer Relation Market Works (CRM) application data load.
New York City School Construction Authority, LIC, NY 11/2005 – 4/2006
Role: Intern
Worked with various public schools projects which include all the database object schemas and models.
Responsible for the all Oracle software installations for many users in the organization. Setup all the software required on the work-stations for the users installing OS, & other necessary programs used for the users.
Porteck Corporation, New York, NY 7/2005 – 10/2005
Role: Intern
Worked in the testing department for the company’s new project that dealt with this new generation website which website designers created for the vendors. Tested all the new features which were introduced in the new project.
Found all of the bugs and reported them in the issue tracker system. Therefore, I made sure this new website had all of the new functionalities working consistently & properly.
Technical Expertise:
SQL*Plus, SQL Language using Microsoft Access, SQL Server Enterprise 2000/2005/2008/2012, Windows NT/98, Unix, DOS
Oracle7 - Oracle11g
SQL Server 2005, 2008, 2008 R2, 2012
Web Designing – HTML, Adobe Master Collection CS5 such as Flash, Fireworks, Photoshop, Dreamweaver
Crystal Reports, Visual Studios
Microsoft Office Applications – Word, Excel, PowerPoint, Outlook, Access, Project, & Visio
References: Available upon request
Contact this candidate