Database Administrator

Apply Now

Description

A Database Administrator, or DBA, is responsible for overseeing the maintenance and security measures of company databases.  Their duties includes planning, development and maintenance of databases, monitoring and updating malware protection software to combat potential security breaches, creating account data for authorized individuals to access databases and organizing databases so individuals can find important documents in an efficient manner.

    

PRIMARY RESPONSIBILITIES 

  •  Identifies, defines, and assesses the properties and specifications necessary for the database management system (DBMS) to meet current and future needs of the organization.
  • Defines a logical database structure for application development based on the organizational structure of the company.
  • Manages Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
  • Defines and executes procedures for testing and implementing new applications in the database environment.
  • Develops and implements policies and procedures related to data security and integrity.
  • Performs business analysis and writes effective documentation and specifications. Develops, implements, and monitors access policies, limiting database access on a need-related basis.
  • Develops, maintains, and controls additional corporate data libraries specific to the organization, industry, or locality.
  • Ensures project and department milestones and goals are met on time and within budget.
  • Assesses current and projected database performance and recommends changes and enhancements.
  • Creates and implements Disaster Recovery Planning and Security Management operations.
  • Drafts training documentation and guidelines for analysts and end users.
  • Resolves data conflicts for matters such as naming conventions, data privacy, and data ownership.
  • Maintains knowledge of trends, developments, and best practices in DBMS and related technology.
  • Implements the SQL Server mechanisms like FTS, MDS, online indexing, filegroups, security principals and Service Broker.
  • Supports Production Databases on call if needed.
  • Mentors team members and write documentation regarding feedback and performance.
  • Performs other duties and special projects as assigned.
SKILLS
  • Expert in T-SQL writing stored procedures and functions.
  • Expert in Backup Utility/Recovery, TSQL, Visio.
  • Expert in data transformation services and Bulk Loads with SSIS and ETL operations.
  • Proficient in SQL Server configuration, migrations/updates, and managing SQL Server security.
  • Familiar with Linked Servers. 
  • Familiar with batch processes, import, export, backup, database monitoring tools and application support.
  • Familiar with Mongo or other non-MS SQL databases
  • Familiar with Kendal data warehouse design. 
  • Familiar with Analysis Services (SSAS) Tabular.
  • Familiar using DMVs and dynamic management functions.
  • Familiar with NoSQL.
  • Familiar with DevOps.
  • Familiar with Azure.
  • Familiar with PowerShell.

COMPETENCIES 

  • Ability to work on logical and physical data base modeling with UML and ERWIN tools.
  • Must have a passion for data and its criticality to the successful operation of a business.
  • Comfortable communicating with all levels (interpersonal, written, and verbal).
  • Ability to prioritize and handle multiple tasks in a demanding work environment.
  • Ability to operate calmly in a high-pressure environment.
  • Flexibility to tackle problems and issues with enthusiasm and tenacity and recognize or anticipate issues that could disrupt productivity.
  • Willingness to adhere to all principles of confidentiality.
  • Ability to work independently and on a team. Must value operating in a collaborative work environment
  • Ability to show initiative, good judgment, and resourcefulness 

Requirements


· Bachelor’s degree in Computer Science or a related field preferred. 

· 10+ years of experience in Database Administration for large and complex databases in Windows SQL Server.

· Experience in database design, normalization, star and snowflake schemas. 

· Experience with database technologies (MS SQL Server 2012, 2014, 2016, 2019+).

· Experience with Windows Server environments. 

· Experience with programming technologies (TSQL, Python, R).

· Experience with network technologies (TCP/IP, DNS, DHCP, SFTP, SMTP).