Sr Database Admin

Job Description:

The Database Administrator III manages the enterprise database management system. This resource coordinates across business lines to support, drive, and initiate projects while maintaining a highly available, secure and finely tuned environment. This role is responsible for ownership of enterprise wide database environment as well as supporting all interactive systems.

Essential Functions:

• Takes ownership of the enterprise database system
• Coordinates data inventory as well as data integrity across the enterprise, application high availability SLA’s, disaster recovery in the data space, and delivery high database solution designs that are extensible.
• Partners with all areas of the organization to drive successful delivery of high end data solutions, manage storage needs, and manage an enterprise data retention policy.
• Fulfills requests and resolves incidents within SLA’s.
• Drives architectural vision for enterprise database environment.
• Reviews operational reports (e.g., database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved proactively
• Responds to database related alerts and escalations; aiding in enterprise application administration, updates, upgrades, and migrations
• Experience with non-relational database platforms that specialize in processing different data structures (ex: JSON), document management, analytics and big data.
• Documents complex RDBMS systems and data dictionaries and stays abreast with security best practices in a RDBMS system
• Working in Azure data suite of platforms and services, providing technical direction and administration to our enterprise systems.
• Ability to stretch data administration knowledge across several different data platforms.
• Mentors developers and more junior dba resources
• Installs, upgrades and configures SQL Server, related patches and service packs; performs all database maintenance, backups, restores and recovery models
• Develops and writes stored procedures, functions, queries, and views in Transact-SQL
• Implements, configures and deploys SQL Server Reporting Services (SSRS)
• Supports mid-sized enterprise SQL Server, ETL workflows utilizing SQL Server SSIS and data tools, and SQL Agent jobs
• Tunes performance of the environment including databases, tables, views/queries and stored procedures
• Sets up and administers database security; providing user privileges in development, test and production databases
• Performs other duties as assigned

Qualifications:
Education and Experience:

• BS/BA Degree in Information Technology or Computer Science, relevant work experience may be considered in lieu of degree
• Minimum of 9 years of experience using MS SQL Server (versions 2008 - 2016)
• 7 years of experience with T-SQL.
• 7 years of experience with SQL Server replication
• 7 years of experience implementing complex data ETL solutions
• 5 years of experience supporting high availability and disaster recovery

Professional Certification(s):

• Microsoft Certified Solutions Associate - (MCSA)

Technical Skills

• Data warehousing conceptual knowledge
• SQL Azure High Availability and disaster recovery architecture
• SQL Server performance tuning tools including execution plans and SQL Profiler
• SQL Server Integration Services
• SQL Server transactional replication
• Native backup tools as well as Idera and Red Gate
• Knowledge of indexes, index management, and statistics including exposure to column store indexing
• Azure SQL Data Solutions

SAS Data Analyst

Job Description:

The ideal candidate has experience applying data science to impact business outcomes, and enjoys pushing the boundaries to innovate.
You will conduct analyses utilizing a variety of statistical methods and build automated reports to support Workplace Effectiveness to make evidence based business decisions that ensure employee productivity and well-being as well as operational efficiency.
Working with senior decision-makers in the company, your contributions will have a high level of visibility, and will enable our team to have a profound impact on the global organization.
Impact of decisions will contribute to Site Services determining how to shape (USD)1B+ worth of capital by 2022.

Responsibilities:

• Leverage data to discover patterns and solve strategic analytic business problems
• Execute sophisticated analyses that result in actionable recommendations
• Collaborate with subject matter experts across WE and the business
• Contribute to data integrity and data forensics efforts
• Define requirements and work with local and global Informatics (IT) to extend and maintain the Site Services Analytics platform
• Design and implement self-service reporting tools (e.g. Tableau, Python, R)
• Identify opportunities to further build out our IoT strategy

Mandatory Skills:
Education and Experience:

• Data-oriented scripting (e.g. SQL) and statistical programming (e.g., R and/or python)
• Classical statistics
• Experimental design and analysis, including validating questionnaires, and designing surveys
• Developing shared code (e.g., version control, programming patterns, libraries/packages) and creating data pipelines
• Experience working with Tableau

Desirable (not required):

• Experience using web services, such as AWS, and big data toolkits
• Machine learning approaches to fitting models (e.g., ensembles, bootstrapping) and estimating their performance (e.g., cross-validation)
• Architecture background/experience working with architects, space planners and interior design specialists
• Experience working with HR / organizational people data
• Publically available examples of code (github, etc) or projects (websites, decks, publications)

Job Requirements Data-oriented scripting (e, g. SQL) and statistical programming (e, g., R and/or python) Classical statistics Experimental design and analysis, including validating questionnaires, and designing surveys Developing shared code (e, g., version control, programming patterns, libraries/packages) and creating data pipelines Experience working with Tableau