| ROLE | SQL developer at Remote, Remote, USA |
| Email: [email protected] |
| Hello Hope you are doing well My name is Saurabh and I'm IT Recruiter at Technocraft solutions. We provide IT Consulting Services to our customers immediate and long-term resource needs. I am contacting you either because your resume has been posted to one of the internet job sites to which we subscribe or you had previously submitted your resume to Technocraft solutions. ROLE: SQL DBA Location: remote (100%) Note: Share only independent visa holders Job description: Responsible for the design, implementation, and maintenance of production databases in compliance with application specifications and company policies, standards, and procedures. Manages and maintains all production and non-production databases. Responsible for the design, implementation, and maintenance of the automation platform. Responsibilities: Must be hands-on in the latest MS SQL versions 2016, 2017, 2019, and 2022. Actively and consistently supports all efforts to simplify and enhance the customer experience. Administer automation platform and assist in code development via Ansible and Oracle Application Express tool set. Support internal SSRS and Power BI report development. Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity, and accessibility of data. Designs and maintains access and security administration. Designs, implements, and maintains backup and recovery strategies on Database Management Systems. Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity, and accessibility of data. Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools. Knowledge of Always-On, High Availability (HA), and Disaster Recovery (DR) options for MSSQL Server. Troubleshoots alerts (alert log, Jobs, Disk Group, Tablespace, etc.) and performance issues. Performs capacity planning of SQL server environment and provides recommendations to management to sustain business growth. Designs implements and maintains Disaster Recovery (DR) methodologies and creates documentation. Gathers business requirements, designs, and implements multiple projects along with production support. Creates standard operational procedures and templates. Acts as mentor for Database Administrators and Associate Database Administrators. Performs research and provides plans to remediate complex business problems. Assists the development teams in improving database design and procedures on TSQL best practices etc. Required Skills: Skills/Abilities and Knowledge. Ability to read, write, speak, and understand English. Strong knowledge of database architecture and its implementation. Strong automation background. Strong understanding of best practices in maintaining medium to large-scale SQL Server database systems. Strong programming experience. Strong knowledge of the following programming languages (TSQL, Power Shell, Ansible, .net). Strong understanding of Change Management procedures. Strong knowledge of Instance, database, and query tuning to improve the performance of the database/application. Strong understanding of SAN technologies related to SQL server disk layouts. Strong knowledge of Windows operating systems and shell scripting. Strong Knowledge of SSRS and Power BI. Ability to communicate orally and in writing in a clear and straightforward manner. Ability to communicate with all levels of management and company personnel. Ability to handle multiple projects and tasks. Ability to make decisions and solve problems while working under pressure. Ability to show judgment and initiative and to accomplish job duties. Ability to use personal computer and software applications (i.e., word processing, spreadsheet, etc.) Ability to work with others to resolve problems, and handle requests or situations. Ability to effectively consult with department managers and leaders. Nice to Have Skills: Oracle Cloud certification is preferred. Thanks and Regards Saurabh IT Recruiter Email: [email protected] www.Technocraftsol.com | Technocraft Solutions LLC 3974 Brown Park Drive, Suite F Hilliard, Ohio-43026 Linkedin id: https://www.linkedin.com/in/saurabh-verma-59baa5278 Keywords: access management business intelligence information technology microsoft Idaho |
| [email protected] View all |
| Fri Sep 29 21:03:00 UTC 2023 |