| SQL Server DBA at Nashville, Tennessee, USA |
| Email: [email protected] |
| From: Gopi, Yochan IT solution [email protected] Reply to: [email protected] Hi, Hope you are doing Great! Please find the below job description, if anyone are available please send me their updated resume with contact details at [email protected] Job Role: Sr. SQL DBA Location Nashville, TN or Chicago, IL (Initial 1-2 months remote allowed, post 2 month hybrid) While detailed JD is attached main highlights for this position is given below. MS SQL Server with AWS RDS, Azure SQL and No SQL Database. SQL Profiler /Quest Spotlight, SSIS package creation. Sr. DBA must be a US resident. While ideally Nashville or Chicago, anywhere in US would work for the right resource, remote can be considered for superstar candidate. RESPONSIBILITIES: The Senior Database Administrator will be assigned to work with one or more development project teams. In this role they will be expected to: The System Engineer will be responsible for building, supporting and managing end-to-end solutions within Amazon AWS and Azure Cloud environments. Support SCRUM teams in an Agile development environment. Working with the Solutions Designer, Development Architect and third parties as appropriate, the engineer will be responsible for ensuring that a technical design document describing the technical architecture for the program/project is produced. Understand the business and application requirements and translate into a database design. Ensure that all technology selected for the program conforms to the organizations technical long-term strategy. Be responsible for the availability, stability, recoverability and performance of the database environment by ensuring all systems are monitored, patched, and operating optimally. Design and develop complex SQL queries and appropriate database code such as stored procedures, triggers, functions to support complex business processes. Develop and deliver extensible/sustainable/quality database solutions based on defined business needs. Review and update stored procedures for optimal performance. Identify and correct performance bottlenecks related to SQL code. Recommend changes to the relational data model to solve performance issues with SQL code. Requires a solid understanding of relational database design and concepts. Monitor and troubleshoot SQL jobs using available tools such as SQL Profiler, Quest Spotlight, review logs and triage issues. Participate in the resolution of production data issues. Perform code reviews, providing feedback in a timely manner. Incorporate feedback from code reviews as appropriate. Participate in the review of all database schema projects; provide feedback and identify impacts to existing environment. Monitor business data stored in production databases, ensuring integrity of the data is maintained. Responsible for developing, maintaining and deploying SSIS packages. Participate in release of all stored procedure projects; including release documentation. Maintain knowledge as new versions of SQL Server are released and leverage new functionality as appropriate. Proactively identify and act on opportunities to improve database systems and processes. Contribute to standards documentation for database coding practices. Prioritize multiple tasks so that aggressive deadlines are met. Provide ongoing suggestions for improvement and innovation within the department. Exhibit sound, methodical engineering judgment, and effectively manage trade-offs in a business environment. Familiar with one or more of the below or other programming languages : VBScript, JavaScript, VB, Java, .NET,PERL Maintain and exhibit knowledge of AWS RDS, Azure SQL and NOSQL database Provide after-hours support as required to address system outages and perform system updates/upgrades/modifications. Identify new processes or modify existing processes to improve efficiencies in the support and monitoring of the departments production applications. Perform other duties as required. Gopi Pabbu Resource Specialist Yochana IT Solutions Inc Mail Id :[email protected] www.yochana.com Address : 23000 Commerce Drive, Farmington Hills, MI 48335, USA Keywords: information technology trade national microsoft Idaho Illinois Michigan Tennessee |
| [email protected] View all |
| Fri Sep 15 23:31:00 UTC 2023 |