• Home
• About Amstar
  • Company Overview
  • History
  • Investment Strategy
  • Operational Strategy
  • Management Team
• Portfolio
  • Portfolio Overview
  • U.S. Portfolio
  • Global Portfolio
• Case Studies
  • Case Studies Overview
  • 1425 New York Ave
  • 3000 Sage Road
  • Esperson
  • Independence Plaza
  • One East Pratt Street
  • San Diego Courtyard
• Media
  • News and Articles
  • Newsletters
• Contact
  • Contact Us
  • Careers
    • Network Administrator III
    • .Net Developer/SQL Server Database Administrator (DBA)
    • Analyst
    • Associate
    • Hotel Analyst-Associate
    • Vice President
    • Reporting Associate
• Investor Login

.Net Developer/SQL Server Database Administrator (DBA)

Working under minimal supervision, this position is responsible for the development/maintenance of the Amstar Custom Reporting Solution (ACRS).  ACRS is written in C#, using .Net Framework 3.5, SQL Server 2005, WPF, Infragistics controls/components, LLBLGen Pro v2 and SSRS 2005. We require a senior level .Net programmer with WPF, Windows Forms, SQL Server 2005 and ASP.Net development experience, as well as expert level Transact-SQL (T-SQL) experience. Additional non-ACRS development in Windows Forms and ASP.Net will also be required.

This position is also responsible for the design/setup/implementation of databases, data maintenance (re-indexing, integrity checks, log file monitoring), performance tuning (indexing, compression drive distribution, load balancing, replication), and implementation/ documentation of SQL server disaster recovery models. The DBA provides application development/integrations and support for the MRI accounting suite of applications. Reports to Amstar’s IT Manager.

Specific Duties and Responsibilities:

• Develop and maintain reports using SQL Server 2005 Reporting Services (SSRS).
• Develop and maintain Amstar’s custom reporting solution utilizing .Net Framework 3.5, C#, WPF 3.5, SSRS, LLBLGen and Infragistics WPF controls/components.
• Additional development using Windows Forms and ASP.Net.
• Maintain (install, upgrade, troubleshoot, and manage) and provide highest level of technical support for network database servers.
• Review, manage, upgrade and monitor the database backup processes ensuring data integrity and business continuity.
• Monitor and regulate database server storage space, monitor server performance and tune the database servers to achieve optimum performance.  Assist in capacity planning (analysis and projections) to optimize system performance.
• Ensure that database systems and supported applications are at the highest level of security, up-time and performance, and are consistent with industry/technology trends and Amstar’s security procedures.
• Maintain an advanced level of knowledge of database systems and application software being used to provide highest levels of support to users and other network administrators/support technicians.
• Maintain documentation on all technical and operational problems related to the company’s database servers and related applications.
• SQL query writing and support of applications utilizing SQL 2000 and 2005 databases
• Develop training materials and deliver end user training for MRI applications.
• Daily monitoring, administration and maintenance of the company’s SharePoint sites.
• Perform medium complexity (i.e. application modules) analysis, design, development and unit testing of software applications from user requirements and design documents.
• Discover/resolve defects encountered during various testing cycles.
• May involve limited travel.

Experience/Required Skills:

• Minimum 5 years development experience in C#, including .Net Framework. 3.5
• UI design with Windows Presentation Foundation (WPF).
• LLBLGen (v2) Object Relational Modeling (ORM) tools.
• Expert-level Transact-SQL for SQL Server 2000/2005.
• Minimum of 4 years SQL Server 2005 Reporting Services report development.
• Minimum of 5 years of SQL 2000/2005 administration in an enterprise environment.
• Experience with SQL Stored Procedures and data extraction routines to import/export data from the repositories.
• Demonstrated expertise in Query Optimization and Tuning, including cross database and cross server queries.
• Data security background.
• Min 2+ years experience with Microsoft SharePoint 2003/2007 and MOSS technologies including web part development, site definitions and features.
• Min 2+ years experience with web content management, in creating site definitions as well as configuring and customizing SharePoint sites.
• Experience developing training materials and delivering end user level training.
• Experience using SharePoint Designer a plus.
• Infragistics WPF and WinForm controls/components, through version 2010 v1 a plus.
• A solid understanding of financial reports (General Ledger and Trial Balance) a plus.

Functional Area Skills/Knowledge:       

• Flexibility/Adaptability.
• Attention to detail.
• Strong troubleshooting and problem resolution skills.
• Ability to find creative solutions to production issues that arise.
• Strong written and oral communication skills.
• Strong organizational and documentation skills.
• Professionalism and a customer service oriented attitude.
• A sustained ability to execute on critical projects with accelerated schedules and manage demands with frequent changes or delays.
• Demonstrated ability to multi-task and work effectively as part of a team.
• Able and willing to lift 40 pounds.
• Able and willing to be on call after hours.

Education: 

• Bachelor’s Degree in related field required.  Five years demonstrated technical network experience may be substituted in lieu of degree.
• MCDBA, MCAD, MCPD, or MCSD certification(s) a plus.