As part of a mission centric, locally delivered and nationally powered organization this role serves as the individual that provides technical expertise in the design, implementation and maintenance of Database Management Systems by ensuring that operational and analytical data is easily available to the organization in a dependable and timely manner on a consistent basis. Data Modeling Perform detailed data analysis and capture data related requirements by organizing working sessions with various business and technical SMErsquos. Creation and review of logical and physical data models including hand-on experience working with data modeling tools like Visio, Erwin and Power Designer. Creation and maintenance of data flow diagrams related to data integrations including definition and validation of data mappings, transformation(s) and validation rules. Database Administration Capacity planning and hardware sizing for new implementations and migrations. Installation, configuration, and maintenance of multiple database environments including highly transactional operational systems, an operational data store, and an enterprise data warehouse. Proactive database performance monitoring and tuning ensuring that the databases are performing optimally. Qualifications A minimum of 10 years of progressively responsible in-depth experience in the modeling, administration, development and support of RDBMS (MS SQL Server, Oracle), during which professional capabilities have been clearly demonstrated. Ability to design, implement and perform detailed analysis of complex, highly normalized operational systems. Advanced knowledge and experience in logical and physical data modeling. Advanced T-SQL query writing and tuning skills a must. Extensive knowledge and expertise in creating and maintaining SQL Server database objects (including SQL Server tables, triggers, unions, joins, complex queries and stored procedures). Strong database performance tuning skills. Working knowledge of SQL Server Integration Services, Analysis Services, and Reporting Services. Worked in clustered SQL Server environments. Knowledge of cloud computing (AWS) and considerations for scalable, distributed systems.
Associated topics: data architect, data center, data engineer, data management, data quality, data warehouse, data warehousing, database, erp, mongo database administrator