MENU

Development Database Administrator ll

PURPOSE OF THE POSITION

  • Under the guidance of IT Management and experienced IT staff, provide CBE internal and external clients with support on existing applications.
  • Assist with maintaining IT department’s number one goal of all systems up and running.
  • Design new database and changes to existing databases.
  • Develop ETL processes to support internal and external client needs.
  • Perform database administration on multiple database servers.

DUTIES AND RESPONSIBILITIES
  • Responsible for 24x7 availability of mission critical databases in production environments, including troubleshooting and resolving database problems.  This includes on call responsibility on a rotating basis with other Database Administrators.
  • On call rotation with other teammates to resolve production issues
  • Maintain and support MS SQL Servers with databases used for production, staging and development.
  • Implement and support MS SQL Servers Database systems, reporting services and integration services on windows servers.
  • Design, install, tune, maintain and monitor MS SQL Server databases, products and services including, but not limited to, storage management, database performance tuning, database software debugging, backup and recovery and change/configuration management.
  • Work closely with technical and client management to design and implement SQL Server databases, associated support tools and processes in support of complex business application development requirements and processes.
  • Build strong partnerships with internal and external clients.
  • Create and maintain documentation on databases and processes.
  • Install software upgrades, manage hardware upgrades, and maintain computer servers used in the Production, staging, and development environments.
  • Develop and maintain replication processes, used for several environments.
  • Develop and maintain maintenance plans including backup and recovery.
  • Work with development staff to develop database architectures, coding standards, and quality assurance policies and procedures.
  • Assist development staff in testing of processes and troubleshooting process issues.
  • Implement information security policies and procedures for the organization.  Also assists in identifying protection goals and objectives consistent with corporate strategic plan, along with identifying key security program elements.
  • Research new technologies and develop recommendations for the adaption of the technologies.
  • Performance tune queries and tables via index optimization.
  • Create and modify SSIS packages to perform maintenance and data transformations.
  • Isolate and resolves database deficiencies and implements corrective modifications.
  • Coordinate activities to support program activities with database requirements. 
  • Assist in developing, evaluating, and selecting alternatives to meet customer requirements. 
  • Identify interoperability issues and recommends resolution strategies.
  • Optimize database design and manages data integrity.
  • Maintain technical and end user documentation manuals for current databases.
  • Conduct end-user training on use of databases as required. 
  • Ability to effectively present information and respond to questions from groups of managers and/or clients.
  • Ability to define problems, collect data, establish facts and draw valid conclusions.
  • Strong commitment to customer service and excellent written and verbal communication skills required.
  • Ability to multitask and prioritize work requirements essential.
  • Implement information security policies and procedures for the organization.  Also assists in identifying protection goals and objectives consistent with corporate strategic plan, along with identifying key security program elements.
  • The Company reserves the right to change or assign other duties to this position as appropriate.
  • Must be able to perform the essential job duties of the position. Reasonable accommodations will be provided to qualified individuals with disabilities.
    • Must be able to remain in a stationary seated position up to 85% of the work shift
    • Must be able to occasionally move about inside the office to access office machinery, file cabinets or attend meetings
    • Must be able to operate a computer and other office productivity machinery, such as a calculator, copy machine, printer, scanner, fax machine
    • Must be able to exchange accurate information with co-workers, consumers and/or clients or vendors who have work related inquiries

 

EDUCATION AND EXPERIENCE PREFERENCES

  • BS/BA or equivalent from four-year college in Computer Science or Mathematics required
  • Analyze end-user needs and design, coding, testing software to satisfy demands
  • Strong written and oral communication skills
  • Ability to work on multiple projects with competing deadlines
  • Ability to communicate clearly with all business users and project managers
  • 5+ years of SQL Server database administration
  • 5+ years of SQL Server database development
  • 5+ years of SQL Server Integration Services development
  • Expert knowledge with Microsoft SQL Server and technologies
  • Expert knowledge of T-SQL and developing complex database queries
  • Experience working with large databases with high number of transactions
  • Understands and use SQL best practices regarding security and privacy of data
  • Expert knowledge with developing SQL views, common table expressions (CTEs) and stored procedure to combine/aggregate data needed for reporting purposes
  • Strong knowledge of performance tuning especially tuning complex queries, procedures and indexing strategies
  • Strong knowledge of designing and creating new and modifying existing SQL Server Integration Services packages
  • Experience with .NET programming languages
  • Experience with third party SSIS Components is a plus

 

CBE Companies is an Equal Opportunity/Affirmative Action Employer. CBE Companies is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex (including pregnancy), sexual orientation, national origin, gender (including gender identity and transgender status), genetic information, disability, veteran status or other protected statuses in accordance with applicable federal, state, and local laws. 

 

Background check and drug testing required.

Type of Employment: Full-Time