Sr. SQL Server DBA - North Carolina, United States - Yoh, A Day & Zimmermann Company

Yoh, A Day & Zimmermann Company North Carolina, United States

3 weeks ago

Yoh, A Day & Zimmermann Company background

Description

The DBA assists in the administration and management of Production, Development and QA Databases in a multi-server, mission critical windows server environment. This includes the use of knowledge of Microsoft SQL 2000/2005 and SQL query language to assist in the creation and management of databases. The individual will assist developers and members of the stability team in the isolation and correction of database related errors to eliminate problems and make improvements.

The Sr. Database Administrator's role will be responsible for the installation, configuration, maintenance, monitoring, operation support and performance of critical database systems, to ensure high availability and consistent performance of our corporate applications. The Database Administration team provides 24x7 database and production support for all database systems ensuring their database integrity, security and availability. This is a "hands-on" position requiring solid technical skills with advanced skillsets with SQL Server performance, as well as excellent interpersonal and communication skills to perform Production Support of financial applications using database technologies of MSSQL

Responsibilities:

• Responsible for design, installation, configuration, security and maintenance of highly available enterprise database systems

• Troubleshoot and resolve database incident tickets.

• Monitor backup jobs on all enterprise databases and perform routine disaster recovery scenarios

• Participate in on-call after-hours support rotation, responding to support calls after- hours/weekends/holidays.

• Establish and maintain database policies and standards

• Generate database schema definitions and modifications as required

• Plan and coordinate data refreshes from one environment to another

• Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.

• Monitor, optimize and allocate physical data storage for database systems.

• Develop, implement, and maintain change control and testing processes for modifications to databases.

• Create, or support creation of, required reports in response to business user needs.

• Perform database transaction and security audits.

• Follow and maintain in-house documentation for repeatable processes, including database feature installation, disaster recovery, and common problem resolution

• Establish appropriate end-user database access control levels.

• Develop routines for end users to facilitate best practices database use.

• Follow ITIL (Information Technology Infrastructure Library) practices for Change Management.

Formal Education & Certification:

Bachelor's Degree in the field of computer science/engineering and/or 5 years equivalent work experience with SQL Server database administration and/or SQL Server development.

MCDBA and or MCIT Certification desirable

Essential Skills & Experience:

• 5+ years direct experience managing and supporting Microsoft SQL Server version

• Knowledge and experience in Database Performance, Tuning and Optimization (PTO)

• Excellent knowledge in system views and system stored procedures using T-SQL.

• Hands on experience with database security, auditing, backup/restore, DR and high availability

• Experience with data partitioning, indexing best practices, resource governor, extended events

• Experience with DTS and SSIS Packages.

• Experience in installation and configuration of SQL Server in Virtualized Environments

• Experience in PowerShell a plus

• Experience in Solarwinds Monitoring and DPA (Ignite) a plus

• Experience in financial services is a plus.

• Knowledge of applicable data privacy practices and laws.

• Knowledge of Incident/Problem Management and is familiar with ITIL processes in a critical production environment.

Personal Attributes:

• Good written and oral communication skills.

• Strong technical documentation skills.

• Good interpersonal skills.

• Ability to conduct research into database issues, standards, and products as required.

• Ability to present ideas in user-friendly language.

• Highly self-motivated and directed.

• Keen attention to detail.

• Proven analytical and problem-solving abilities.

• Ability to effectively prioritize and execute tasks in a high-pressure environment.

• Strong customer service orientation.

• Experience working in a team-oriented, collaborative environment.

SQL Server DBA

3 weeks ago

General Dynamics Information Technology Washington, United States

Req ID: RQ175143 · Type of Requisition: Regular · Clearance Level Must Be Able to Obtain: None · Public Trust/Other Required: Other · Job Family: Database Analysis/Design · Skills: · Microsoft SQL Server,Microsoft SQL Server DBA,SQL Database Queries,SQL Query Writing,Standard Que ...
SQL Server DBA

3 weeks ago

General Dynamics Information Technology Washington, United States

A career as a SQL Server SME / DBA at GDIT means being a critical part of successful data outcomes. Here, your work can accelerate solutions for our clients while you accelerate your career. Own the opportunity to build your skills as you oversee our client's database environment ...
SQL Server DBA

2 weeks ago

General Dynamics Information Technology Washington, United States

A career as a · SQL Server SME / DBA · at GDIT means being a critical part of successful data outcomes. Here, your work can accelerate solutions for our clients while you accelerate your career. Own the opportunity to build your skills as you oversee our client's database environ ...
4-20 SQL Server DBA LU

3 weeks ago

Focused HR Solutions Columbia, United States Freelance

Our direct client has an opening for a SQL Server DBA rec This position is 12 months, with an option of extension, and is in Columbia, SC. · W2 only no 1099's or subcontracting allowed for this client. · Responsibilities:Monitors our SQL environment to ensure secure services with ...
4-20 SQL Server DBA LU

1 week ago

Focused HR Solutions Columbia, United States Freelance

Our direct client has an opening for a SQL Server DBA rec This position is 12 months, with an option of extension, and is in Columbia, SC. · W2 only no 1099's or subcontracting allowed for this client. · Responsibilities:Monitors our SQL environment to ensure secure services with ...
4-20 SQL Server DBA LU

