SQL Database Administrator

Responsible for the on-going enhancement and maintenance of an enterprise reporting database including report building and ad hoc querying. Evaluates business reporting needs, develops a data structure to support business needs, evaluates available data including external files, and maps data into a structure suitable for the designed solution. Builds, maintains, and monitors daily/weekly/monthly import processes (using SSIS or other technologies). Documents and updates data warehouse mappings. Implements security measures to ensure proper database security.

Essential Functions and Responsibilities:

• Identifying data sources, developing a database schema, mapping files into the schema, integrating data through ETL processes, monitoring daily loads, documenting the data flow, and ensuring database security.
• Performs ad hoc queries, stored procedures for developers, and develops standard reports for business users.
• Create and modify databases, products and reports according to client needs and functional requirements.
• Maintain the integrity and availability of databases, as well as troubleshooting database issues and implementing data backup and recovery mechanisms.
• Design, develop and manage relational databases for optimal performance and data security.
• Use advanced SQL skills to create and write reports in support of analytics.
• Performs other duties as assigned.

Qualifications and Requirements:

• Experience: Three to Five years of similar or related experience.
• Education: Appropriate industry experience or a (B.S. or M.S.) in Computer Science or Computer Engineering.

Technical Skills:

• SQL Proficiency: Mastery of SQL for querying and managing databases.
• Database Design: Understanding of database schema design, normalization, and indexing.
• Database Management Systems (DBMS): Experience with systems like MySQL, PostgreSQL, SQL Server, and SQL Server Integration Services (SSIS).
• Data Modeling: Ability to create data models that support business processes.
• Performance Tuning: Skills in optimizing database performance and troubleshooting issues.
• Reporting: Leverage SQL skills and reporting tools such as CRMBI in creating, writing, and optimizing reports to enable and support business needs.
• Backup and Recovery: Knowledge of data backup, recovery, and disaster recovery planning.
• ETL Processes: Experience with Extract, Transform, Load (ETL) processes for data integration.
• Security: Understanding of database security practices to protect data integrity and privacy.