Security Clearance Jobs for Defense and Intelligence Careers

Questions? Call Us 888-725-6997


View Job

Database Administrator

ABBTECH Professional Resources Inc. | Brooklyn NY 11201 USA | Full Time | Posted: 06/30/2020

Job Descriptiontop



?    Manages data requirements gathering and analysis for new and existing projects.
?    Supports Microsoft SQL Server 2012/2014/2016 databases across all environments.
?    Supports Microsoft SQL Server 2012/2014/2016 replication feature widely used by different applications.
?    Supports Microsoft Windows 2012 and 2016 Enterprise Servers including configuration and maintenance.
?    Implements and supports Microsoft Clustering Services both on the SQL Server and System levels.
?    Installs and configures Microsoft SQL Server 2012/2014/2016 and Microsoft Windows 2012 and 2016 servers.
?    Monitors Microsoft SQL Server activity on a proactive basis and tune the system for optimal performance.
?    Creates, designs, manages and troubleshoots SSIS packages.
?    Monitors and troubleshoots ETL jobs daily using BCP, DTSRUN, SSIS and other Performance Monitoring tools.
?    Maintains error and system maintenance logs.
?    Performs OLAP and OLTP Data modeling with the ERWIN data modeling tool.
?    Supports Operational data model and data mapping.
?    Supports the development and maintenance of DOE application data dictionary.
?    Manages and supports DB2 relational system and troubleshoot issues on the DB2 System.
?    Administers DB2 Connect, DB2 Gateway in different ETL set up.
?    Investigates, analyzes and troubleshoots system performance and suggest/implement tuning as needed.
?    Develop system tools and utilities (i.e. scripts, etc.) to simplify and support IT and business operations.
?    Plan, implement and manage systems initiatives with IT and customer teams.
?    Designs database tables utilizing import or export data from SQL Servers into other data sources on a daily basis through the development and coding of stored procedures and triggers, as needed.
?    Establishes documents and maintains technical standards and server security policies.
?    Patches servers, both software and firmware, on a scheduled basis as well as urgent security releases.
?    Conducts performance monitoring, capacity planning, trend forecasting.
?    Documents and improves upon processes, procedures, and best practices to align with industry standards and customer needs.
?    Configures and optimizes Database System Configuration and Database Availability Reporting.
?    Documents and improves upon processes, procedures, and best practices to align with industry standards and customer needs.
?    Designs and implements database disaster recovery requirements to ensure business continuity requirements are met.
?    Provides a high-level of customer satisfaction to internal and external customers, applying necessary sense of urgency and creativity in problem identification and prompt incident resolution.

?    Provides advanced systems administration and support capability.
?    Analyzes system performance; suggests and implements tuning as needed.
?    Installs additional OpenSource and commercial software products as needed to develop, deploy, and support the platform.

Project Specific Technical Requirements: 

Proficiency in preparing, maintaining SQL server installation and configuration documents.

9+ years of experience in the following:

Query optimization experience with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.

8+ years of experience in the following: 

?    Database Normalization, logical and physical modelling, capturing data lineage, table and column data definitions, valid values and others necessary information in the data models.
?    Enforcing standards and best practices around data modelling efforts.
?    SQL Server installation of SQL Server and updating with service packs and patches.
?    SQL Server setup and configuration on Windows Servers and Linux.
?    Installing and configuring SQL Server 2014/2016/2019 on the server and client machines, provide connections and manage databases.
?    SQL Server installation on stand-alone and Windows Server Clustered environments.
?    Administering the MS SQL Server security by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
?    Installing and configuring MYSQL databases.
?    Installing, authoring, and managing reports using SQL Server 2016 Reporting Services.
?    Performing daily database tasks including backup and restore by using SQL Server native tools and third  party software, including VERITAS net backups and Lite speed backups.
?    Developing automated routine tasks for backup, restore and DBCC scripts for databases maintenance, optimization and transaction logs.
?    Performing backup and data compression using different editions of SQL Server.
?    Administering and monitoring MYSQL databases.
?    Planning, gathering the pre-deployment information and deployment of the third party tools like IDERA SQL Diagnostic, Dynatrace AppMon, and Quest Foglight etc.
?    Backup and recovery implementation Strategy for 24x7 operation support.
?    Designing and implementing enterprise data warehouse solutions.

?    Developing ETL Scripts to enable data processing into data warehouse.
?    Working on developing robust data warehouse dictionary.
?    Designing cubes in SSAS environment using Snowflake and Star Schemas.
?    Configuring Report manager, PowerBI Servers, implementing role-based security to end users and developing report models for creating Ad-hoc reports using SSRS.
?    Tuning queries and databases for better performance.
?    Creating and maintaining Database Maintenance Plans.
?    Performing SQL Server maintenance tasks including Database Integrity checks, update database Statistics and Re-indexing.
?    Configuring data partitioning/table partitioning on huge tables containing millions of rows for better performance.
?    Creating database objects including Stored Procedures, Triggers, Views and Functions for the application using T-SQL.
?    Performance tuning experience, modification of Complex Stored procedures to improve efficiency of the system.
?    Supporting day to day operational activities for the database platform like service requests and tickets, monitoring, performance tuning, troubleshooting long running queries, locks, deadlocks and performance issue like CPU, I/O, Memory bottlenecks, Backup and Restore, SQL jobs.

5+ years of experience in the following:

Strong PowerShell experience for developing routine daily maintenance tasks.

ABBTECH is an EOE/Minorities/Women/Disabled Individuals/Veterans

Job Detailstop

Location Brooklyn, NY, 11201, United States
Categories Professional
Sec Clearances Other

Location Maptop

Contact Informationtop

Contact Name Terrance Williams
How to apply A resume is required to apply to this job. Applications are sent to employer via email. Click on the link below and follow instructions.
Apply Click Here (apply to job)
Primary Phone 703-489-0263
Job Code 19061