- Administer, maintain, and configure SQL Server databases
- Perform database backups, implement data retention policies, perform production deployments
- Manage database performance, availability, and security protocols
- Apply database updates, patches, and upgrades
- Create, schedule, and monitor jobs using SQL Server Agent
- Design and maintain data models and datasets
- Develop complex datasets leveraging SSIS using data sourced from multiple platforms
- Provide query optimization in support of database and web development, and adhoc SQL queries
- Review and maintain GitLab Repositories
- Create and manage remediation plans for vulnerability scans
- Maintain documentation of database architecture, configurations, and processesAdminister, maintain, and configure SQL Server databases
- Perform database backups, implement data retention policies, perform production deployments
- Manage database performance, availability, and security protocols
- Apply database updates, patches, and upgrades
- Create, schedule, and monitor jobs using SQL Server Agent
- Design and maintain data models and datasets
- Develop complex datasets leveraging SSIS using data sourced from multiple platforms
- Provide query optimization in support of database and web development, and adhoc SQL queries
- Review and maintain GitLab Repositories
- Create and manage remediation plans for vulnerability scans
- Maintain documentation of database architecture, configurations, and processes
- Strong knowledge of common web front-end technologies (HTML5, CSS, JavaScript, and React.JS).
Understanding of JavaScript architecture design.
- Knowledge of algorithms, design patterns, and componentization approaches.
- Expertise with cross-browser, cross-platform, and design constraints on the web.
- Experience in building high performance, high availability and highly interactive websites.
- React.JS, Flux, Webpack, Sass or similar.
- Application monitoring with Statsd and Graphite, New Relic or similar.
- PostgresSQL, Mongodb, MySQL, Redis
- SSIS - SQL Server Integrated Services
- Experience with Distributed Systems.
- React Native (Flexbox)
UI Design Skills:
REST, MongoDB, React.JS, HTML5 / CSS, JavaScript, Python, MySQL, Postgres, Jasmine, MobX, FormState, React Toolbox, Redux, Aceyus
MUST HAVE SKILLS (Most Important):
1. Proficiency in SQL Server administration, maintenance, monitoring, and configuration
2. Advanced knowledge of relational databases and writing complex SQL queries
3. Working knowledge of SQL Server Management Studio and SQL Server Integration Services
DESIRED SKILLS:
1. Experienced SQL Developer
2. Experience with Javascript, AngularJS, C#, and Visual Basic preferred
3. Ability to handle multiple projects concurrently
EDUCATION/CERTIFICATIONS: Desired but not required
BS Computer Science
Microsoft / Azure Database Administrator Certification