Senior SQL Server DBAIBR (Imagine Believe Realize) • Suitland, MD, United States

No se aceptan más aplicaciones

Senior SQL Server DBA

IBR (Imagine Believe Realize) • Suitland, MD, United States

Hace 20 días

Tipo de contrato

A tiempo completo

Descripción del trabajo

The Sr SQL Server DBA must be able to meet the key criteria below :

Location : Initially remote support with hybrid support in Suitland, MD after pandemic
Years’ Experience : 7+ years
Education : Bachelors degree in IT related field
Clearance : Must be able to obtain and maintain a Public Trust Clearance
Work Authorization : Must be a US citizen
Job Status : Full-Time

Key Skills :

SQL Server 2008 / 2012 / 2014 / 2016 experience required

Experience with AlwaysOn Failover Cluster Instances (FCI) and Enterprise Level SQL Server Farms

Experience with Windows Clustering

Experience supporting SharePoint a bonus

Database Certification in at least one : Microsoft Certified Solutions Expert certificate – Data Management and Analytics, Data Platform & Business Intelligence (i.e MCSE, MCSA, MCP, etc.)

Experience migrating systems to MS Azure a plus

Responsibilities

Be able to work with clients, peers and management in a highly visible, mission critical environment

End-to-end knowledge of MS SQL server database technologies including MS SQL Clusters and AlwaysOn Failover Cluster Instances (FCI)

Experience with deploying and maintaining Enterprise Level SQL Server Farms and AlwaysOn Failover Cluster Instances (FCI)

Evaluate, implement and maintain Microsoft technology, security updates, hot fixes, upgrades and version releases to ensure architecture stability

Configure and manage Microsoft's Windows Server 2008 / 2012, Windows Clustering on a spanned VLAN, and SQL Server 2008 / 2012 / 2014 / 2016, demonstrating how these technologies may be leveraged to impact the architecture's overall design, security, availability and stability

Solution development and integration of value-add applications to meet new requirements.

Provide troubleshooting of database instances and OS level support in a consolidated SQL Server environment leveraging a wide-array of configurations, including local and multi-site failover clustering

Demonstrate ability to analyze resource bottlenecks and provide suggestions to team, management, and internal customers on how to alleviate pressure and plan for capacity

Provide recommendations and strategies to application owners on how to improve performance and scalability of their database components

Install, upgrade and administer SQL Server database engine, Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS)

Provide architectural guidance on strategies to improve operations and monitoring of current and future implementations.

Ability to implement physical designs from logical designs

Prepare technical documentation

Designs, builds, and maintains structure (e.g. relational) and unstructured databases within a multiple tier environment

Performs data access analysis design, and archive / recovery design and implementation.

Develops strategies for data acquisitions, archive recovery, and implementation of a database.

Translates business requirements and database administration operational requirements into long-term architecture solutions.

Reviews and develops object and data models and the metadata repository to structure the data for better data management and performance.

Performs all activities related to the administration of computerized databases.

Conducts quality control and auditing of databases in a multiple tier environment to ensure accurate and appropriate use of data.

Designs, implements, and maintains complex databases with respect to JCL, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods.

Applies knowledge and experience with database technologies, development methodologies, and front‐end (e.g. COGNOS) and back‐end programming languages (e.g. SQL). Performs database programming and supports systems design.

Includes maintenance of database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems through database design.

Qualifications

7+ years experience in Database Administration, System Analysis and Administration, Design, Development & Support of MS SQL Server 2012, 2014, 2016 in Production, Development & Replication Environments

7+ years experience in installation, configuration, and maintenance of MS SQL Server 2012 / 2008

5+ years experience as a MS SQL Server Developer / Administrator with extensive experience in SSIS / SSRS

Database Certification in at least one : Microsoft Certified Solutions Expert certificate – Data Management and Analytics, Data Platform & Business Intelligence.

Proficient experience in upgrading and migrating from SQL Server 2008 to SQL Server 2012 / 2014 / 2016

Candidate must currently be working as a Senior SQL DBA supporting an environment with 50 to 100+ combination of virtual and physical SQL servers.

Extensive experience in maintaining High Availability using AlwaysOn / FCI, Database Mirroring, and Log Shipping capabilities of MS SQL Server 2012 to provide robust database solutions

Experience with ETL Tools such as SQL Server Integration Services package development (SSIS), SQL Server Reporting Services report development (SSRS), and SQL Server Analysis Services (SSAS)

