Basic Information
Country:
State:
City:
Date Published:
Job ID:
Travel:
Description and Requirements
"At BMC trust is not just a word - it's a way of life!"
Team/BU Description:
The SQL Database Administrator works with other DBAs, report writers, and project teams to refine reporting requirements and design and implement all database related applications and processes for the SAAS Platform. A high emphasis is placed on analytics, OLAP, and analysis cube design.
Note: Incumbent must be willing and able to work some weekend hours to complete system maintenance tasks.
Primary Roles and Responsibilities:
- Designs and implements databases using Microsoft SQL 2008.2012,2017+ Azure, AWS
- Performs administration of database servers, including production, development, testing, and training machines.
- Supports backup and recovery procedures.
- Performs replication, index maintenance, and maintenance of standby servers.
- Monitors system performance and optimize/tune stored procedures and indexes.
- Designs database schemas, writes stored procedures, and triggers.
- Troubleshoots and isolates performance problems in production databases.
- Creates ad hoc SQL queries.
- Designs and implements data transformation rules. Follows coding policies and standards as well as configuration management/version control policies.
- Designs procedures for maintaining and refreshing data on an ongoing basis.
- Performs Data Mining and cleansing on large historical databases.
- Implements, updates, and maintains all aspects of Microsoft 2008.2012,2017+ Azure, AWS
- Evaluates and implements new hardware and software.
- Performs other related duties as required.
QUALIFICATION AND REQUIRED SKILLS:
- A bachelor's degree in computer science or a related discipline
- Extensive knowledge of SQL and SQL server tools
- Experience in Database Performance, Development and Maintenance
- In-depth understanding of database security, backup and recovery, and performance monitoring requirements
- Familiarity with relational and dimensional data modelling
- Extensive knowledge in database design, implementation, and conversion
- Knowledge of PowerShell and Unix shell scripting
- Experience with SSAS, SSIS, and SSRS
- Working knowledge of Linux and Windows Server infrastructures
- Extensive knowledge of database technologies (, MS SQL, PostgreSQL)
- Prior experience with cloud services (AWS, Microsoft Azure)
DESIRED (NICE-TO-HAVE) SKILLS
- Minimum of 4+ years directly related work experience in Database Administration and Business Intelligence/Data Warehousing in an environment with multiple production databases. Prefer experience with SSRS, SSIS, and SSAS. Working Knowledge on postgres DB technology will be Plus and preferable.
Our commitment to you!
BMC’s culture is built around its people. We have 6000+ brilliant minds working together across the globe. You won’t be known just by your employee number, but for your true authentic self. BMC lets you be YOU!
If after reading the above, You’re unsure if you meet the qualifications of this role but are deeply excited about BMC and this team, we still encourage you to apply! We want to attract talents from diverse backgrounds and experience to ensure we face the world together with the best ideas!
BMC is committed to equal opportunity employment regardless of race, age, sex, creed, color, religion, citizenship status, sexual orientation, gender, gender expression, gender identity, national origin, disability, marital status, pregnancy, disabled veteran or status as a protected veteran. If you need a reasonable accommodation for any part of the application and hiring process, visit the accommodation request page.