October 6, 2008 at 5:22 pm
Hi,
Can someone provide a list of Business Intelligence DBA interview questions?
Thanks,
Natalie
October 7, 2008 at 8:23 pm
Will Riley (10/7/2008)
Why?If you have the knowledge your skills and abilities for the role will be obvious.
If you don't, you have no business being in the job, as you will just damage your career as well as the client's environment, sanity and faith in BI.
Interview question lists (of the generic kind) abound on the web so go google them. If you don't have the technical skills, there's really no point trying to wing it - if you are fortunate enough to hoodwink the interviewer, what sort of shit-scare life will you lead from day one onwards...?
Sorry, trying to be nice about this, but in my opinion, you should pass an interview on your own merits or forever live in fear of being "found out" - and that's no life to lead....:hehe:
Incorrect. I mean I accept your opinion, but to me it is WRONG!
If a person sets a goal for themselves and strives to achieve doing whatever it takes, it is not shameful, but on contrary respectfull that the person TRIES to step up.
Would the applicant/interviewee care about the client's faith during the interview? NAAAAH
Would one interview damage the whole career even if they fail? NAAAH
Would the smart person, who got the job they wanted, but having lack of experience, just sit and wait before they get into trouble? NOPE.
My opinion, comrades is to follow THIS strategy:
1. Learn as much as you can.
2. Never think you are guru, just learn more.
3. When need to step up, find a job, do this:
3.1 Learn the requirements
3.2 Imagine you are 100% suitable
3.3 Change your resume to suit
3.4 GOOGLE
3.4 Apply and get it
Those ones who sit on the back-bench reading books and waiting when people call them out to work as BillGates, or wait till they FEEL LIKE they are absolute gurus, are still there on their back-benches.
the answer to the original question -- GOOGLE please, there's heaps of info out there. And DO NOT BE SCARED to exagerate your skills.
OVER
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
October 9, 2008 at 1:45 am
Natalie,
Are you an interviewer or interviewee?
If the interview; I would ask the current DBA’s and if possible BI developers to get a feel of what is needed, also Google, it can’t hurt. You could also try any agencies you are using as they sometimes have a set of questions that often arise in interviews.
If the interviewee; I’d just be completely honest during the interview and do as suggested and Google as much as possible, you may find that you already possess many of the skills needed specifically for any BI requirements.
October 9, 2008 at 4:08 pm
hi,
thanks for the tips.
Natalie
October 11, 2008 at 3:46 am
hi,
i dont know why some one is so harsh to requestor of interview questions. This group is made to share knowledge and skills. If some one is asking for interview questions then it means they need some guidance on how to prepare for interview, what kind of question they should expect so that they will be more prepared in interview and perform well. We are here to help each other and encourage people.
All the best.
Vijay
October 12, 2008 at 4:34 am
:doze:
Gents... poster just asked for a list or questions, unfortunately poster ignored wildh follow-up question which was spot-on. The answer -to wildh - would actually define how to answer the original poster's question.
I see nothing but incoherent random answers!!! :crazy:
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.October 12, 2008 at 3:51 pm
If it includes attempting to learn answers from a scripted set of questions prepared by someone else, then yes I'm dead against it. It serves little purpose for either interviewer or interviewee.
Oh yes it does!!!
So as any other exam be it primary school, uni or wolrwide brain contest.
A person cannot know everything. Knowing what IS REQUIRED in a particular situation is vital.
Having an idea of what is required is very helpful when planning learning.
Hypothetical situation -- a SQL programmer with experience in MSSQL, Postgre, Oracle, MySQL is getting annual 80K. They have had some business analysis experience and have an idea of database/warehousing/etc from their experience and academic past. They spotted an ad for a 100K BI developer role, which is exactly what they do plus some specialised ETL/Cubing tools and BI methodology.
Getting through the interview with the baggage of SQL/BD knowledge they have would be a perfect chance to earn an extra 200-300 a week and progress through. Learning as they do their work is implied. There might be no time to read a 1000page book, but googling around the interview questions for a couple of nights will definately help.
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
October 13, 2008 at 2:12 am
Natalie, try google searching.
BI DBA to me would be:
providing DSS BI Database Administration, performance tuning, operating platforms, data modeling, design, development, monitoring, database capacity and utilization, server applications security, archiving, backups, disaster recovery, and documentation..... etc.
I did a little search myself and I have found this one job offer 😀
Specific Duties and Responsibilities
Planning:
Stays current on new developments in technology related industries.
Participates in developing a strategic technical strategy.
Creates and delivers presentations.
Able to plan and implement projects using sound project management methodology.
DSS Data Base Administration:
Responsible for conducting enterprise level server, OS, and RDBMS research and staying in tune with industry best practices for the development of business intelligence solutions.
Develops strategies for data acquisitions, archive recovery, and implementation of a database.
Cleans and maintains databases by removing and deleting old data.
Writes code for database access, modifications, and constructions including stored procedures.
Designs, develops, and manipulates DSS Databases, Data Stores, Data Marts, and Data Warehouse(s).
Implements data models and database designs, data access and table maintenance codes.
Responsible for production support, resolving database performance issues, database capacity issues, replication, other distributed data issues, and server security.
Monitors and troubleshoots database and application environments.
Monitors ongoing projects with status reports to management.
Learn area?s direct flow; and how it affects surrounding systems and operational areas.
Ensures overall health and performance of databases, data marts, data stores, and data warehouses.
Monitors performance, reliability, availability, capacity, and recoverability.
Maps logical data models to physical data models.
Administers user access protocol.
Responsible for production cycles, solving abends and notification of problems.
Documentation of database applications, server applications, and security policies/procedures, programs, systems, manuals, etc.
Review code for proper design, standards, content and functionality.
Program in multiple programming languages (SQL, VB.net, 3GL/4GL).
Designs, implements, and tunes database schemas
Conducts regular performance testing and tuning
Manages storage space and memory
Implements and maintains operational and disaster recovery procedures
Capacity planning
Optimizes database partitions
Creates and optimizes physical tables and partitions
Implements dimensional models, including aggregation and indexing strategies.
Manages user accounts and access privileges
Implements vendor software patches
Analysis of usage patterns and downtime
Metadata management
Logs technical action reports
Document configuration and integration with application and network resources
Maintains back-up and recovery documentation
Design complex systems, including interfaces, and data mapping.
Develop system flows for complex systems, including interfaces, and metadata.
Develop hardware and software requirements
Develop time estimates and project schedules based on prioritization and business requirements.
Represent area in internal meetings.
Writes or modifies procedures for internal use, user operational areas, and computer operations, as applicable.
Utilize ODBC and OLE DB methodology.
Computer Responsibility
Complies with BCBSAZ Computer Responsibility Agreement. Employees with Internet access are required to comply with the Internet Policies Agreement.
Applies appropriate security and privacy measures to all tasks.
Applies information security policies, principles and practices in the delivery of all IT services.
So start learning this things, bcos if you get a job, it waits you a lot of work to do.
I would add some things to this list, good knowledge and understanding of BPM, ERP, CRM, Accounting and some products like Cognos, Informatica and SAP.
-------------------------------------------------------------
"It takes 15 minutes to learn the game and a lifetime to master"
"Share your knowledge. It's a way to achieve immortality."
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply