Database Administrator & Architect (DBAA)
Knowledge Marketing - Plymouth, MN

This job posting is no longer available on Indeed. Find similar jobs:Database Administrator Architect jobs - Knowledge Marketing jobs

Assists in the development of data models for new projects within IT. Has primary responsibility for the definition, creation, and maintenance of enterprise databases and database structures within the organizations. Analyzes, tests, and implements physical database design supporting various business applications (including base definition, structure, documentation, long-range requirements, operational guidelines). Ensures data recovery, maintenance, data integrity, and space requirements for physical database are met through formulations and monitoring of policies, procedures, and standards relating to database management. Above all, ensures solutions meet business objectives and establishes and maintains a high level of user trust and confidence in IT’s knowledge of and concern for users’ business needs. Has a willingness to work with customers of varying levels of technical expertise in a high-pressure, complex environment.

 Provide first-level applications support: Resolve problems and answer questions related to the SQL SERVER and platform environment; contact vendor support when necessary; facilitate application development and client problem resolution with optimum speed and efficiency
 SQL SERVER performance monitoring and tuning: Closely monitor performance; identify problems and implement solutions; ensure the database is running at optimum speed and efficiency
 Maintain database backup/recovery environment: Assure that data recovery time objectives are established and met; verify implementation of correct backup strategy; develop recovery procedures; support recovery from loss of data caused by user or system error; respond quickly to refresh data.
 Install and upgrade RDBMS and related products: Keep SQL SERVERs at current release and maintenance levels; install supporting products; provide current, stable production and development environments
 Reorganize database structures as needed: Automate procedures at regular intervals; use tools to reorganize or defragment database table spaces, tables, and indexes; provide efficient database environment to maximize productivity and improve performance
 Perform application refreshes on request: Refresh data from one environment to another at the request of the application development staff; execute necessary tasks to accomplish this, including export, drop, create, and import pre-scheduled time to minimize impact; provide application development staff optimal development environment with current data
 Guide and oversee the database design process as needed: Research and recommend optimal design criteria; publish standards and work with development staff; standardize environment and improve efficiency
 Review and implement all changes to database structures, while ensuring the integrity of the data and maintaining data availability as requires by service level agreements
 Capacity planning and reporting: Monitor file system space, database allocation, etc.; verify efficient use of disk storage; reclaim unused space; optimize space allocation and avoid out-of-space conditions
 Create, develop, and review the physical model created from the logical model, ensuring the detailed physical design of data structures and databases complies with standards, guidelines, and procedures recommended for all aspects of data modeling, database design, and maintenance; ensure proper data modeling and design paradigms are applied
 Provide the appropriate tools, procedures, and facilities for creating and maintaining the entity data enterprise model
 Be capable of producing entity relationship diagrams; data flow diagrams; database normalization schemata; logical to physical database mapping; DDL and database commands
 Manage the implementation and use of the enterprise data dictionary
 Lead design reviews for database designs, application code, and pre- and post-implementation capacity meetings; estimate sizes of new databases
 Work closely with Systems Programmers and Network Administrators to ensure that the database system is operating in accordance with required system usage; provide assistance and guidance in setting appropriate system parameters
 Develop rules, procedures, and standards for the access and maintenance of shared data resources
 Review overall physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirement considerations
 Communicate complex technical information in a concise and articulate manner
 Participate in the evaluation and recommendation of DBA tools and new DBMS technologies
 Be responsible for the integrity of production test and QA database environments
 Perform impact analyses, research products, configure software, and establish standards and procedures that support the company’s database environment needs
 Be responsible for application-oriented database administration and technical support for the various development, training, testing, and production of relational database environments; focus on application-specific database issues to ensure optimal application performance and integrity
 Develop utilities for monitoring and evaluating data quality
 Assist in the definition and development of database documentation and standards
 Conduct application transaction volume and traffic analysis, and interpret impact on database and network performance
 Development projects: Interact with analysts and developers, understand system requirements from conceptual models, analyze transactions and data volumes, and design the physical database

Skills and Knowledge
 Thorough understanding of the relational database model and solid theoretical knowledge of relational database techniques; skilled in ability to see the big picture and conceptualize and document creative solutions
 Experience in designing, modeling, developing, and supporting large SQL SERVER systems
 Extensive experience in logical and physical database design, hands-on data modeling techniques, and development methodology; physical schema design of table spaces, rollback segments, and data files
 Experience in the design of data extract, data migration, and data queuing facilities
 Proficiency in the concepts and practice of database normalization techniques
 Strong working knowledge of state-of-the-art database concepts/design/deployment, recovery techniques, performance monitoring and tuning, structured query language, relational database design techniques, JCL
 Knowledge of server-side development issues surrounding triggers, stored procedures, and packages
 Strong customer focus and management of client expectations; ability to establish and maintain a high level of user trust and confidence in IT’s knowledge of and concern for users’ business needs
 Excellent oral and written communications skills.
 Ability to write clear proposals and technical documents
 Strong interpersonal skills at all levels of management and ability to motivate employees/teams to apply skills and techniques to solve dynamic problems; excellent teamwork skills
 Solid project management skills, effectively managing multiple small to large projects in a cross-functional environment
 Ability to weigh various suggested technical solutions against the original business needs and choose the most cost-effective solution
 Proficiency in several RDBMS-specific middleware tools and utilities to support such activities as monitoring, database migration, DDL management, and replication is required
 Extensive knowledge of SQL, including programming and ways to optimize SQL code.

 Bachelor’s degree in Computer Science, Engineering, or related discipline; Master’s degree is desirable; equivalent experience acceptable
 3 years in-depth experience in the design, administration, programming, and support of SQL Server in one or more computing environments (e.g., Windows, Web).
 Ability to handle basic systems administration tasks to fulfill backup role if needed
 Demonstrated experience working well with customers of varying levels of technical expertise in high-pressure situations and complex environments

Working Relationships
 Has close working relationship with systems team and peers in other areas of IT
 Works closely with Programmers & Network administrators
 Has contact with application users, primarily in problem resolution
 Has frequent interaction with application development staff as facilitator and client problem resolver; works collaboratively on such activities as performance problems, hardware/software upgrades, application program design reviews, new application setup and implementation, application workload growth prediction and measurement, etc.
 Is key participant in high-level technical strategy meetings, major upgrade decisions, capacity planning data collections, performance reporting, new application designing, etc.
 Has close working relationships with peers at external organizations