Manager Database Administration & Architecture
REEDS Jewelers
- Raleigh, NC
- Permanent
- Full-time
- Provide development and administration support for various databases, primarily SQL server databases, in a client-server development environment including stored procedures and triggers, SQL, and index performance tuning, and database design and file storage.
- Develop, deploy, and maintain Extract-Transform-Load (ETL) scripts and schedules using SSIS or related technology.
- Develop and implement all database indexing, maintenance, back-up, transformations, and stored procedures.
- Expose data to application in various business tiers.
- Assist software developers in implementing appropriate data access permission schemas.
- Participate in the refinement and development of user stories, assessing the impact of new development on current database implementation.
- Communicate with technical and product owner stakeholders to help them anticipate and mitigate configuration management issues.
- Experience using database tools such as TOAD, Oracle’s SQL Developer, or MS SQL Server Management Studio, SSIS, Qlik Sense
- Knowledge of developing analytic reports and dashboards using Qlik Sense, Qlik Management Console, or other similar tools
- Excellent command of the SQL language with the ability to write and optimize complex queries.
- Experience developing code to leverage third party application exposed API as an integration framework.
- Solid knowledge of relational database architecture and concepts.
- Current on event processing, Data API, JSON, and recent emerging data technologies
- Strong database architecture, engineering, and design skills
- Passionate about technology and delivering solutions in integrated data environments
- Excellent listening, data flow diagramming (DFD) expertise, excellent verbal communication skills.
- Bachelor’s degree in MIS, information technology, computer science, or data analysis, and development experience in an Oracle or Microsoft SQL Server database environment, are required for this position.
- Hands-on work experience in database design, architecture, development, optimization and production support for enterprise applications are strongly preferred.
- Experience designing, developing and supporting an enterprise data warehouse environment across multiple lines of business and external sources of data.