PROFESSIONAL SUMMARY:

• Over 10+ years of experience in the IT industry as a Database Administrator, hardware/software system engineer, which includes more than 7+ years as a SQL Server database administration, data modeling, designing, coding, testing and supporting next - generation database solutions using MS SQL Server, and MS Access environment.
• Outstanding problem solving and analytical decision-making skills with proven ability to conceptualize solutions to challenging situations.
• Proven Abilities to work successfully and independently in an atmosphere of multiple projects, shifting priorities, and deadline pressures.
• Persistent dedication to maintaining up-to-date industry knowledge.
• Good oral and written communication skills to effectively communicate technical information to both technical and non-technical personnel.

TECHNICAL SKILLS:

Database Servers: SQL Server 2014/2012/2008 R 2/2008/2005/2000 , MS Access, MySQL, and Oracle (11g)

Database Tools: Enterprise Manager, SQL Server Management Studio, SSIS, DTS, Business Intelligence Development Studio (BID), Database Mail, SQL Mail, SQL Agent Query Analyzer, SQL Profiler, Tuning Advisor, Index Tuning Wizard, Replication, Clustering, Database BCP, SQLCMD, Reporting Services, Report Manager, Reporting Services Configuration and Report Builder, Upgrade Advisor, SQL Server Configuration manager and Service manager, Client and Server Network Utilities, Idera diagnostic manager, Foglight monitoring tool, Litespeed Backup, BMC Remedy, Microsoft service manager, Symantec Netbackup, Toad for SQL Server and MS Visio.

Data Modeling/Database Reporting Expertise: SQL Server Database Diagrams, Visio, SQL Server Reporting Services (SSRS), Experienced in SQL Server Analytical Services.

ETL Tools: SSIS/DTS, BCP, OSQL, ISQL

Reporting/Analysis Tool: SSRS (SQL Server Reporting Services)Data Modeling: SSDD (SQL Server Database Diagram), VISIO 2003/2007/2012

Operating Systems: Windows Server 2012R2, 2008R2, 2003, Windows 2000 server, Windows 7 Professional, Windows XP Professional, NT 4.0, Windows 95, and Novel Netware v5.0, VMware

Software: BMC Remedy, Idera Diagnostic Manager, Idera SQL Doctor, Lightspeed Backup, Symantec NetBackup, Foglight Monitoring, MS Outlook

Networking Related Expertise:: Managing User accounts using Active Directory, Implementation of TCP/IP & related Services like DHCP, Configured workstations for IP based LAN TCP/IP knowledge with emphasis on SNMP, DNS, SMTP, and HTTP.

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

SQL Database Administrator

Responsibilities:

• Support Electronic trading systems with responsibility for handling problems, monitoring, and responding to queries regarding the functions of the application databases, as well as upgrading the system integration and QA through our user acceptance and production.
• Preform security maintenance for smooth trading platform that enables fixed-income market participants to efficiently trade asset classes, including TBA-MBS, U.S. agencies, U.S. Treasury securities and outright, roll and swap, bonds, securities, and others.
• Responsible for management and support of all application databases and environments
• Provide administration and support for our development team, creating permanent solutions using standards and automation and facilitating a stable and reliable trading environment across platforms and systems.
• Day to day support and administration of MSSQL server 2008R2, 2012 and 2014.
• Proactively manage mission critical databases/servers for 100% uptime during trade hours.
• MSSQL server installation, configuration, maintenance, version upgrade, and migrations.
• Perform backup, recovery, install and manage database infrastructure, user/security management, capacity planning and performance tuning for various enterprise applications running on SQL Server
• Setup and monitor replication for HA/DR solution using Replication.
• Ensure compliance with departmental policies, change management, IT security standards.
• Interact with various internal IT support functions, Development, Quality Assurance, Operations, and external 3rd party vendors to troubleshoot and resolve problems.
• 24 X 7 Production Database on Call Support

Confidential, Chevy Chase, MD

SQL Database Administrator

Responsibilities:

• Managed SQL instances of SQL Server 2005, 2008/2008R2, 2012 and 2014 hosting VLDB.
• Installation, configuration and maintenance of different SQL Server versions.
• Installation & configuration of multi-node SQL cluster up to 4 nodes.
• Applied latest Service Packs and Hot fixes.
• Resolved performance issues and optimization of databases using Performance Tools such SQL Profiler and Database Engine Tuning Advisor, checking Query execution Plans.
• Implemented and administered SQL Server High Availability (Failover Clustering, DB Mirroring, Replication, Log Shipping, Always On)
• Designed database Backup & Recovery, DR planning, and Perform point in time recovery.
• Manage Database Security & access audit.
• Maintained, preformed new deployments and Troubleshoot SQL Server Reporting Services (SSRS) & SQL Server Integration Service (SSIS) packages.
• Performed business analysis and write effective documentation.
• Assisted development & application teams developing applications using SQL Server 2005, 2008, 2012 and 2014.
• Routinely migrated databases from SQL Server 2005 SQL Server 2008 to SQL server 2012 and 2014 versions.
• Completed data migration from Oracle/Access/Excel Sheets to all versions of SQL Server.
• Worked in OLTP and OLAP environment that includes Production, QA and development SQL databases
• Monitoring SQL server with third party tools Idera Diagnostic Manager, SCOM, SQL Diagnostic.
• Resolving issues reported by users in ticketing system.
• Identified & suggested improvement areas within SQL server
• Creating logins, assigning roles, resolve connectivity errors
• Planning, testing & executing SQL S erver upgrade/migration
• Worked with Development team to determine SQL Engineering & Development, Project planning & execution and capacity planning, and obtain deeper knowledge of SQL integration with enterprise applications.

