Database Designer Architect MS SQL Server 2000/2005 to design enterprise call center software database


We need an MS SQL 2005 database designer and architect to design highly scalable and enterprise database, performance tune it, design fail over and redundancy solution, train operational DBA and for few more activities for our next version of next generation call/ contact center software. I have all the 40 forms and 50 reports of our current version of the software of which the database is too weak. I also have detailed list of functionalities to be achieved for the next version.

Bid for your 2 Months of Full-time availability. You should be willing to work with ODesk like distance service delivery platforms.

Payments at the end of each month against the worksheets produced and tasks achieved.

No GPL software database benchmarking allowed.

I would be happy to answer any queries you many have.

Please include in you bid your proposed plan and tasks you will achieve in 2 Months period.

Task Description:

Design logical and physical dimensional models and data structures: participate in business requirement sessions, data model design walkthroughs, and infrastructure reviews.

Create data sourcing documents and logic for ETL (extract, transform, load) processes.

Design and document the technical architecture of the Database by working closely with the Database Administrator, Developers, Architects and other Business Intelligence Team Members

Provide education in Database design and efficient SQL coding techniques to all other competency associates

Train operational DBA for SQL Server features such as trace flags etc

Plan for disaster recovery

Plan for Replicating of SQL Server data

Establish an architecture roadmap for operational and business intelligence reporting, and then deliver on it.

Design and extend the persistence management layer that insulates the database from the application layer.

Contribute substantially to the system architecture, and take ownership of the design and development of the database layer.

Participate in data analysis by researching the business rules that govern data relationships.

Participate in design and code reviews, documentation of design and the implementation of best practice methodologies to ensure high quality software

Review all database schema changes and act as a gatekeeper before such changes are checked in to the product code base

Design & Implement high availability solutions and failover clustering

Train operational DBA on the new features and tools available in SQL Server 2005

Implement security measures and enable C2-level auditing

Automate tasks using T-SQL stored procedures, Query Analyzer, DTS, and Multi Server Administration.

Work closely with all development teams to proactively plan, anticipate such changes and mitigate risks/impacts to other modules

Work closely with International based database architects to ensure changes are synchronized and approved before it is added to the product

Additionally take on DBA responsibilities to support the development team in making database changes, testing, data loads, exports, backup etc

Candidate Profile

Required Experience:

Knowledgeable in database design, Replication, Database back-up & recovery, RAID, Database migration, [url removed, login to view], [url removed, login to view], Client server technology.

Experience in all aspects of data management methods and practices including data modeling, design of data schemas, data migration/conversion and data warehousing.

Strong exp in MS SQL Server 2000 & 2005, writing queries and stored procs.

Exceptional knowledge of RDBMS kernels and database query optimization.

Development of Data Tier at back-End using Stored Procedures, triggers and Cursors. Usage of Index and Query Tuning.

Track record of building and operating highly scalable, web-enabled database applications that operate 24/7/365.

Hands-on experience in developing enterprise data architectures and complex data models for both operational as well as data warehouse applications

Indepth knowledge of relational modeling, dimensional modeling, and entity relationship modeling


Proven strong innovative and analytical ability with extensive implementation skills.

Strong technical leadership skills with extensive hands on experience.

Strong team player: ability to work under tight deadlines, work flexible hours, multi-task, and work on cross-functional project teams in varying locations.

Exceptional problem-solving and organization skills

Attention to detail and a commitment to producing work of outstanding quality.

Capable of working independently in a project oriented environment and meeting deadlines.

Time-management and decision-making skills a must.

Skills: Data Processing

See more: database designer architect, your other warehouse, you designer, writing worksheets, writing with both hands, writing tasks activities, writing software reviews, writing skills worksheets, writing roadmap 2, writing roadmap, writing practice worksheets, writing performance reviews, writing center hours, writing center, writing a performance review, writing analyzer, working for odesk, work designer, which technology is best for web development, we need a team of software developers, we designer, web optimization service, web innovative technology, web development using net technology, web development skills list

Project ID: #136285