Ref: SQ193485

Sr. SQL Engineer

USA, Texas

Job description

Sr. SQL Engineer

SQ193485



Sr. SQL Engineer -



Summary


The Senior SQL Engineer will have a solid knowledge of database concepts and software development tools. They will work closely with other Software Engineers, Business Systems Analysts, and business stakeholders to develop and maintain complex database solutions. Additionally, the Senior SQL Engineer will function as a subject matter expert and will be expected to implement complex software solutions across a variety of clients.
Duties and Responsibilities
* Accurate and prompt entry of time for all estimated and actual work
* Adhere to company policies, procedures, best practices and standards
* Adhere to deadlines
* Aid in solving complex business problems
* Assist the project team with comprehensive level-of-effort estimates for all necessary changes and be accountable for completing the estimated work when applicable
* Become the subject matter expert and share their expertise on the systems and business supported
* Challenge conventional practices in a collaborative fashion
* Collaborate with co-workers to achieve common goals
* Communicate (and listen) clearly, professionally, politely, and persuasively in all situations; respond well and in a reasonable, timely manner
* Conforming with all applicable compliance and business standards
* Considers cost and resource efficiency in performance of all job responsibilities
* Design solutions for high complexity projects
* Design, build, and maintain efficient, reusable, and robust code while using source control to manage code across all environments
* Design, develop, maintain, and enhance scalable data processes, business reports, ad-hoc reporting, and other data related items
* Develop and deliver training as appropriate
* Develop and execute test plans to validate code works as expected
* Develop basic database queries and perform analysis on results
* Develop, maintain, and enhance data processes, business reports, ad-hoc reporting requests, and other data related items
* Enforce architecture, data, security, and coding standards
* Ensure all work products are documented, stored, and managed according to company standards
* Ensure open communication flows in all directions
* Ensuring adherence to compliance and business standards
* Estimate and establish timelines for small to medium efforts
* Identify, incorporate, and remediate code to improve performance
* Independently solves complex problems
* Initiates process/technology improvements
* Lead targeted engineering efforts
* Lead, innovate, and implement ideas to support growth/scale
* Learns and applies a fundamental understanding of key aspects of the business(es) supported
* Mentor, guide, and lead others
* Participate in code reviews and quality assurance processes to ensure that the architectures and standards are being followed
* Participate in staff recruiting efforts
* Participates and assists in business development opportunities as requested
* Perform all work and activities with honesty and integrity
* Perform complex estimating and requirements gathering efforts
* Possess big-picture understanding of the business and have the ability to challenge the status-quo
* Proactively incorporate best practices in providing leading edge secure solutions
* Proactively mitigate risks
* Proactively seek, identify, and collaborate on innovative solutions
* Respond timely to all production support requests
* Seek and implement automation opportunities wherever possible
* Troubleshoot, analyze, and debug issues
* Perform other duties as assigned
Qualifications & Requirements
* Bachelor's degree or equivalent and 5 years of related experience
* Able to collaborate and work in a team environment; practices the principle of team over individual
* Able to handle competing priorities across project assignments
* Continually strives to improve products and services
* Demonstrates appropriate judgment
* Excellent analytical and problem-solving skills
* Excellent interpersonal and communication skills
* Expert ability to quickly learn and apply new technologies
* Self-motivated to learn new practices, processes, skills, tools, and knowledge that align with company priorities and/or future opportunities
* Shows initiative and resourcefulness ("can do" attitude)
* Works with a sense of urgency without sacrificing attention to detail
* Ability to develop, maintain, and re-platform SSIS, SSRS, SQL Server sorted procedures
* Ability to tune high performance database queries
* Applied knowledge of Data Model design, Indexing, Referential Integrity, and other key data concepts
* Bachelor's degree in any discipline required
* Demonstrated ability to apply unit testing/test-driven development
* Demonstrated experience in creating and maintaining conceptual, logical, and physical application architectures
* Demonstrated experience of high-quality delivery in a Software Engineering role for the full development lifecycle across several high complexity projects
* Established credibility as a subject matter expert in a particular area of focus (Technology, Industry, etc.)
* Experienced in creating data architecture, data model diagrams, relationship diagrams, etc
* Must have one or more of the following: - DevOps experience - Familiarity with Data Modeling, Data Warehouse design and/or Big Data (Hadoop) - Experience using Python - Experience with NOSQL