Confidential, Downers Grove, IL

SQL Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2000, 2005, 2008, 2008 R2 in development, test, and production environment
• Applied SP (Service Pack) on SQL Server 2000, 2005, 2008 and 2008 R2
• Installed, Configured and Maintained Database Mirroring, Replication, Log Shipping and Cluster environment
• Configured and Maintained Database Replications, Log Shipping including Standby database for reporting purposes
• Managed Backup/Restore, Point-in-Time Recovery including backup verification, security
• Upgraded databases from SQL Server /2008 in testing and production environment
• Expertise in database Performance tuning
• Created and managed Index, Constraints, Keys (PK, FK), T-SQL, Stored-Procedures, Triggers
• Export & Import data from Flat file, CSV and other file to/from SQL Server Database using DTS, SSIS, and BCP
• Setup automated jobs for different purposes including backup, monitoring database health, disk space, backup verification, moving databases from environment to environment including creating test environment
• Monitor Server Activity, Error Logs, space usage, and solving problem as needed
• Scheduled jobs to automate different database related activities
• Strong on database Monitoring and Performance tuning
• Serve as lead on small and medium projects involving in IT integration between Confidential and Coventry resources
• Works closely with technical and client management to design and implement databases and database support tools to support complex business application development requirements and processes

Confidential, NJ

SQL Database Administrator

Responsibilities:

• Expertise in installation, up gradation and configuration SQL Server 2000/20 R2
• Applied Service Packs and Hot Fixes for 2000/2005/2008
• Migration - Performed database migration from SQL Server, and 2008
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities
• Implemented the new SQL Server 2005 concepts like Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, security with principals and securable etc.
• Administration of development and production servers running SQL Server 2000, 2005, and 2008 including creation of indexes, tables, stored procedures and security policies.
• Served as DBA on various medium to large scale projects on implementations, managing projects from business requirements analysis, designing ER Diagram (Data Modeling), Forward & Backward Engineering, administering database and supporting clients
• Developed and tested storage strategies and disaster-recovery plan for large operational database, delivering solution that guaranteed recovery performance and high availability
• Scripting of stored procedures and ad hoc queries and triggers.
• DBA responsibilities also included routine maintenance such as backups, and recoveries, applying patches, upgrades and performance monitoring; OS file level defragmentation and database level index defragmentation.
• Designed and implemented monitoring tool for capturing Log Events for Production Servers performance monitoring and alert messages for blockings
• Ensured SQL Server replication and mirrored database were operating as planned
• Experienced in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints
• Performed performance tuning using SQL Server profiler, Database tuning advisor, Windows performance monitor, Query Analyzer and fine tuning of long running queries and stored procedures and slow running server
• Experience in Importing/Exporting Data from various data sources like Excel, Oracle and Flat file using BCP, Bulk Insert, DTS utility and SSIS.
• Created documentation for installation, monitoring procedures, security policies, configuration changes, migration procedures, deployment procedures and best practices

Confidential, Dayton, NJ

SQL Database Administrator

Responsibilities:

• Involved in Analyzing and Upgrading SQL Server 2000 test servers to SQL Server 2005
• Responsible for SQL Server 2000/2005 production databases in large scale, maintenance, upgrade and installation in clustered failover and SAN storage environment, database instance and server level performance, and space usage monitoring
• Detail plan for database replication, backup and stored procedure for disaster recovery and standby log-shipping, daily DTS developing and implementation
• Monitored SQL Server performance using profiler to find performance and dead locks
• Monitored and modified performance using execution plans and index tuning
• Designed and created databases, tables, views, stored procedures and triggers
• Monitored and modified Performance using execution plans and Index tuning
• Rebuilding and reorganizing the index on scheduled basis.
• To analyze long running slow queries and tune the same to optimize application and system performance
• Resolved and tweaked memory pressures caused during product release.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Export & Import data from other data sources like flat files using Import/Export through DTS.
• Setting up and maintaining security at the database as well as server level
• Used 3rd party back up tool such as LiteSpeed, Netback up (System level back up)
• Preformed query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands for troubleshooting.

Confidential, New York, NY

System Admin/Jr. SQL Database Admin

Responsibilities:

• Installed, configured, and administered Windows Server 2003, 2003 R2
• Configured and AD (Active Directory)
• Configured and Managed Telnet and Remote Servers
• Configured and Managed DNS, Forward Engineering, Backward Engineering, Forest
• Imaging Servers and Restored
• Configured clients Machines with the domain for Windows XP
• Upgraded Clients Machines - Pushing updates
• Applied SP (Service Packs) for Windows
• Worked with Sr. DBAs and implemented SPs for SQL Server Instances
• Worked on Database Backups and Restoration of SQL Server 2000 and 2005