Great opportunity to build powerful framework components for Healthcare Applications!
This business savvy organization specializes in medical software development and has been ranked as the Top 5 firm in its product/service deliverables! As a result, this 10-year old company has been profitable every year in business! As an aggressive, entrepreneurial organization with major expansion on the horizon, this company is offering a Software Architect/Senior Software Developer position to the right candidate.
What will you be doing?
The Database Architect/Developer's responsibilities fall into three major categories:
Perform product-specific database-related tasks
Design and implement the database architecture for our next-generation technology
Provide Level 3 customer support for our technical support team, including troubleshooting, configuration, and optimization of customer installations
Although performing DBA functions is a requirement, this position requires additional skills.
You will be a thought leader in the development and evolution of database technologies and data products strategy. You will translate business goals into the requisite data technology requirements and design solutions which satisfy those business goals. As part of executing this strategy, you will design and develop Extract, Transform, and Load (ETL) components to generate and maintain DataMarts and Data Warehouse initiatives.
In addition, you will implement your solutions including the schemas, data access/virtualization layers, stored procedures, etc. Plus, you will design, develop, and carry out performance analysis and make recommendations (which you may ultimately implement) to improve product performance in the database, at the data access layer, and how other components access/interact with the database.
Work with Product Architect to design physical data structures to support application requirements.
Implement database design, optimized stored procedures, user-defined functions and data access layer to be used by other software components.
Develop performance reviews and tuning recommendations for applications.
Consult with developers and members of other departments regarding optimal use of SQL Server queries.
Work closely with Project Manager, Architect, and Software Developers to design and maintain databases to support current and future needs
Develop procedures for data migration.
Resolve database performance issues, database capacity issues, replication, and other distributed data issues.
Analyze data storage and data access requirements.
Play a key role in our ongoing Data Warehousing business initiative.
Data Modeling - Create the physical data model and modify the model on an as-need basis from the conceptual and logical models.
Create DTS packages
Create installation scripts for databases
Tune performance at the query and index level.
Size out machines - Assist in determining the hardware requirements for a customer
Execute performance and benchmark testing as needed
Perform real-time analysis of database performance at customer sites
Provide index tuning recommendations based on real time analysis of database performance metrics
Provide detailed Database design documentation for release to customers and for internal use
Perform duties as defined in departmental and positional responsibilities