Experience implementing and managing SQL Server high-availability technologies (replication, mirroring, failover clusters, etc.)

Experience with Database Backup, Recovery and Disaster Recovery procedures

Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity.

Extensive experience in Windows Server 2008 / 2012

Experience implementing and managing Windows clustering and AlwaysOn Failover Cluster Instances (FCI)

Expert in implementing database mirroring and log shipping

Experience in performance tuning, query optimization, client / server connectivity, and database consistency checks using DBCC utilities

Experience implementing different types of Replication Models like Snapshot, Merge and Transactional.

Experience working with VMWare for SQL Server

Experience managing security of SQL Server 2012, 2016

Experience in Active / Passive or Active / Active Clustering

Strong verbal and written communication skills and strong sense of ownership

About IBR

Imagine Believe Realize, LLC (IBR) is an emerging small business focused on delivering software and systems engineering solutions to government and commercial clients. Our talent acquisition strategy is tailored to career seeking candidates who embrace continuous learning and desire to grow as a professional in the software / systems engineering industry. We strive to enhance our team members ability to thrive in the workplace by creating a proper work / life balance and first-class benefits package that includes :

Nationwide medical, dental, and vision insurance

3 weeks of paid time off + 10 paid federal holidays

401k matching

Short term, Long term, and Life insurance disability insurance at no cost to our employees

Health care flex spending accounts and Dependent care flex spending accounts

Training opportunities

IBR is an Equal Opportunity and Affirmative Action Employer. It is our policy to offer employment opportunity to all persons without regard to race, color, age, national origin, religion, sex, gender identity / expression, sexual orientation, transgender status, veteran status, disability, genetic information, pregnancy, childbirth or related medical conditions, or any other status protected under applicable federal, state, or local law. IBR does not discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant.

Learn more at

If alternative methods of assistance are needed with the application process, additional contact information has been provided below :

info@teamibr.com

407.459.1830

Crear una alerta de empleo para esta búsqueda

Senior SQL Server DBA • Suitland, MD, United States

Ofertas similares

Senior SQL Server DB Developer — Onsite DC

Edgewaterit • Washington, DC, United States

A tiempo completo

A federal solutions provider is seeking a Senior Applications Developer to support the Federal Reserve Board in Washington, DC. This onsite role requires extensive experience with Microsoft SQL Serv...Mostrar más

Última actualización: hace 3 días • Oferta promocionada

Eliassen Group • Washington, DC, US

Indefinido

The organization is a premier technology integrator delivering technical, engineering, intelligence, and enterprise IT solutions across mission and enterprise lifecycles. Teams design, develop, and ...Mostrar más

Última actualización: hace 4 días • Oferta promocionada

Senior PostgreSQL Database Engineer - Active TS / SCI required

Medium • Washington, DC, United States

A tiempo completo

Senior Database Engineer (DBE).Senior Database Engineer (DBE).Research and Development (R&D) work at the Naval Research Laboratory in Washington DC. The Senior DBE will design and build PostgreSQL d...Mostrar más

Última actualización: hace más de 30 días • Oferta promocionada

Database Administrator, Senior, PostgreSQL

Cayuse Holdings • Washington, DC, US

A tiempo completo

The Database Administrator, Senior, PostgreSQL will support the database operations for our client to strengthen and expand the client’s production environment. This role will ensure the perfo...Mostrar más

Última actualización: hace 5 días • Oferta promocionada

Senior Database Engineer

TekSynap • Washington, District Of Columbia, United States

A tiempo completo

Responsibilities & Qualifications RESPONSIBILITIES.Position is required to be full-time onsite at DOT HQ, Washington DC.Assist in driving, standardizing, and managing unified configuration manageme...Mostrar más

Última actualización: hace 1 día • Oferta promocionada

Senior Database Administrator

Fusion Technology • Remote, VA, USA

Teletrabajo

Leidos • Washington, DC, United States

A tiempo completo

A leading defense contractor in Washington is seeking a skilled Database Engineer to support the DHS Insider Threat Program. The role involves maintaining database infrastructure, performing routine...Mostrar más

Última actualización: hace más de 30 días • Oferta promocionada

Remote Database Administration Leader (AWS RDS / EC2)

SitusAMC • Washington, District Of Columbia, United States

Teletrabajo

A tiempo completo

A leading real estate technology company is seeking a Senior Database Administrator to lead their Database Administration team in Washington, DC. This role involves overseeing AWS RDS and EC2 databa...Mostrar más

Última actualización: hace 1 día • Oferta promocionada