Jr. SQL Developer
Location:
Atlanta , Georgia
Posted:
January 27, 2017
Reference:
16010146-en-us

McKesson is in the business of better health and we touch the lives of patients in virtually every aspect of healthcare. At Macro Helix, we are a leader in providing 340B software focused on helping customers improve financial performance, increase operating efficiencies and maintain regulatory compliance.

 

Every single McKesson employee contributes to our mission—by joining McKesson you act as a catalyst in a chain of events that helps millions of people all over the globe. We understand the importance of a system that works together. You’ll collaborate on the products and solutions that help us carry out our mission to improve lives and advance healthcare.  Your expertise, drive and passion can help us improve everything we touch, from providers to payors to pharmacies. Working here is your opportunity to shape an industry that’s vital to us all.

 

Join our team of leaders to begin a rewarding career.


Current Need

As a SQL developer, you will work closely with the MacroHelix internal project teams to implement our applications/solutions in the most effective way to maximize the client investment and meet their business and technical objectives. This position will be part of the development team and will be maintaining and creating SQL procedures and logic. The position will be involved in variety of activities including SSRS, creating procedures, patching bugs/faulty logic, and working closely with Product Management and Operations to understand the evolving platform and its features.


Position Description
Establishes database management systems, standards, guidelines and quality assurance for database deliverables, such as conceptual design, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan and security policy. Documents and communicates database design. Evaluates and installs database management systems. Codes complex programs and derives logical processes on technical platforms. Builds windows, screens and reports. Assists in the design of user interface and business application prototypes. Participates in quality assurance and develops test application code in client server environment. Responsible for devising, negotiating, and defending the tables and fields provided in the database. Adapts business requirements, developed by modeling/development staff and systems engineers, and develops the data, database specifications, table and element attributes for an application. At more experienced levels, helps to develop an understanding of client's original data and storage mechanisms. Determines appropriateness of data for storage and optimum storage organization. Determines how tables relate to each other and how fields interact within the tables for a relational model.

 

Responsibilities:

  • Use TFS & Salesforce as primary methods to track enhancements/bugs.
  • Create new logic and features using TSQL, SSIS, & SSRS
  • Correct and patch bugs in existing code/processes using TSQL, SSIS, & SSRS
  • Create database objects (tables, views, stored procedures, triggers, etc)
  • Make recommendations to improve and gain efficiency for existing processes
  • Create ER diagrams for proposed database
  • Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints
  • Proactively identify potential blocking, deadlocking and address
  • Develop and schedule reports in SSRS
  • Documentation of any processes created or updates made
  • Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the application

Qualifications

Minimum Requirements
2+ years experience in programming on enterprise or department servers or systems

Critical Skills

  • Proven ability to break down and solve complex engineering problems
  • Expert SQL Server knowledge of TSQL and OLTP topics such as Normalization, data types, query tuning, indexing, constraints, and query plan
  • Ability to work effectively (maintaining accuracy and sensitivity) under tight timelines and schedules
  • Ability to sense the importance or impact of issues and situations and take appropriate actions
  • Ability to work from an organizational perspective as well as independently and as a contributing team member.

Additional Knowledge & Skills

  • Healthcare experience and/or working knowledge of medical terminology preferred
  • Experience in SSIS & SSRS
  • Ability to write business requirements
  • Ability to be effective in a rapidly growing organization
  • Possess excellent listening skills and a commitment to communicating in a clear, concise and timely manner at all times
  • Possess exceptional skills in partnering with clients staff and in developing and maintaining long-term supportive relationships
  • Ability to organize time effectively while identifying barriers to progress, proposing solutions and setting priorities

Education
4-year degree in computer science or related field or equivalent experience


Benefits & Company Statement
We believe you should be rewarded for the important work you do. For that reason, you'll receive a competitive compensation and benefits package when you join our team.

It starts with you. That's a simple sentence but it says a lot. It reminds each one of us that what we do matters. Every single McKesson employee contributes to our mission - whatever your title, whatever your role, you act as a catalyst in a chain of events that helps millions of people all over the globe. By connecting and improving the business of healthcare, we're helping to ensure that millions of patients get the treatment they need. And by choosing a career with McKesson Pharmacy Systems & Automation, you'll join a team of passionate people working together to improve lives and advance healthcare.

At McKesson, we believe we can empower healthcare. And it all starts with you.

Qualified applicants will not be disqualified from consideration for employment based upon criminal history.

McKesson is an equal opportunity and affirmative action employer - minorities/females/veterans/persons with disabilities.
Agency Statement
No agencies please.


A little about us:
McKesson is in business for better health.

Know someone who would be interested in this job? Share it with your network.