Database Administrator and Developer Resume New York, NY - Hire IT People

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.

We provide IT Staff Augmentation Services!

Database Administrator And Developer Resume

New York, NY

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship