Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
Back
SQLServerCentral
Register
Home
»
SQLServerCentral.com
»
SQLServerCentral.com Website Issues
»
Interview with someone that works with...
Interview with someone that works with Databases / SQL server
Post reply
Like
146
Add to Briefcase
Interview with someone that works with Databases / SQL server
View
Options
Author
Message
nnennajn1
nnennajn1
Posted 2 years ago
#1886712
SSC-Enthusiastic
Group: General Forum Members
Points: 120
Visits: 11
Hello all,
I am a current student here at the University of Washignton, Seattle USA who intends to start a career in Database Management/ Administration in the healthcare setting.
I am looking for someone who is currently working with Databases especially SQL server that will be willing to do a student-led interview to share their experiences and answer some questions an aspiring developer might have.
The goal of this interview is to learn more about the role that database developers play. Your experiences working with databases currently, in the past and as well as future aspirations are critical tools that young aspiring developers admire.
I got questions and am curious to learn more .
Looking forwards to hearing from you and thank you for your time.
Joan
14
Quote
danny_dba
danny_dba
Posted 2 years ago
#1887173
SSC Veteran
Group: General Forum Members
Points: 238
Visits: 220
Hi Joan,
I'm a DBA Manager currently with 10 years experience and history of working in healthcare. The teams i manage look after SQL Server, Oracle and MongoDB, but we're mostly a SQL Server shop at the moment.
Happy to help someone trying to learn, although i'm not sure what i can publicly post depending on your questions!!
Thanks,
Dan
25
Quote
bmg002
bmg002
Posted 2 years ago
#1887193
SSC-Insane
Group: General Forum Members
Points: 21149
Visits: 2753
I can answer some questions too. I'm kind of like Danny_Dba though in that there are some questions I wont' be able to answer.
I have been a DBA for 7 years roughly and I learn something new every day. I try to either learn something new OR tackle a new problem each day.
My overall duties include database administration, code verification, code release, code creation, and server maintenance. With server mainteance, that covers things like windows updates, CPU and memory management, CPU and memory requirement recommendations, HA/DR setup and maintenance. Code related things includes SQL code, C# code, VB 6 code, source control management (both the software updates and the managing of the projects and merges and such). Database administration is things like backup/restores, user creation/removal, optimizations to existing code, managing blocking/deadlocks, etc.
And on top of that, I try to find time to do some training. Training videos, blog posts, forums, etc. I try to learn or share my knowledge a bit if I can.
If you have any specific questions though, feel free to post them and I (and I expect others) will do their best to answer them.
21
Quote
nnennajn1
nnennajn1
Posted 2 years ago
#1887239
SSC-Enthusiastic
Group: General Forum Members
Points: 120
Visits: 11
Hi Danny_dba and bmg002,
Thank you so much for your response to my post and your willingness to share your experiences with me . I will go ahead and add the questions to this reply . So both of you can post your answers . Should you prefer to answer any via e-mail, do let me know. Here the questions:
1.What is your education, experience and current position?
2. Did you always work in a similar job, or did you transition from another field?
3. How did you transition to healthcare IT?
4. What sort of tasks do you do daily, weekly, infrequently?
5. What do you like about this work?
6. What software languages do you know?
7. What are some useful non-SQL skills you have learned that has helped you in this career?
8. What are some of the different database programs you have used?
9. What do you recommend I study/learn/practice to prepare for a position working with databases?
10. If you had a choice, will you have done some other career besides database analyst?
11. Is there a difference between Clinical Analyst, Business Analyst and Database Analyst?
12. What is database and who are the most important users of datas.
13. So far in this introduction course to Foundations of database management, I have noticed it requires focus and attention to detail. Can you share with me how you troubleshoot problems in your current role?
14. What are your favorite resources for troubleshooting or learning new skills?
15. What is your greatest motivation in this career that keeps you going?
Thanks again for your professionalism and support.
Joan
24
Quote
bmg002
bmg002
Posted 2 years ago
#1887240
SSC-Insane
Group: General Forum Members
Points: 21149
Visits: 2753
1 - My education is some university, no degree. Plus I got my MTA in database fundamentals. Experience is 7 years as a database administrator and current position database administrator
2 - I started with minimum wage jobs, then moved to a production assembler (soldering circuit boards mostly), then moved to IT and finally ended in a DBA career
3 - I am actually not in healthcare. I misread your post as that being a requirement. Sorry. I work in the manufacturing industry
4 - daily, I monitor the SQL databases, write C# code, update software/servers, and write/manage reports. Weekly, I verify the SQL backups and infrequently I repair bad SQL servers
5 - I enjoy the challenge of providing end users with the data they require and trying to get that from what they ask for
6 - I know TSQL, C#, VB, vbscript, bat, some powershell,
7 - basic IT troubleshooting has helped a lot. It is helpful when an end user reports that something is "slow" or "not working" to be able to determine if the problem is actually the database or something unrelated.
8 - I have only worked with SQL Server
9 - I think that depends on the company. Where I work, getting my foot in the door as a production assembler helped me to get up to being a DBA. If you are unable to get a job somewhere where you can prove you CAN do the DBA work, I'd look at the requirements that potential employers are asking for. If they are looking for a university degree, get that. If they don't, look at what they are looking for and learn that. Knowing backup and recovery as well as various HA/DR solutions will help you get a job as a junior DBA. That and knowing SSIS, SSRS and even SSAS.
10 - I enjoy being a DBA. The main reason I left IT was I was starting to find it very repetitive. DBA work is a LOT less repetitive than IT work.
11 - I am not sure what a "Clinical Analyst" is, but from my understanding, a busness analyst focuses more on the busniess end of things and tends to build more reports for end users. A database analyst would focus more on the administration side of things like building new databases
12 - I don't really understand the firt part of the question, but for the second, he most important users of the data are the end users. As a DBA, I don't care much about what the actual data IS in the database, as long as the end users can get it and I can provide them with what they need. Having a 5 in the 3rd row, 5th column or a 10 in that field makes no difference to me as long as the data still makes sense.
13 - Troubleshooting problems depends entirely on the problem. For example, if a service broker queue goes down, you need to know how to get it back up as quickly as you can. It could be a deadlock in which case turning it back on may just work. Or it could be a foreign key violation and you may need to disable a trigger to get the data to insert and manually adjust the message to get it to insert. We have a lot of SSIS packages that run nightly and we had one fail last night. I figured out the issue, contacted the developer of the package and asked them to work with the end user to resolve it. Had they not been here, I would have had to figure out how best to resolve that problem. It was a "divide by 0" error.
14 - favorite resource for troubleshooting... that is an interesting one. built in DMV's are good, profiler is good, database health monitor is good, redgate SQL Monitor is good... those are my main go-to for troubleshooting... if all of those fail me, I post on this forum. As for learning new skills, a lot of it is just trial and error. Or posting on this forum.
15 - greatest motivation is money. It sounds petty, but it is really the reason I do my job. That and I enjoy the challenges that sometimes come up. Like making a 5 minute SQL query run in less than 1 second? That is fun. I have always enjoyed optimizing code and I am getting better every day when I read my own old code.
I hope my answers help, even though I am not in the health care industry.
21
Quote
nnennajn1
nnennajn1
Posted 2 years ago
#1887764
SSC-Enthusiastic
Group: General Forum Members
Points: 120
Visits: 11
Hello bmg002,
Thank you so much for your response and taking time to candidly answer the questions . Your professionalism and passion to keep it going is inspiring. It's great learning that while IT is repetitive , DBA is not . This helps me a lot since I enjoy versatility.
Once again, thank you so much for being a great example to me as well as future database administrators.
Joan
20
Quote
bmg002
bmg002
Posted 2 years ago
#1887771
SSC-Insane
Group: General Forum Members
Points: 21149
Visits: 2753
No problem. As for IT being repetitive, it depends on where you work as well. Where I work, I was slowly building up a list of canned responses to people and was not really "thinking" in my job. When this starts happening, I start handing out resumes. I need to be challenged at my job or I get bored.
As a DBA, I find I am challenged a lot more. Plus my boss is good at keeping me busy. But having the IT background is also helpful. When I see something break, my first thought isn't that the database is bad. My first thought is "lets gather evidence of what happened and why and then decide how best to solve it". Sometimes it means re-running a SQL job. Sometimes it means rebooting a VM. Sometimes it means doing nothing (for me) as the problem isn't related to the database or software I manage.
If you are thinking of working in the IT industry (including being a DBA), one of the best resources for troubleshooting is the logs. When somebody reports a problem, check the logs. Doesn't matter what software it is. Find the logs, and read them.
Also, before posting any logs or SQL code online, always make sure you are allowed to. That is, that it doesn't contain any company proprietary data.
21
Quote
Go
Post reply
Like
146
Add to Briefcase
Post quoted reply
Permissions
You
can't
post new topics.
You
can't
post topic replies.
You
can't
post new polls.
You
can't
post replies to polls.
You
can't
edit your own topics.
You
can't
delete your own topics.
You
can't
edit other topics.
You
can't
delete other topics.
You
can't
edit your own posts.
You
can't
edit other posts.
You
can't
delete your own posts.
You
can't
delete other posts.
You
can't
post events.
You
can't
edit your own events.
You
can't
edit other events.
You
can't
delete your own events.
You
can't
delete other events.
You
can't
send private messages.
You
can't
send emails.
You
can
read topics.
You
can't
vote in polls.
You
can't
upload attachments.
You
can
download attachments.
You
can't
post HTML code.
You
can't
edit HTML code.
You
can't
post IFCode.
You
can't
post JavaScript.
You
can
post emoticons.
You
can't
post or upload images.
Select a forum
SQL Server 2017
SQL Server 2017 - Administration
SQL Server 2017 - Development
SQL Server 2016
SQL Server 2016 - Administration
SQL Server 2016 - Development and T-SQL
SQL Server 2014
Administration - SQL Server 2014
Development - SQL Server 2014
SQL Server 2012
SQL 2012 - General
SQL Server 2012 - T-SQL
SQL Server vNext
SQL Server 15 - Administration
SQL Server 15 - Development
SQL Server 2008
SQL Server 2008 - General
T-SQL (SS2K8)
June 2007 CTP
Working with Oracle
July CTP
SQL Server Newbies
Security (SS2K8)
SQL Server 2008 High Availability
SQL Server 2008 Administration
Data Corruption (SS2K8 / SS2K8 R2)
SQL Server 2008 Performance Tuning
Cloud Computing
SQL Azure - Development
SQL Azure - Administration
Amazon AWS and other cloud vendors
General Cloud Computing Questions
CosmosDB
Azure Data Lake
Azure Machine Learning
Azure Data Factory
Reporting Services
Reporting Services
Reporting Services 2005 Administration
Reporting Services 2005 Development
Reporting Services 2008/R2 Administration
Reporting Services 2008 Development
SSRS 2012
SSRS 2014
SSRS 2016
Programming
Connecting
General
SMO/RMO/DMO
XML
Service Broker
Powershell
Testing
TFS/Data Dude/DBPro
SSDT
Continuous Integration, Deployment, and Delivery
R Services and R Language
Data Warehousing
Integration Services
Strategies and Ideas
Analysis Services
Data Transformation Services (DTS)
Performance Point
Data Mining
PowerPivot
R language
Machine Learning
Database Design
Disaster Recovery
Design Ideas and Questions
Relational Theory
Hardware
Virtualization
Security and Auditing
SQLServerCentral.com
Anything that is NOT about SQL!
Contests!
Editorials
SQLServerCentral.com Announcements
SQLServerCentral.com Website Issues
Suggestions
Tag Issues with Content
Podcast Feedback
SQLServerCentral.com Test Forum
Articles Requested
SQL Server 2005
Administering
Backups
Business Intelligence
CLR Integration and Programming.
Data Corruption
Development
Working with Oracle
SQL Server 2005 Compact Edition
SQL Server 2005 General Discussion
SQL Server 2005 Security
SQL Server 2005 Strategies
SS2K5 Replication
SQL Server Express
SQL Server 2005 Performance Tuning
SQL Server 2005 Integration Services
T-SQL (SS2K5)
SQL Server Newbies
SQL Server 7,2000
Administration
Backups
Data Corruption
General
Globalization
In The Enterprise
Working with Oracle
Security
Strategies
SQL Server Newbies
Service Packs
SQL Server CE
Performance Tuning
Replication
Sarbanes-Oxley
T-SQL
SQL Server Agent
SQL Server and other platforms
MySQL
Oracle
PostgreSQL
DB2
SQL Server and Sharepoint
Older Versions of SQL (v6.5, v6.0, v4.2)
Older Versions of SQL (v6.5, v6.0, v4.2)
Career
Certification
Employers and Employees
Events
Job Postings
Resumes and Job Hunters
Presentations and Speaking
Retired Members
Testing Center
SQL Server Security Skills
Question of the Day (QOD)
Microsoft Access
Microsoft Access
Products and Books
Third Party Products
CA
SQLCentric
Extreme Technologies.
Innovartis
Embarcadero
SQL Sentry
Sonasoft
Golden Gate Software
Lumigent
Red Gate Software
Quest Software
ApexSQL
Idera
Discussions about Books
Discuss Programming Books
Discuss XML Books
Discuss T-SQL Books
Discuss Data Warehousing Books
Discuss DTS Books
Discuss SQL Server 7.0 Books
Discuss SQL Server 2000 Books
Notification Services
Administration
Article Discussions
Future Versions
SQL 12
Narrow your search by forum
Explore
Home
Latest
Popular
Calendar
Members
Who's on
Moderators
Forums
SQL Server 2017
SQL Server 2017 - Administration
SQL Server 2017 - Development
SQL Server 2016
SQL Server 2016 - Administration
SQL Server 2016 - Development and T-SQL
SQL Server 2014
Administration - SQL Server 2014
Development - SQL Server 2014
SQL Server 2012
SQL 2012 - General
SQL Server 2012 - T-SQL
SQL Server vNext
SQL Server 15 - Administration
SQL Server 15 - Development
SQL Server 2008
SQL Server 2008 - General
T-SQL (SS2K8)
June 2007 CTP
Working with Oracle
July CTP
SQL Server Newbies
Security (SS2K8)
SQL Server 2008 High Availability
SQL Server 2008 Administration
Data Corruption (SS2K8 / SS2K8 R2)
SQL Server 2008 Performance Tuning
Cloud Computing
SQL Azure - Development
SQL Azure - Administration
Amazon AWS and other cloud vendors
General Cloud Computing Questions
CosmosDB
Azure Data Lake
Azure Machine Learning
Azure Data Factory
Reporting Services
Reporting Services
Reporting Services 2005 Administration
Reporting Services 2005 Development
Reporting Services 2008/R2 Administration
Reporting Services 2008 Development
SSRS 2012
SSRS 2014
SSRS 2016
Programming
Connecting
General
SMO/RMO/DMO
XML
Service Broker
Powershell
Testing
TFS/Data Dude/DBPro
SSDT
Continuous Integration, Deployment, and Delivery
R Services and R Language
Data Warehousing
Integration Services
Strategies and Ideas
Analysis Services
Data Transformation Services (DTS)
Performance Point
Data Mining
PowerPivot
R language
Machine Learning
Database Design
Disaster Recovery
Design Ideas and Questions
Relational Theory
Hardware
Virtualization
Security and Auditing
SQLServerCentral.com
Anything that is NOT about SQL!
Contests!
Editorials
SQLServerCentral.com Announcements
SQLServerCentral.com Website Issues
Suggestions
Tag Issues with Content
Podcast Feedback
SQLServerCentral.com Test Forum
Articles Requested
SQL Server 2005
Administering
Backups
Business Intelligence
CLR Integration and Programming.
Data Corruption
Development
Working with Oracle
SQL Server 2005 Compact Edition
SQL Server 2005 General Discussion
SQL Server 2005 Security
SQL Server 2005 Strategies
SS2K5 Replication
SQL Server Express
SQL Server 2005 Performance Tuning
SQL Server 2005 Integration Services
T-SQL (SS2K5)
SQL Server Newbies
SQL Server 7,2000
Administration
Backups
Data Corruption
General
Globalization
In The Enterprise
Working with Oracle
Security
Strategies
SQL Server Newbies
Service Packs
SQL Server CE
Performance Tuning
Replication
Sarbanes-Oxley
T-SQL
SQL Server Agent
SQL Server and other platforms
MySQL
Oracle
PostgreSQL
DB2
SQL Server and Sharepoint
Older Versions of SQL (v6.5, v6.0, v4.2)
Older Versions of SQL (v6.5, v6.0, v4.2)
Career
Certification
Employers and Employees
Events
Job Postings
Resumes and Job Hunters
Presentations and Speaking
Retired Members
Testing Center
SQL Server Security Skills
Question of the Day (QOD)
Microsoft Access
Microsoft Access
Products and Books
Third Party Products
CA
SQLCentric
Extreme Technologies.
Innovartis
Embarcadero
SQL Sentry
Sonasoft
Golden Gate Software
Lumigent
Red Gate Software
Quest Software
ApexSQL
Idera
Discussions about Books
Discuss Programming Books
Discuss XML Books
Discuss T-SQL Books
Discuss Data Warehousing Books
Discuss DTS Books
Discuss SQL Server 7.0 Books
Discuss SQL Server 2000 Books
Notification Services
Administration
Article Discussions
Future Versions
SQL 12
SQLServerCentral
Register
Search
Narrow your search by forum
Unthreaded, ascending
Unthreaded, descending
Subscribe to topic
Print topic
RSS feed
Go to topics forum
Jump to page
Jump to page
Copyright © 2002-2019 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.