SKILLS:

Languages: T - SQL; Visual Basic; ASP .NET; C++; UNIX Shell Scripting

Environment: SQL Server 20 14/2012/2008 R2; Windows Server 2008R2/2012 Enterprise Edition; MongoDB

Applications: Windows PowerShell; VMware ; Active Directory; IBM Cognos BI ; Framework Manager and Data Manager; Pervasive Data Integrator ; Git, Redgate

EXPERIENCE

Confidential, New York, NY

Database Administrator and Developer

Responsibilities:

• Install, configure and maintain SQL Server 2014/ 2012/2008R2/2005
• Implement and manage mirroring, replication, log shipp ing , clustering, and AlwaysOn.
• Build, maintain and monitor scheduled processes that include SSIS packages, SQL Maintenance Plans and SQL Agent jobs executed both on demand and on schedules for backups, ETL and application functionality.
• Develop and maintain ETL processes in IBM Data Manager, SSIS and Pervasive Data Integrator for the data warehouse. Reconcile processed data with source system for completeness and accuracy.
• Build and maintain meta data model in IBM Framework Manager for the data warehouse.
• Design, implement and maintain highly customized relational database solutions in SQL Server.
• Collaborate with Product Managers, Project Managers, Business Analyst and various business groups.
• Implemented SQL server security best practices and transparent data encryption (TDE)
• Work on database integrity by performing backups, consistency checks, and performance monitoring.
• Work on optimizing query, tuning stored procedures and performance monitoring with developers

Confidential, New York, NY

Database Administrator

Responsibilities:

• Involved in upgrading multiple instance of environments of SQL Server 2000 to SQL Server 2008 to SQL Server 2012.
• Developed, designed and documented tables, view, stored procedures, advanced queries, triggers, indexes and functions.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Migrated databases and database objects between multiple servers across production, QA and development platforms.
• Involved in resolving locking and blocking issues.
• Maintain policies, procedures and technical documentation of all database systems .
• Perform data profiling on new and existing source data prior to logical and physical modeling. Audit data quality and advise stakeholders of potential challenges.
• Develop and maintain ETL processes in IBM Data Manager, SQL SSIS and Pervasive Data Integrator for the multiple heterogeneous OLTP systems and data warehouses .
• Build and maintain meta data model in IBM Framework Manager for the data warehouse.
• Responsible for Disaster Recovery Planning, Backup and Restoration, log shipping, user rights management Configuring and administering jobs and DTS/SSIS packages.
• Create logins & grant access to users as per requirement, creating and providing access to database application roles.
• Responsible for modifications and corrections to the database via help desk system.
• Discreet handling of sensitive and confidential information such as patient healthcare records, employee records and payroll.

Confidential, Long Island City, NY

Software Developer

Responsibilities:

• Design, develop, code, test, debug, modify & document applications using C++.
• Provides comprehensive configuration file management solution based ATM networks .
• Provide design recommendations for unit & integration testing in Quality C enter.
• Develop new functionality, modify existing configuration files and simulates an virtual ATM software environment

Confidential, NY

Assistant Network Engineer

Responsibilities:

• Set up, test, and evaluate systems such as local area networks, wide area networks, the Internet, intranets, and other data communications systems.
• Perform network modeling, analysis, and planning, which often require both hardware and software solutions.