Senior Database Analyst / Administrator

 



Company

Majestic Research is redefining investment research.  Traditional research is frequently based on publicly available data or anecdotal knowledge of limited sample sizes.  Majestic uses its exclusive relationships with proprietary industry data providers to generate fresh insights.  It is currently the only independent research firm focused on leveraging such critical data.  Institutional investors look to Majestic for insight on key performance metrics continuously throughout a fiscal quarter.  Research is driven by real-time sources of information that enable Majestic Research to report on trends before they are announced by management, as opposed to Wall Street, which typically reports on information after the fact.  Majestic Research does not issue buy or sell recommendations and has no investment banking relationships.  The Company's goal is to help investors evaluate sales trends, analyze revenue streams and assess market share.  Majestic Research is committed to providing its clients with an objective representation of business performance as it is occurring.



 

Job Title

Senior Database Analyst/Administrator

 

Reporting Relationship

The Senior Database Analyst/Administrator will report to the VP of Technology.

 

Job Description & Responsibilities

Top independent equity research firm seeks highly motivated Database Analyst/DBA to oversee database strategy, development initiatives, and operations.

 

The Senior Database Analyst/Administrator will:

Provide data architecture leadership by being mentor, advisor, and role model in the cost-effective application of data resources in support of business operationsEnhance the business value of data by continuously improving the integration of data design solutions with business needsPlan and implement reporting architecture, SQL 2005 migration, data warehousing, data mining, business intelligence, and disaster recovery initiativesDevelop tools and applications to interface and integrate with disparate database systemsSupport developers and financial analysts with query design and tuning, data modeling, and database application architectureEvaluate, recommend, and implement tools, technologies, and processes to ensure reliability, performance, security, and scalabilityAdminister database operations, including backups, performance monitoring, and change managementOrganize all activities associated with planning, modeling, configuring, documenting, and coordinating usage, conformance, and governance



 

Professional Qualifications7-plus years of proven experience with large, complex database systems (terabytes of data, hundreds of millions of records)Experienced in creating conceptual, logical, and physical data modelsConversant with object oriented techniques (use case, sequence diagram, etc.) and service oriented architecturesStrong familiarity with data storage repositories and modeling toolsStrong knowledge of indexing, partitioning, and fragmentation strategiesIn-depth understanding of Microsoft SQL Server, including T-SQL, performance tuning, and DTSKnowledgeable in design techniques to support high-volume, scalable databases and application solutionsSkilled with data migration processes, data mining, data movement and transformation (ETL), and database administration (especially tuning and size estimation). Excellent communication skills and ability to provide technical thought leadership through sound judgment and superior technical knowledgeExperience with star schema/dimensional modeling and data warehouse methodology a plus

 

EducationMinimum of 4-year degree, preferably in Computer ScienceMCDBA and MCSD certifications a plus

 

Personal AttributesAbility to develop, plan, and implement short- and long-range goals Entrepreneurial, ambitious, and willing to work long hoursDetail-oriented with a commitment to provide quality work in a team environment Intellectual curiosity, initiative, resourcefulness, and tactExceptional oral and written communication skills