Senior DBA

Hallmark Global Technologies is an end-to-end technology company that offers full-fledged software development services to businesses across industry verticals. Significantly, we help our clients to leverage on innovative technologies and remain competitive in the market. Hallmark Global Technologies is based in Delaware, USA.

Designs, develops, and maintains Microsoft SQL OLTP and OLAP databases in development, testing, and production environments. Administers and supports third-party vendor databases. Writes database code (stored procedures, scripts, triggers) and Integration Services packages for standalone use or for use by application programs. Implements and maintains adherence to accepted security standards. Oversees the stabilization and performance optimization of production databases. Functions as a Subject Matter Expert on database development

* Responsible for the full life cycle of all Microsoft SQL data base platforms. * Plans, designs, develops, and maintains SQL databases in development, Quality Assurance, and production environments. * Reviews project requests and guides less experienced DBAs. Provides cost, design, and work estimates. * Designs, recommends and promotes implementation of required database structures. * Develops and applies procedures relating to database and application security. * Monitors access time, performs validation checks and uses other methods to monitor and analyze database performance and ensures acceptable performance. * Develops and applies procedures for adhoc and regularly scheduled database backups and configrures databases to support individual recovery models. * Provides database restores and advises on long term storage of backups. * o Performs security related functions centered on NIST compliance including, automated scan reviews and remediation of vulnerabilities. * Identifies and advocates beneficial change opportunities. * Acts as a technical resource for application and data users, data administrators and others. * Serves as point of contact with technical peers for the resolution of infrastructure-related issues. * Performs analysis, feasibility studies and vendor comparisons leading to the acquisition of database related products. * Ensures compliance with HIPAA, privacy and government security policies. * Provides technical support and guidance for applications programming in support of all aspects of database systems. * Develops, monitor and enforces standards for all database platforms. * Creates databases, table spaces, tables, indexes, triggers, procedures, SQL Reports and all other objects. * Create and support SQL Integration Service packages. * Administer both internal and external facing SQL Reporting Services and Analysis Services implementation in development,testing and production. * Defines the content and structure of the database (schema) and advises users on efficient techniques for extracting data. * Consults with development groups concerning the impact new applications will have on the database. * Maintains accurate and up-to-date database system documentation. * Assures accurate preparation of database reorganization/restructuring schedules. * Supports all phases of testing. Correct errors and make necessary database modifications. * Evaluates and recommends purchases of new hardware and software to improve database design, analysis, performance and reliability. * Applies patches and application upgrades. * Performs other duties as assigned. * Regular and reliable attendance is required. * Work with Oracle DBA to establish standards and methods for the database environment. * Work with technical business groups to establish self-sufficiency for SQL report creation and deployment.

**Education & Experience Required** * Bachelor's Degree in Business Administration, Computer Science, Mathematics, Engineering or related field with programming and database systems coursework or equivalent database administration experience. * 4+ years as a SQL Database Administrator with progressively higher-level experience leading to a Senior Database Administrator role or equivalent. * Experience with all facets of the SQL Server Services group: Database Services, Reporting services, Integration Services and Analysis Services. Version 2008 R2 or higher. * Knowledge of VisualStudio 2008 and Team Foundation Server 2010. **Preferred** * Knowledge of Oracle administration for versions 11.202 and higher and Oracle Grid. **Competencies** * Technical Skills * Advanced knowledge of database design, development, and maintenance practices and principles, with specific experience in Microsoft SQL 2008 R2 and higher. Strong knowledge of SQL Server database service, Integrations service and Reporting service, and familiarity with SQL Analysis Service. Advanced knowledge in database procedures, tools, and utilities for maintaining and optimizing databases; strong understanding of database structure, application servers, and application infrastructure. Familiarity with Oracle administration 11.202 or higher and Oracle Grid. Understanding and experience implementing NIST security standards utilizing DOD STIGS. * Problem Solving / Analysis * Ability to solve problems through systematic analysis of processes with sound judgment; Has a realistic understanding of relevant issues * Organizational Skills * Ability to organize people or tasks, adjust to priorities, learn systems, within time constraints and with available resources; Detail-oriented. * Multi-Tasking / Time Management * Prioritize and manage actions to meet changing deadlines and requirements within a high volume, high stress environment. * Information Management * Ability to manage large amounts of complex information easily, communicate clearly, and draw sound conclusions. * High Intensity Environment * Ability to function in a fast-paced environment with multiple activities occurring simultaneously while maintaining focus and control of workflow. * Coping / Flexibility * Resiliency in adapting to a variety of situations and individuals while maintaining a sense of purpose and mature problem-solving approach is required. * Computer Literacy * Ability to function in a multi-system Microsoft environment using Word, Outlook, Intranet, the Internet, and department software applications. * Communication / People Skills * Ability to influence or persuade others under positive or negative circumstances; Adapt to different styles; Listen critically; Collaborate.