< Back to Careers

Database Engineer and Administrator

We are growing our engineering team rapidly and are looking for great people to join the exciting software development world of Over the Top (OTT). We are seeking a talented and enthusiastic hands-on Database Engineer and Administrator.


OVERVIEW:

BrightLine is looking for a Database Engineer and Administrator to help accelerate the growth of our OTT advertising solutions and products. This position defines, creates and maintains enterprise databases in a client/server environment. Analyzes, tests, and implements physical/virtual database designs supporting various business applications including base definition, structure, documentation, long-range requirements, and operational guidelines. Ensures data recovery, maintenance, data integrity, and space requirements for database are met through formulations and monitoring of policies, procedures, and standards relating to database management. Administrates all MS SQL 2012 servers VMs, Azure SQL. Azure Data Lakes, Azure Data Lakes Analytics, Azure Data Factories and NoSQL environments, providing capacity planning and best practices for the future production/development/test environments, which may include establishing new standards and procedures.


RESPONSIBILITIES:

  • Evaluates designs and implements the physical structure and functional capabilities of the database; monitors database security and performs routine and disaster-related database back-up and recovery routines

  • Responsible for ensuring high availability and top-notch performance of the databases that support the company's system through managing backups/restores, database design, performance tuning, and patch management

  • Responsible for developing and debugging SQL Server and Azure SQL code (stored procedures, functions, triggers, packages)

  • Responsible for developing/deploying/managing the full ETL process

  • Responsible for developing/deploying/managing SSIS packages

  • Responsible for developing/deploying/managing SSAS packages

  • Responsible for working with other developers to developing/deploying/managing SSRS reports

  • Work to ensure that the associated hardware resources allocated to the databases are highly resilient, secure, and designed to minimize downtime

  • Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management

  • Assist Development and Management teams in the gathering and documentation of business requirements and analysis and design of databases, reporting and analytic tools that support the business’ short-term and long-term objectives

  • Assist in the evaluation and recommendation of 3rd party software solutions

  • Learn the business and present ideas and solutions that support the business’ long and short-term objectives and promoting and practicing company core business values

  • Provide the appropriate level of assistance to other internal IT/BI team members

  • Installs new, revised or updated database applications and optimizes user access techniques. Collaborates with the Network Administrator and core engineering staff to define installation requirements and ensure a seamless implementation process

  • Maintains and enhances database performance by: tuning values for database parameters; implementing new releases; completing routine and ad hoc database maintenance requirements and evaluating/recommending operating systems and hardware products that may improve database performance

  • Prepares and maintains SOP's for database operations and upgrades


QUALIFICATIONS:
      

  • Experience designing, implementing and supporting Microsoft SQL Server, and Enterprise Data Warehouse environments

  • Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, clustering, database mirroring, and replication

  • Ability to write, tune, and debug queries, T-SQL and PL/SQL code (stored procedures, functions, tables, views, triggers, indexes, constraints) in support functional/technical users and business applications

  • Experience in troubleshooting and resolving database integrity issues, performance, blocking/deadlocking, replication, log shipping, connectivity, and security issues

  • Willingness to document processes and procedures (creating KBs, runbooks, topologies, etc.)

  • Solid acquaintance with windows server, security delegation, SPNs, storage components

  • Experience in implementing operational automation

  • Bachelor’s degree in computer science or related field of study


ADDITIONAL QUALIFICATIONS, NOT REQUIRED:

  • Visual Studio.NET (VB, C#, asp.net)

  • Experience with Big Data and map-reduce based systems


Apply

Use this form to apply for this position.

Add your Cover Letter and Resume by pasting the contents into the specified fields. If preferred, you may add a URL for downloadable versions (via Google Drive, BOX, Dropbox etc.).

Applications without Resumes will not be considered.

Name *
Name