Job Description :
Job Title : SQL DBA
Location : Remote
Please review this requirement and if interested/know of someone who would be interested in this role then email your updated resume in a word document with your contact details, current location, availability and hourly pay rate expectations to
Job Description:
The individual will be accountable for successful design, development and delivery of SQL solutions within on prem and cloud environments. An ideal candidate will be someone who leads, develops, maintains, and integrates processes for a data warehouse that will extract data from standardized or varied data sources and transforms data for storing in proper formats and structures for querying and analysis using SSIS. This would include loading data into an operational data store (ODS), and a dimensional model (EDM Responsible for architecting, testing, implementation of solution as well as mentoring and training other SSIS/ETL developers in technology and business processes.
SQL DBA Responsibilities:
* Data analysis and database management
* Strong experience using SSIS as the ETL tool in a data warehouse environment.
* Exercises, in conjunction with the enterprise data architect, independent decision making to creates processes which initiate the ETL, developing stream-lined processes for extracted data loading to destination databases.
* Performs data profiling of source data to identify data quality issues and anomalies, business knowledge embedded in data, gathering of natural keys, and metadata information.
* Creates data validation rules on source data to confirm the data has correct and/or expected values.
* Creates process cleanup after complex ETL processes which release resources used to run ETL. This would include error handling and SSIS restart.
* Designs and implements technology best practices, guidelines, and repeatable processes.
* (Physical) Environment-level administration; installation/patch/upgrade of database software; management of HA, database-level security; maintenance of database configuration files and data files; completion of database reorganizations, environment tuning, refreshes, exports and imports, backup and recovery; performance of capacity planning driven by technology and resource usage trends
SQL DBA Required Skills:
* IT Industry Experience (8 Years)
* Data integration and ETL experience with SQL Server Integration Services. (10 Years)
* Experience in SQL programming (8 Years)
* Experience in designing and developing ETL processes including naming conventions and connecting to various systems. (5 Years)
* Experience in identifying and mapping data elements across multiple systems including, creating templates and best practices to maintain mappings. (4 Years)
* Strong understanding of data quality and validation. (3 Years)
* Clear understanding and experience with Microsoft platforms to include SSIS, DQS, and MDS (3 Years)
* (Highly Desired) Understanding of ITSM/ITBM. Preference given to staff who have knowledge of ServiceNow (2 Years)
* (Highly Desired) Understanding and implementation of Amazon Redshift (3Years)
* Working knowledge of cloud technologies, including AWS and Azure (3 Years)
* Recent professional experience as an MS SQL DBA (5 Years)
* (Highly Desired) Experience using Agile Scrum methodology. (3 Years)
SQL DBA Nature : 6- month contract with possible extension or conversion
SQL DBA Start Date : ASAP