6 days ago

Focused HR Solutions Columbia, United States Freelance

Our direct client has an opening for a SQL Server DBA rec This position is 12 months, with an option of extension, and is in Columbia, SC. · W2 only no 1099's or subcontracting allowed for this client. · Responsibilities:Monitors our SQL environment to ensure secure services with ...
SQL Server DBA

3 weeks ago

General Dynamics Information Technology Washington, United States

Req ID: RQ175833 · Type of Requisition: Regular · Clearance Level Must Be Able to Obtain: None · Public Trust/Other Required: Other · Job Family: Database Analysis/Design · Skills: · AWS Architecture,Microsoft SQL Server,Microsoft SQL Server DBA,SQL Database Queries · Experience: ...
SQL Server DBA

3 weeks ago

General Dynamics Washington, United States

Responsibilities for this Position · Location: USA DC Washington - 800 Independence Ave SW (DCC075) · Full Part/Time: Full time · Job Req: RQ175143 · Type of Requisition: · Regular · Clearance Level Must Currently Possess: · Other · Clearance Level Must Be Able to Obta ...
SQL Server DBA

2 weeks ago

General Dynamics Washington, United States

Responsibilities for this Position · Location: USA DC Washington - 800 Independence Ave SW (DCC075) · Full Part/Time: Full time · Job Req: RQ175833 · Type of Requisition: · Regular · Clearance Level Must Currently Possess: · Other · Clearance Level Must Be Able to Obta ...
SQL Server DBA

3 weeks ago

General Dynamics Information Technology Washington, United States

A career as a · SQL Server SME / DBA · at GDIT means being a critical part of successful data outcomes. Here, your work can accelerate solutions for our clients while you accelerate your career. Own the opportunity to build your skills as you oversee our client's database envir ...
SQL Server DBA

3 weeks ago

General Dynamics Information Technology Washington, United States

A career as a SQL Server SME / DBA at GDIT means being a critical part of successful data outcomes. Here, your work can accelerate solutions for our clients while you accelerate your career. Own the opportunity to build your skills as you oversee our client's database environment ...
SQL / SQL Server Database Administrator (DBA)

3 weeks ago

Bart & Associates Washington, United States

B&A is looking for an SQL / SQL Server Database Administrator (DBA) to join a contract with a federal government client in support of an important mission. As a vital member of our organization, you will be responsible for the performance, integrity, SQL, Database Administrator, ...
Restaurant Team Member

4 weeks ago

Golden Corral Columbia, United States Part time

Our franchise organization, C and D Enterprises dba Golden Corral, is currently seeking energetic, friendly individuals to join our team · Golden Corral restaurants are currently accepting applications for the opportunity to join our team with our family buffet restaurant chain ...
Server

3 weeks ago

GC Partners, Inc. dba Golden Corral Columbia, United States

Our franchise organization, GC Partners, Inc. dba Golden Corral, is currently seeking energetic, friendly individuals to join our team · The main responsibility of the Server is "Making Pleasurable Dining Affordable." Fulfilling Golden Corral's mission statement requires a posit ...
Server

2 weeks ago

GC Partners, Inc. dba Golden Corral Columbia, United States

Job Description · Job DescriptionOur franchise organization, GC Partners, Inc. dba Golden Corral, is currently seeking energetic, friendly individuals to join our team · The main responsibility of the Server is Making Pleasurable Dining Affordable. Fulfilling Golden Corrals miss ...
Database Developer

3 weeks ago

firstPRO, Inc North Carolina, United States

firstPRO is now accepting resumes for a Database Developer role in Greenville, NC. This is a direct hire role and remote (must come onsite for interview process/orientation). · What You'll Do: · Plans, designs, develops, and implements the company's databases and data warehouses. ...
Database Developer

4 weeks ago

firstPRO, Inc North Carolina, United States

FirstPro is now accepting resumes for a Database Developer position based in North Carolina. This role will focus on maintenance and development of corporate data repositories in support of the application portfolio across the company using SSIS, T-SQL, Snowflake and SQL Server. ...
CRM Developer

3 weeks ago

Unicorn Technologies, LLC Columbia, United States contract

Title Contract CRM DeveloperStart Date ASAPDuration 6 months(with extensions)Work hours 8 00a.m. to 5 00p.m. (may vary)is looking for a contract Microsoft Dynamics CRM Developer/ Lead Developer. Candidate will lead an onshore and offshore team of developers for a large multi-inst ...
AWS RDS Engineer

2 weeks ago

edgecomputingassociation West Columbia, United States

Location Columbia, South Carolina , · United States · AWS RDS Engineer (Aurora, Postgres, SQL/Server) · Position Description · CGI has an immediate need for an AWS RDS Engineer (Aurora, Postgres, SQL/Server) to join our financial services team in one of our selected CGI locat ...
Oracle R12 Apps DBA

2 days ago

HarmonyTech Washington, United States

HarmonyTech Inc. is seeking an experienced Oracle EBS R12 Applications DBA with expertise in Single Sign-on with R12 and OBIEE environments to support our federal client. The successful candidate must have six (6) years of Oracle Apps DBA experience in Oracle R12 Federal environm ...