Jobfox - Database Architect, Sr

Looking to make a hire? Go to our Employer Site

Already have a profile?

Already have a Jobfox profile?

Click here to login and apply for this job.

Not the job for you?

Create your free profile now and we'll immediately match you with jobs that are right for you.

About Jobfox

At Jobfox, we're dedicated to matching job seekers with great jobs based on their skills and experience. Find your next job today, start your free profile now.

Company Name: American Home Mortgage Servicing, Inc.

Job Title: Database Architect, Sr

Location: Irving, TX

Profession: Database Administration (DBA)

Job Description:

Responsibilities
		This role sets up Data Policy and the technical solution for the management, storage, access, and transformation of data. This role is responsible for establishing standards and guidelines for database design and coding. Responsible for database sizing and growth needs. Sets Data Policy and the technical solution for the management, storage, access, navigation, movement, and transformation of data Defines and Creates reusable objects. • Performs code reviews. • Ensures use of established standards • Ensures the models are maintained properly in the model mart. • Sets Data Policy and the technical solution for the management, storage, access, navigation, movement, and transformation of data. • Writes, debugs, tests, and implements database programming logic. Works primarily with developers to develop database-driven applications. • Administers, maintains, evaluates, and analyzes the current systems and/or system needs. • Perform analysis and modeling to determine effective system file and data structures. • Create database designs which provide the necessary flexibility as well as data integrity, integration and performance. Develop System and Database designs utilizing ERD, Process Modeling and other tools as deemed necessary. • Independently or as part of the project team analyze, design, code, coordinate client and integration testing, debug and document database systems of all levels of complexity. • Assist Database Administrators in creating database administration components including but not limited to a) Data source information and gathering b) data transformation c) data integrity and d) data maintenance. • Develop DTS packages, build OLAP cubes, user interfaces and reports. • Perform data mining on databases to establish trends/patterns that can be used in analyzing the data. • Help to establish and enforce all rules, regulations and procedures designed to protect the integrity of the database at all times. • Provide post implementation and on-going production support. • Ensure standardized data definitions, data access and updates on new data fields or products. • Develop and maintain a data dictionary • Document data available in the systems as well as account data definition (criteria used). Develop audit control trails/reconciliation for data integrity. • Evaluate/ Research new software tools and techniques.
	Qualifications
		4 Year college degree - Bachelor or equivalent (math, computer science or MIS preferred) • 7+ years functional experience • Knowledge of Mortgage Banking, Accounting or Finance is preferred. • Advanced knowledge of Relational Database Management System architecture and concepts, including data modeling and database design. • Advanced knowledge of SQL Server environments. SQL (DDL, DML), Stored Procedures, Triggers, Database Utilities, SQL Views and Replication technologies. • Advanced knowledge of reporting tools, such as Access, Visual Studio.net, OLAP and SQL Server Reporting Services, SharePoint, Crystal Reports. • Ability to design and develop customized computer-based and/or web-based applications. • Must be self motivated, detail oriented, and have a service oriented attitude. • Ability to work independently as well as with a team on development projects. • Flexible and able to keep pace with software and business industry changes and new technologies

Interested in this Job?

Select a profession to see top Jobfox jobs in Dallas.

Database Administration (DBA)

This profession covers individuals who administer and support company databases. This includes database creation, monitoring and troubleshooting.

Help Desk

This profession covers individuals who function as a desktop support or corporate help desk representative. These positions are usually located internally within a company or organization.

Network Design/Engineering

Individuals in this profession support and design computer networks. Key skills include knowledge of specific network protocols, e.g., IPv6, and overall network design and optimization.

Software Design/Development

Individuals in this profession design and develop software, e.g., enterprise applications, operating systems, and desktop software. Software testing, user interface design, and build/release/install individuals are covered in separate professions.

System Administration

Individuals in this profession support computer networks and administer server and enterprise software. Key skills include knowledge of specific operating systems and server software. The Network Design/Engineering profession is better suited to professionals who design networks and have advanced knowledge of specific networking protocols.

Technical Writing/Documentation

This profession covers individuals who are technical writers. Technical writers write technical manuals or operating instructions. They also are charged with altering the tone of their writing to conform to specific audiences.

Technology Management

This profession covers individuals who manage a corporate IT department. Managers coordinate the activities of the entire department and serve as a liaison between other functional areas of an organization. In addition, this profession also covers software managers for ISVs or consulting firms.

Telecommunications Engineering

This profession covers individuals who are telecommunications engineers or installers. This profession also covers individuals who work in corporations and are highly technical. Non-technical positions should use Installation, Maintenance and Repair.

Testing/Quality Assurance

This profession covers individuals who are testers, quality assurance engineers or testing managers. These professionals test applications, primarily software, using either manual processes or automated testing tools.

User Interface Design

Individuals in this profession are responsible for the design of computers, appliances, mobile communication devices, software applications, and websites with the focus on the user's experience and interaction.