SQL DBA Analyst

ANURADHA B
| E-Mail: smilear2015@gmail.com | Phone :001-(626)-872-3424
 
 
Database Administrator and Data Analyst with over 8 years of experience in providing Technical, Application and Analytical support to solve business problems. Experience in developing and monitoring databases using SQL and perform reporting/analysis to track client’s businesses. Possess MBA degree in Financial Management and Google Analytics Certificate (2016).
 
KEY TECHNICAL SKILLS
Database Domain: Database Administration of MS SQL Server 2012/2008R2/2008/2005/2000, MySQL
Web Domain: HTML5, CSS3, JavaScript, JQuery, Bootsrap.css, AJAX, Node.js, Dreamweaver, Adminer, WordPress, NetBeans, Maven, Eclipse, Apache Tomcat and MySQL Query Browser
Web Management Skills: Website Development, Frontend Development, Testing & Validation, Connectivity to Backend, Web Hosting
Tools  :RDP, SSH ,Jenzabar EX,PowerFaids, ACS,CashNet, SQL Plus, Putty, SQL Enterprise Manager, SQL Query Analyzer, SQL Server Management Studio 2005,2008 and 2012,MS Word, MS Excel, MS PowerPoint, Google Drives, SQL Profiler, SSRS, Zoom
Business Intelligence   : SSRS, Crystal Reports, InfoMaker, Jenbazar EX Reports (JRM)
Analytics: Google Analytics Certificate
Databases & Skills      :SQL Server 2008/2005/2000/7.0,MS Access, Databases & Server Installations, DTS Packages, Jobs Scheduling, Database Objects, Backup, Recovery, Log Shipping, Reporting, MS Office, Excel, Google Docs, Drives, Replication, Data Migration, Upgrading, Data Migration procedures.
 
PROFESSIONAL EXPERIENCE
Berryessa School Union District, CA                                                                                        Nov 2014 – Present
Classified Paraeducator
·         Student Safety and Behavior Management
·         Classroom/Academic Support
·         Record Keeping and Communications
 
Menlo College, Atherton CA                                                                                                   July 2014 – Oct 2014
SQL DBA /Web application Administrator
 
Environment: SQL Server 2008, ERP Environment, Jenzabar, Cash Net application & Integration
·         Was responsible for management of our central administrative systems (nearly 22 databases for different applications).This includes our central ERP, Jenzabar EX, which is based largely on Microsoft SQL Server,systems that connect to this system which include financial aid software (Powerfaids), meal cards (CBORD Odyssey), ACS, CashNet and recruiting (Jenzabar Recruitment Manager) are also under the purview of this position.
·         Handled all Database administration tasks and was the key contact from all the application teams for reports ,analysis or any structural changes in the database side of the application
·         Generation of reports from the ERP as needed by various departments on campus using Crystal Reports, SSRS and Infomaker
·         As an Administrator worked closely with the entire Office of Information Technology (OIT) team, and especially with the Systems Manager and the Business Operations Manager to meet their requirements
·         Handled the interconnectivity between different departments and reported directly to the Chief Information Officer
 
Cygnus Technology Inc, SFO CA                                                                                            Jan 2014 –July 2014
Software Configuration Web Analyst/MySQL Administrator
 
Environment: My SQL , Apache TomCat , Putty, HTML, CSS, JS,Netbans,Eclipse.

• Managed the SCM duties such as building the offshore .js scripts in Eclipse, NetBeans and deploying it in Apache Tomcat.
• Performed the SVN Update, SVN Commit, SVN Switch as per need basis, Testing the HTML pages
• Working experience in HTML5 and CSS3 in the web development.
• Involved in creation of new users using the vi commands, assigning permissions for the folders using the vi editors. Coordinating with the offshore team calls and issue resolution
• Installation of MySQL server and management of the databases with Apache Tomcat server, NetBeans, Eclipse, JDK, Infomaker and knowledge of Crystal Reporting.

• Hands on experience in SQL Server Report Wizard, created custom reports, managed security of reports, handled Query analyzer of reports, installation of SQL Reporting services 2008,Formatting of Reports, deployments of reports and also handled Email and File sharing subscriptions in SSRS 2008.
• Database Administration (Managing the Database objects)-Created Tables, Constraints, Indexes, Synonyms, Views, handled Replication, Log Shipping and Database Mirroring, data migration from SQL Server 2005 to SQL Server,SQL Profiler for monitoring server.
• Worked in Google Drives, Google Sites, Google Docs, configuring the Database Mail to SMTP servers.  

• Responsible for installing, configuring MS SQL Server 2008 servers and databases, Service packs, configuration, tuning and provide support to all test/development servers and implemented database structural changes and replication. Designed and implemented Backup plan and disaster recovery.
• Reconfigured the default locations of the data files, log files and error log files
• Worked on all database administrations tasks –creation, maintaining, automating scripts, users, databases, jobs and monitoring Event viewer, SQL Error logs and Log File Viewer.

• Configuring MS SQL Server 2005,2008 servers and databases, configuration, tuning and provide support to all Test and development servers, Data Migration of SQL Servers 2000 – 2005 and trouble shooting database connectivity issues from the web applications.
• Managing the Database objects [Tables, Constraints, Indexes, Synonyms, Views] and Users/Logins and Export /Importing schemas, Users, Objects, Databases.

• Worked in SQL Server 2000 and 2005 databases and the corresponding database objects- tables, views, constraints, jobs, permissions, users, roles, logins.
• Was the Secondary DBA for MasterCard’s Main Budget ,Employee and Cost Tracking Environment – Change point
• Recipient of “Five Star Award” and “High Five Award” from MasterCard Client.

• MBA in Financial Management, May 2013
• Bachelor of Engineering (Computer Science)  May 2004