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.
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.
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
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
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.